23: the PL/SQL Table
24:
25: Name :This package defines the cursors needed for OLT to run Multi-Threaded
26: This loads all the records that will appear in the report. This
27: data is being stored in pay_us_rpt_totals table.
28:
29: Uses :
30:
31: Change List
889: and ppf.person_id = paf.person_id
890: and p_as_of_date between ppf.effective_start_date and ppf.effective_end_date;
891: end if;
892:
893: insert into pay_us_rpt_totals
894: ( attribute2, -- :PACTID
895: session_id,
896: tax_unit_id,
897: gre_name, organization_name,
928: ,l_last_name
929: ,l_ssn
930: );
931:
932: hr_utility.trace('Inserting a record in pay_us_rpt_totals for the employee ' ||l_last_name || ' ' ||
933: l_first_name );
934: hr_utility.trace('Inserted chunk number ' ||p_chnkno || ' for tax type ' || l_state_tax_type );
935:
936: end if;
1352: and p_as_of_date between ppf.effective_start_date and ppf.effective_end_date;
1353:
1354: end if;
1355:
1356: insert into pay_us_rpt_totals
1357: ( attribute2 -- :PACTID
1358: ,session_id
1359: ,tax_unit_id
1360: ,gre_name, organization_name, location_name
1388: ,l_middle_name
1389: ,l_last_name
1390: ,l_ssn
1391: );
1392: hr_utility.trace('Inserting a record in pay_us_rpt_totals for the employee ' ||l_last_name || ' ' || l_first_name
1393: );
1394: hr_utility.trace('Inserted chunk number ' ||p_chnkno || ' for tax type ' || l_fed_tax_type );
1395: end if; -- over limit > 0
1396: