APPS.PQP_NL_PGGM_PENSION_EXTRACTS dependencies on PAY_US_RPT_TOTALS

Line 1819: DELETE FROM pay_us_rpt_totals

1815:
1816: SELECT Userenv('SESSIONID') INTO l_session_id FROM dual;
1817:
1818: -- Delete values from the temporary table
1819: DELETE FROM pay_us_rpt_totals
1820: WHERE organization_name = 'NL PGGM Pension Extracts';
1821:
1822: --
1823: -- Insert into pay_us_rpt_totals so that we can refer to these parameters

Line 1823: -- Insert into pay_us_rpt_totals so that we can refer to these parameters

1819: DELETE FROM pay_us_rpt_totals
1820: WHERE organization_name = 'NL PGGM Pension Extracts';
1821:
1822: --
1823: -- Insert into pay_us_rpt_totals so that we can refer to these parameters
1824: -- when we call the criteria formula for the pension extract.
1825: --
1826: hr_utility.set_location('inserting into rpt totals : '||p_business_group_id,20);
1827: INSERT INTO pay_us_rpt_totals

Line 1827: INSERT INTO pay_us_rpt_totals

1823: -- Insert into pay_us_rpt_totals so that we can refer to these parameters
1824: -- when we call the criteria formula for the pension extract.
1825: --
1826: hr_utility.set_location('inserting into rpt totals : '||p_business_group_id,20);
1827: INSERT INTO pay_us_rpt_totals
1828: (session_id -- Session id
1829: ,organization_name -- Concurrent Program Name
1830: ,business_group_id -- Business Group
1831: ,tax_unit_id -- Concurrent Request Id

Line 1926: FROM pay_us_rpt_totals

1922: ,attribute2 --
1923: ,attribute3 -- Extract Start Date
1924: ,attribute4 -- Extract End Date
1925: ,attribute5 -- Type of Extract
1926: FROM pay_us_rpt_totals
1927: WHERE tax_unit_id = c_request_id
1928: AND value1 = c_ext_dfn_id
1929: AND business_group_id = c_business_group_id;
1930: