| '||TO_CHAR(TO_DATE(j.INVOICE_DATE,'DD-MON-YYYY'),'DD-MON-YYYY'||' |
declare
V_FROM_DATE varchar2(30);
V_PTO_DATE varchar2(30);
begin
htp.p('
');
select to_char(to_date(:P7_FROM,'DD-MON-YYYY'),'DD-Mon-YYYY') FROM_DATE,
to_char(to_date(:P7_TO,'DD-MON-YYYY'),'DD-Mon-YYYY') PTO_DATE
into V_FROM_DATE,V_PTO_DATE
from dual;
for i in (
SELECT COMPANY_ID, COMPANY_NAME, COMPANY_ADDRESS
--INTO V_COMPANY_NAME,V_COMPANY_ADDRESS,V_FROM_DATE,V_PTO_DATE
FROM SUB_COMPANY
where COMPANY_ID=:P7_COMPANAY
)
loop
htp.p('
'||i.COMPANY_NAME||'
'||i.COMPANY_ADDRESS||'
VAT Returns Report
| |
|
');
end Loop;
exception
when no_data_found then
null;
end;
');
select to_char(to_date(:P7_FROM,'DD-MON-YYYY'),'DD-Mon-YYYY') FROM_DATE,
to_char(to_date(:P7_TO,'DD-MON-YYYY'),'DD-Mon-YYYY') PTO_DATE
into V_FROM_DATE,V_PTO_DATE
from dual;
for i in (
SELECT COMPANY_ID, COMPANY_NAME, COMPANY_ADDRESS
--INTO V_COMPANY_NAME,V_COMPANY_ADDRESS,V_FROM_DATE,V_PTO_DATE
FROM SUB_COMPANY
where COMPANY_ID=:P7_COMPANAY
)
loop
htp.p('
'||i.COMPANY_NAME||'
'||i.COMPANY_ADDRESS||'
VAT Returns Report
| |
|
');
end Loop;
exception
when no_data_found then
null;
end;