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.

[Home] [Help]

APPS.PQP_NL_PENSION_EXTRACTS dependencies on PAY_US_RPT_TOTALS

Line 1290: DELETE FROM pay_us_rpt_totals

1286:
1287: SELECT Userenv('SESSIONID') INTO l_session_id FROM dual;
1288:
1289: -- Delete values from the temporary table
1290: DELETE FROM pay_us_rpt_totals
1291: WHERE organization_name = 'NL ABP Pension Extracts';
1292:
1293: --
1294: -- Insert into pay_us_rpt_totals so that we can refer to these parameters

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

1290: DELETE FROM pay_us_rpt_totals
1291: WHERE organization_name = 'NL ABP Pension Extracts';
1292:
1293: --
1294: -- Insert into pay_us_rpt_totals so that we can refer to these parameters
1295: -- when we call the criteria formula for the pension extract.
1296: --
1297: IF g_debug THEN
1298: hr_utility.set_location('inserting into rpt totals : '||p_business_group_id,20);

Line 1301: INSERT INTO pay_us_rpt_totals

1297: IF g_debug THEN
1298: hr_utility.set_location('inserting into rpt totals : '||p_business_group_id,20);
1299: END IF;
1300:
1301: INSERT INTO pay_us_rpt_totals
1302: (session_id -- Session id
1303: ,organization_name -- Concurrent Program Name
1304: ,business_group_id -- Business Group
1305: ,tax_unit_id -- Concurrent Request Id

Line 5702: FROM pay_us_rpt_totals

5698: ,attribute2 --
5699: ,attribute3 -- Extract Start Date
5700: ,attribute4 -- Extract End Date
5701: ,attribute5 -- Extract Record 01 Flag
5702: FROM pay_us_rpt_totals
5703: WHERE tax_unit_id = c_request_id
5704: AND value1 = c_ext_dfn_id
5705: AND business_group_id = c_business_group_id;
5706: --