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_PENSION_EXTRACTS dependencies on PAY_US_RPT_TOTALS

Line 677: DELETE FROM pay_us_rpt_totals

673:
674: hr_utility.set_location('Entering: '||l_proc_name, 5);
675: g_conc_request_id := fnd_global.conc_request_id;
676: SELECT USERENV('SESSIONID') INTO l_session_id FROM dual;
677: DELETE FROM pay_us_rpt_totals
678: WHERE organization_name = 'Global Pension Extracts'
679: AND attribute30 = 'EXTRACT_COMPLETED'
680: AND business_group_id = p_business_group_id
681: AND organization_id = p_business_group_id

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

680: AND business_group_id = p_business_group_id
681: AND organization_id = p_business_group_id
682: AND location_id = p_ext_dfn_id;
683:
684: -- Insert into pay_us_rpt_totals so that we can refer to these parameters
685: -- when we call the criteria formula for the pension extract.
686: INSERT INTO pay_us_rpt_totals
687: (session_id -- session id
688: ,organization_name -- Conc. Program Name

Line 686: INSERT INTO pay_us_rpt_totals

682: AND location_id = p_ext_dfn_id;
683:
684: -- Insert into pay_us_rpt_totals so that we can refer to these parameters
685: -- when we call the criteria formula for the pension extract.
686: INSERT INTO pay_us_rpt_totals
687: (session_id -- session id
688: ,organization_name -- Conc. Program Name
689: ,business_group_id -- business group id
690: ,organization_id -- -do-

Line 744: UPDATE pay_us_rpt_totals

740: p_ext_dfn_id => p_ext_dfn_id,
741: p_effective_date => p_end_date,
742: p_business_group_id => p_business_group_id);
743:
744: UPDATE pay_us_rpt_totals
745: SET attribute30 = 'EXTRACT_COMPLETED'
746: WHERE organization_name = 'Global Pension Extracts'
747: AND tax_unit_id = g_conc_request_id
748: AND business_group_id = p_business_group_id

Line 757: UPDATE pay_us_rpt_totals

753:
754: EXCEPTION
755: WHEN Others THEN
756: hr_utility.set_location('Leaving: '||l_proc_name, 90);
757: UPDATE pay_us_rpt_totals
758: SET attribute30 = 'EXTRACT_COMPLETED'
759: WHERE organization_name = 'Global Pension Extracts'
760: AND tax_unit_id = g_conc_request_id
761: AND business_group_id = p_business_group_id

Line 4031: FROM pay_us_rpt_totals

4027: ,attribute5 -- Organization Name
4028: ,attribute6 -- Person Type
4029: ,attribute7 -- Location
4030:
4031: FROM pay_us_rpt_totals
4032: WHERE tax_unit_id = c_request_id
4033: AND value1 = c_ext_dfn_id
4034: AND business_group_id = c_business_group_id
4035: AND organization_id = c_business_group_id