Почему возникает ошибка о том, что я второй раз создаю таблицу

DECLARE @C_Subscrs              VARCHAR(MAX) = ''
, @C_Consumers              VARCHAR(MAX) = ''
, @C_Contract_Number        VARCHAR(255) = ''
, @B_Debug BIT = 0
, @Date0 DATE = GETDATE()
, @Date1 DATE = GETDATE()
, @B_TSO BIT = 0
 
BEGIN  
    IF OBJECT_ID ('tempdb.dbo.#RPT_Partners') IS NOT NULL DROP TABLE #RPT_Partners
    CREATE TABLE #RPT_Partners (
        F_Partners  UNIQUEIDENTIFIER
    )
    CREATE CLUSTERED INDEX IDX_RPT_Partners ON #RPT_Partners (F_Partners)
    
    DECLARE @B_Partners_Filter BIT  = 1             
    INSERT #RPT_Partners (F_Partners)
    SELECT cp.LINK
    FROM dbo.CD_Partners AS cp
    INNER JOIN dbo.SF_Text_To_GuidTable(@C_Consumers) AS t
        ON t.LINK                   = cp.LINK
    WHERE   @C_Consumers            <> N'0'
        AND (cp.C_Name3             = @C_Contract_Number OR @C_Contract_Number  IS NULL)
        
    UNION ALL
            SELECT cp.LINK
    FROM dbo.CD_Partners AS cp
    WHERE   @C_Consumers            = N'0'
        AND cp.C_Name3              = @C_Contract_Number
        
    IF @@ROWCOUNT = 0 SET @B_Partners_Filter = 0 
        
    IF @B_Debug = 1
        SELECT '#RPT_Partners' AS [#RPT_Partners], * FROM #RPT_Partners
 
END
 
BEGIN  
    IF OBJECT_ID ('tempdb.dbo.#RPT_Subscr') IS NOT NULL DROP TABLE #RPT_Subscr
    CREATE TABLE #RPT_Subscr (
        F_Division      TINYINT,
        F_Subscr        INT,
        N_Period        INT
    )
    CREATE CLUSTERED INDEX IDX_RPT_Subscr ON #RPT_Subscr (F_Division, F_Subscr)
    
    INSERT #RPT_Subscr (F_Division, F_Subscr, N_Period)
    SELECT ss.F_Division, ss.LINK, NULL
    FROM #RPT_Partners cp
        INNER JOIN dbo.SD_Subscr AS ss
            ON ss.F_Partners    = cp.F_Partners
        INNER JOIN #RPT_Divisions AS d
            ON d.F_Division     = ss.F_Division
            AND d.F_SubDivision = ss.F_SubDivision
        INNER JOIN dbo.SF_Text_To_Table(@C_Subscrs) AS t
            ON t.LINK           = ss.LINK
    WHERE   @C_Subscrs          <> N'0'
        AND @B_Partners_Filter  = 1
        AND ss.B_EE             = 1
        AND (SS.D_Date_End >= @Date0 OR SS.D_Date_End IS NULL)
        AND SS.D_Date_Begin <= @Date1
    UNION ALL
    
    SELECT ss.F_Division, ss.LINK, NULL
    FROM #RPT_Partners cp
        INNER JOIN dbo.SD_Subscr AS ss
            ON ss.F_Partners    = cp.F_Partners
        INNER JOIN #RPT_Divisions AS d
            ON d.F_Division     = ss.F_Division
            AND d.F_SubDivision = ss.F_SubDivision
    WHERE   @C_Subscrs          = N'0'
        AND @B_Partners_Filter  = 1
        AND ss.B_EE             = 1
        AND (SS.D_Date_End >= @Date0 OR SS.D_Date_End IS NULL)
        AND SS.D_Date_Begin <= @Date1
    UNION ALL
        
    SELECT ss.F_Division, ss.LINK, NULL
    FROM dbo.SD_Subscr AS ss
        INNER JOIN #RPT_Divisions AS d
            ON d.F_Division     = ss.F_Division
            AND d.F_SubDivision = ss.F_SubDivision
        INNER JOIN dbo.SF_Text_To_Table(@C_Subscrs) AS t
            ON t.LINK           = ss.LINK
    WHERE   @C_Subscrs          <> N'0'
        AND @B_Partners_Filter  = 0
        AND ss.B_EE             = 1
        AND (SS.D_Date_End >= @Date0 OR SS.D_Date_End IS NULL)
        AND SS.D_Date_Begin <= @Date1
    UNION ALL
            
    SELECT ss.F_Division, ss.LINK, NULL
    FROM dbo.SD_Subscr AS ss
        INNER JOIN #RPT_Divisions AS d
            ON d.F_Division     = ss.F_Division
            AND d.F_SubDivision = ss.F_SubDivision
    WHERE   @C_Subscrs          = N'0'
        AND @B_Partners_Filter  = 0 
        AND ss.B_EE             = 1
        AND (SS.D_Date_End >= @Date0 OR SS.D_Date_End IS NULL)
        AND SS.D_Date_Begin <= @Date1
    OPTION(RECOMPILE)
        
    IF @B_TSO = 1
        DELETE RS
        FROM #RPT_Subscr AS rs
        CROSS APPLY (
                SELECT TOP 1 
                    ISNULL(ssh.F_Partners       , ss.F_Partners)        AS F_Partners
                FROM dbo.SD_Subscr AS ss
                    LEFT JOIN dbo.SD_Subscr_History AS ssh
                        ON      ssh.F_Subscr        = ss.LINK
                            AND ssh.F_Division      = ss.F_Division
                            AND ssh.D_Date          <= @Date1
                WHERE   ss.F_Division               = rs.F_Division
                    AND ss.LINK                     = rs.F_Subscr
                ORDER BY ssh.D_Date DESC
            ) AS ss
            INNER JOIN dbo.CD_Partners AS cp
                ON cp.LINK          = ss.F_Partners
            LEFT JOIN dbo.CS_Partner_Roles AS cpr
                ON  cpr.N_Bit_Number_2Power & cp.N_Partner_Roles 
                                            = cp.N_Partner_Roles
                AND cpr.C_Const     IN ('CSP_TSO', 'CSP_TSO_Cost')
        WHERE cpr.LINK  IS NULL
        
    IF @B_Debug = 1
        SELECT '#RPT_Subscr' AS [#RPT_Subscr],  * FROM #RPT_Subscr
 
END 
    
BEGIN
    IF OBJECT_ID ('tempdb.dbo.#RPT_Subscr') IS NULL 
    BEGIN
        CREATE TABLE #RPT_Subscr (
            F_Division      TINYINT,
            F_Subscr        INT,
            N_Period        INT
        )
        CREATE CLUSTERED INDEX IDX_RPT_Subscr ON #RPT_Subscr (F_Division, F_Subscr)
        SET @B_IsSubscr_Filter = 0
    END
 
    IF OBJECT_ID ('tempdb.dbo.#RPT_Supplier') IS NULL 
    BEGIN
        CREATE TABLE #RPT_Supplier
        (
            F_Supplier  UNIQUEIDENTIFIER
        )
        CREATE CLUSTERED INDEX IDX_RPT_Supplier ON #RPT_Supplier (F_Supplier)
 
        INSERT INTO #RPT_Supplier
        (
            F_Supplier
        )
        SELECT '00000000-0000-0000-0000-000000000000' AS F_Supplier
    END
     
    IF OBJECT_ID ('tempdb.dbo.#ORL_RV_Network_List') IS NULL 
    BEGIN
        CREATE TABLE #ORL_RV_Network_List
        (
            F_Networks      UNIQUEIDENTIFIER PRIMARY KEY CLUSTERED
        )
 
        EXEC dbo.ORL_RV_Network_List_Prc
            @C_Networks     = '00000000-0000-0000-0000-000000000000'
    END 
 
    IF OBJECT_ID('tempdb.dbo.#FS_Sale_Item') IS NULL 
    BEGIN
        CREATE TABLE #FS_Sale_Item
        (
            F_Sale_Item     INT PRIMARY KEY CLUSTERED
        )
 
        INSERT #FS_Sale_Item (
            F_Sale_Item )
        SELECT
            fsi.LINK
        FROM dbo.FS_Sale_Items AS fsi
    END
     
    IF OBJECT_ID('tempdb.dbo.#ES_Balance_Types') IS NULL 
    BEGIN
        CREATE TABLE #ES_Balance_Types
        (
            F_Balance_Types     INT PRIMARY KEY CLUSTERED,
            C_Short_Name        VARCHAR(50)
        )
 
        INSERT #ES_Balance_Types (
            F_Balance_Types, C_Short_Name)
        SELECT
            ebt.LINK, ebt.C_Short_Name
        FROM dbo.ES_Balance_Types AS ebt
    END
     
    IF OBJECT_ID('tempdb.dbo.#ES_Balance_Type_Details') IS NULL 
    BEGIN
        CREATE TABLE #ES_Balance_Type_Details
        (
            F_Balance_Type_Details  INT PRIMARY KEY CLUSTERED,
            C_Name                  VARCHAR(50)
        )
 
        INSERT #ES_Balance_Type_Details (
            F_Balance_Type_Details, C_Name )
        SELECT
            ebtd.LINK, ebtd.C_Name
        FROM dbo.ES_Balance_Type_Details AS ebtd
    END
         
    IF OBJECT_ID('tempdb.dbo.#ES_Network_Pts_Types') IS NULL 
    BEGIN
        CREATE TABLE #ES_Network_Pts_Types
        (
            F_Network_Pts_Types INT PRIMARY KEY CLUSTERED,
            C_Name                  VARCHAR(50)
        )
 
        INSERT #ES_Network_Pts_Types (
            F_Network_Pts_Types, C_Name )
        SELECT
            enit.LINK, enit.C_Name
        FROM dbo.ES_Network_Pts_Types AS enit
    END
     
END