eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_NL_PENSION_EXTRACTS dependencies on PAY_US_RPT_TOTALS

Line 1269: DELETE FROM pay_us_rpt_totals

1265:
1266: SELECT Userenv('SESSIONID') INTO l_session_id FROM dual;
1267:
1268: -- Delete values from the temporary table
1269: DELETE FROM pay_us_rpt_totals
1270: WHERE organization_name = 'NL ABP Pension Extracts';
1271:
1272: --
1273: -- Insert into pay_us_rpt_totals so that we can refer to these parameters

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

1269: DELETE FROM pay_us_rpt_totals
1270: WHERE organization_name = 'NL ABP Pension Extracts';
1271:
1272: --
1273: -- Insert into pay_us_rpt_totals so that we can refer to these parameters
1274: -- when we call the criteria formula for the pension extract.
1275: --
1276: IF g_debug THEN
1277: hr_utility.set_location('inserting into rpt totals : '||p_business_group_id,20);

Line 1280: INSERT INTO pay_us_rpt_totals

1276: IF g_debug THEN
1277: hr_utility.set_location('inserting into rpt totals : '||p_business_group_id,20);
1278: END IF;
1279:
1280: INSERT INTO pay_us_rpt_totals
1281: (session_id -- Session id
1282: ,organization_name -- Concurrent Program Name
1283: ,business_group_id -- Business Group
1284: ,tax_unit_id -- Concurrent Request Id

Line 5513: FROM pay_us_rpt_totals

5509: ,attribute2 --
5510: ,attribute3 -- Extract Start Date
5511: ,attribute4 -- Extract End Date
5512: ,attribute5 -- Extract Record 01 Flag
5513: FROM pay_us_rpt_totals
5514: WHERE tax_unit_id = c_request_id
5515: AND value1 = c_ext_dfn_id
5516: AND business_group_id = c_business_group_id;
5517: --