SSIS Query Oracle and is getting the wrong figures

Hello Experts Exchange
I have written a SQL script to query oracle and insert data into a table.  When I run this script in SQL Developer I get the correct figures, however when I configure SSIS to run the script the figures are wrong.

I have attached a spreadsheet with the table I am building, one sheet with the figures from SQL Developer and the other sheet with the figures from SSIS.

I am running the SQL Script in a Execute SQL Task in SSIS.

This is the script I am running;

declare
    i number;
    l number;
    k number := 3;
    m number;
    sqlcmd varchar(30000);
    week_start number;
    week_end number;
    PN_INCOME Number := 0;
    table_does_not_exist exception;
    pragma exception_init(table_does_not_exist, -942);
    
Cursor C1 (PN_Week number) is
Select Sum(Z.TTL_INCOME)
From (select SI_LOC_ID, SI_YEAR, SI_WEEK,
sum((si_income1+si_income2+si_income3+si_income4+si_income5+si_income6+si_income7+si_income8+si_income9+si_income10+si_income11+si_income12+si_income13+si_income14+si_income15)-nvl(SI_VAT_TOTAL,0)) as ttl_income
, sum(si_no_transactions) as tran_cnt, sum(nvl(SI_VAT_TOTAL,0)) as vat_tot 
from SITE_INCOME 
where SI_YEAR = to_char(sysdate, 'YYYY') 
group by SI_LOC_ID, SI_YEAR, SI_WEEK, si_no_transactions) Z
Where Z.SI_Week = PN_Week
and SI_Loc_ID in (Select LG_LOC_ID from Location_Groups lg inner join locations l on lg.LG_LOC_ID = l.LOC_ID 
                  inner join Location_Group_Types lgt on lgt.LGT_ID = lg.LG_LGT_ID where lgt.LGT_DESCRIPTION = 'SCOTLAND' 
                  and store_status(l.LOC_DATE_OPENED, l.LOC_DATE_CLOSED) = 'L' and lgt.LGT_TYPE = 'R' and l.loc_loc_ty_id = 4);

Cursor C2 (PN_Month number) is
Select Sum(Z.TTL_INCOME)
From (select SI_LOC_ID, SI_YEAR, SI_WEEK,
sum((si_income1+si_income2+si_income3+si_income4+si_income5+si_income6+si_income7+si_income8+si_income9+si_income10+si_income11+si_income12+si_income13+si_income14+si_income15)-nvl(SI_VAT_TOTAL,0)) as ttl_income
, sum(si_no_transactions) as tran_cnt, sum(nvl(SI_VAT_TOTAL,0)) as vat_tot 
from SITE_INCOME 
where SI_YEAR = to_char(sysdate, 'YYYY') 
group by SI_LOC_ID, SI_YEAR, SI_WEEK, si_no_transactions) Z
Where Z.SI_Week Between (Select min(rw_week_number) from retail_weeks where rw_year = to_char(sysdate, 'YYYY') and RW_MONTH = PN_Month group by rw_month)
and (Select max(rw_week_number)  from retail_weeks where rw_year = to_char(sysdate, 'YYYY') and RW_MONTH = PN_Month group by rw_month)
and SI_Loc_ID in (Select LG_LOC_ID from Location_Groups lg inner join locations l on lg.LG_LOC_ID = l.LOC_ID 
                  inner join Location_Group_Types lgt on lgt.LGT_ID = lg.LG_LGT_ID where lgt.LGT_DESCRIPTION = 'SCOTLAND' 
                  and store_status(l.LOC_DATE_OPENED, l.LOC_DATE_CLOSED) = 'L' and lgt.LGT_TYPE = 'R' and l.loc_loc_ty_id = 4);

