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.PAY_MX_SOC_SEC_ARCHIVE dependencies on PAY_RUN_RESULTS

Line 4136: 'AND EXISTS ( SELECT 1 FROM pay_run_results prr

4132: 'AND ppa2.effective_date BETWEEN '||
4133: 'fnd_date.canonical_to_date(''' ||gv_periodic_start_date||''') '||
4134: 'AND fnd_date.canonical_to_date('''||gv_periodic_end_date||''') '||
4135: 'AND ppa2.action_type in ( ''R'', ''Q'', ''B'', ''V'' ) '||
4136: 'AND EXISTS ( SELECT 1 FROM pay_run_results prr
4137: WHERE prr.assignment_action_id = paa.assignment_action_id
4138: AND prr.element_type_id = pee.element_type_id ) '||
4139: 'AND NOT EXISTS (
4140: SELECT 1

Line 4241: AND EXISTS (SELECT 1 FROM pay_run_results prr

4237: AND ppa2.payroll_action_id = paa.payroll_action_id
4238: AND ppa2.effective_date BETWEEN cp_periodic_start_date
4239: AND cp_periodic_end_date
4240: AND ppa2.action_type in ( 'R', 'Q', 'B', 'V' )
4241: AND EXISTS (SELECT 1 FROM pay_run_results prr
4242: WHERE prr.assignment_action_id = paa.assignment_action_id
4243: AND prr.element_type_id = pee.element_type_id )
4244: AND NOT EXISTS (
4245: SELECT 1

Line 4326: AND EXISTS (SELECT 1 FROM pay_run_results prr

4322: AND ppa2.payroll_action_id = paa.payroll_action_id
4323: AND ppa2.effective_date BETWEEN cp_periodic_start_date
4324: AND cp_periodic_end_date
4325: AND ppa2.action_type in ( 'R', 'Q', 'B', 'V' )
4326: AND EXISTS (SELECT 1 FROM pay_run_results prr
4327: WHERE prr.assignment_action_id = paa.assignment_action_id
4328: AND prr.element_type_id = pee.element_type_id )
4329: AND NOT EXISTS (
4330: SELECT 1