APPS.PQP_US_PENSION_EXTRACTS dependencies on PAY_US_RPT_TOTALS

Line 478: DELETE FROM pay_us_rpt_totals

474:
475: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
476: g_conc_request_id := Fnd_Global.conc_request_id;
477: SELECT Userenv('SESSIONID') INTO l_session_id FROM dual;
478: DELETE FROM pay_us_rpt_totals
479: WHERE organization_name = 'US Pension Extracts'
480: AND attribute30 = 'EXTRACT_COMPLETED'
481: AND organization_id = p_business_group_id
482: AND business_group_id = p_business_group_id

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

480: AND attribute30 = 'EXTRACT_COMPLETED'
481: AND organization_id = p_business_group_id
482: AND business_group_id = p_business_group_id
483: AND location_id = p_ext_dfn_id;
484: -- Insert into pay_us_rpt_totals so that we can refer to these parameters
485: -- when we call the criteria formula for the pension extract.
486: --
487: INSERT INTO pay_us_rpt_totals
488: (session_id -- session id

Line 487: INSERT INTO pay_us_rpt_totals

483: AND location_id = p_ext_dfn_id;
484: -- Insert into pay_us_rpt_totals so that we can refer to these parameters
485: -- when we call the criteria formula for the pension extract.
486: --
487: INSERT INTO pay_us_rpt_totals
488: (session_id -- session id
489: ,organization_name -- Conc. Program Name
490: ,organization_id -- business group id
491: ,business_group_id -- -do-

Line 540: UPDATE pay_us_rpt_totals

536: p_ext_dfn_id => p_ext_dfn_id,
537: p_effective_date => p_end_date,
538: p_business_group_id => p_business_group_id);
539:
540: UPDATE pay_us_rpt_totals
541: SET attribute30 = 'EXTRACT_COMPLETED'
542: WHERE organization_name = 'US Pension Extracts'
543: AND tax_unit_id = g_conc_request_id
544: AND organization_id = p_business_group_id

Line 553: UPDATE pay_us_rpt_totals

549:
550: EXCEPTION
551: WHEN Others THEN
552: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
553: UPDATE pay_us_rpt_totals
554: SET attribute30 = 'EXTRACT_COMPLETED'
555: WHERE organization_name = 'US Pension Extracts'
556: AND tax_unit_id = g_conc_request_id
557: AND organization_id = p_business_group_id

Line 4915: FROM pay_us_rpt_totals

4911: ,attribute1 -- Selection Criteria
4912: ,attribute2 -- Reporting dimension
4913: ,attribute3 -- Extract Start Date
4914: ,attribute4 -- Extract End Date
4915: FROM pay_us_rpt_totals
4916: WHERE tax_unit_id = c_request_id
4917: AND value1 = c_ext_dfn_id
4918: AND organization_id = c_business_group_id
4919: AND business_group_id = c_business_group_id