Cursor C3 (PN_Month1 number,PN_Month2 number) is
Select Sum(Z.TTL_INCOME)
From (select SI_LOC_ID, SI_YEAR, SI_WEEK,
sum((si_income1+si_income2+si_income3+si_income4+si_income5+si_income6+si_income7+si_income8+si_income9+si_income10+si_income11+si_income12+si_income13+si_income14+si_income15)-nvl(SI_VAT_TOTAL,0)) as ttl_income
, sum(si_no_transactions) as tran_cnt, sum(nvl(SI_VAT_TOTAL,0)) as vat_tot 
from SITE_INCOME 
where SI_YEAR = to_char(sysdate, 'YYYY') 
group by SI_LOC_ID, SI_YEAR, SI_WEEK, si_no_transactions) Z
Where Z.SI_Week Between (Select min(rw_week_number) from retail_weeks where rw_year = to_char(sysdate, 'YYYY') and RW_MONTH = PN_Month1 group by rw_month)
and (Select max(rw_week_number)  from retail_weeks where rw_year = to_char(sysdate, 'YYYY') and RW_MONTH = PN_Month2 group by rw_month)
and SI_Loc_ID in (Select LG_LOC_ID from Location_Groups lg inner join locations l on lg.LG_LOC_ID = l.LOC_ID 
                  inner join Location_Group_Types lgt on lgt.LGT_ID = lg.LG_LGT_ID where lgt.LGT_DESCRIPTION = 'SCOTLAND' 
                  and store_status(l.LOC_DATE_OPENED, l.LOC_DATE_CLOSED) = 'L' and lgt.LGT_TYPE = 'R' and l.loc_loc_ty_id = 4);

begin
        sqlcmd := 'Insert into TR_' || 'SCOTLAND' || '(OrderBy,f1)Values (7,''LFL Sales T/Y (£)'')';
        execute immediate sqlcmd;
        
        PN_INCOME:= 0;
        Open C3(1,12);
        Fetch C3 into PN_INCOME;
        Close C3;
                                    
        If PN_INCOME is Null then 
          PN_INCOME:= 0; 
                  
        END If;
        sqlcmd := 'Update TR_' || 'SCOTLAND' ||' set f2=' ||PN_INCOME|| ' Where f1 = ''LFL Sales T/Y (£)''';
        execute immediate sqlcmd;
        
        for m in 1..12 loop
          Select min(rw_week_number) into week_start from retail_weeks where rw_year = to_char(sysdate, 'YYYY') and rw_month = m group by rw_month; 
          Select max(rw_week_number) into week_end from retail_weeks where rw_year = to_char(sysdate, 'YYYY') and rw_month = m group by rw_month;
              
              for i in week_start..week_end loop
                  PN_INCOME:= 0;
                  Open C1(i);
                  Fetch C1 into PN_INCOME;
                  Close C1;
                                    
                  If PN_INCOME is Null then 
                    PN_INCOME:= 0; 
                  
                  END If;
                  
                  sqlcmd := 'Update TR_' || 'SCOTLAND' ||' set f'|| k ||' =' ||PN_INCOME|| ' Where f1 = ''LFL Sales T/Y (£)''';  
                  
                  execute immediate sqlcmd;
                  k:=k+1;
              end loop;
          
          PN_INCOME:= 0;
          Open C2(m);
          Fetch C2 into PN_INCOME;
          Close C2;
          
              
          If PN_INCOME is Null then 
          PN_INCOME:= 0; 
                        
          END If;
         
          sqlcmd := 'Update TR_' || 'SCOTLAND' ||' set f'|| k ||' =' ||PN_INCOME|| ' Where f1 = ''LFL Sales T/Y (£)''';
          execute immediate sqlcmd;
          k:=k+1;
          
        end loop;  
        
        Commit;
          
End;

Select allOpen in new window

In SSIS it is the same apart from where it says 'SCOTLAND' this is a question mark, so I can use a parameter.

Can anyone suggest why I am getting a different figure in SSIS?

Regards

SQLSearcher
SQLDeveloper-SSIS.xlsx