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 4256: FROM pay_run_results prr

4252: AND ppa2.payroll_action_id =paa.payroll_action_id
4253: AND ppa2.effective_date BETWEEN p_periodic_start_date AND p_periodic_end_date
4254: AND ppa2.action_type in ('R', 'Q', 'B', 'V' )
4255: AND EXISTS ( SELECT 1
4256: FROM pay_run_results prr
4257: WHERE prr.assignment_action_id = paa.assignment_action_id
4258: AND prr.element_type_id = pee.element_type_id)
4259: AND ROWNUM = 1;
4260:

Line 4572: AND EXISTS (SELECT 1 FROM pay_run_results prr

4568: AND ppa2.payroll_action_id = paa.payroll_action_id
4569: AND ppa2.effective_date BETWEEN cp_periodic_start_date
4570: AND cp_periodic_end_date
4571: AND ppa2.action_type in ( 'R', 'Q', 'B', 'V' )
4572: AND EXISTS (SELECT 1 FROM pay_run_results prr
4573: WHERE prr.assignment_action_id = paa.assignment_action_id
4574: AND prr.element_type_id = pee.element_type_id )
4575: AND NOT EXISTS (
4576: SELECT 1

Line 4657: AND EXISTS (SELECT 1 FROM pay_run_results prr

4653: AND ppa2.payroll_action_id = paa.payroll_action_id
4654: AND ppa2.effective_date BETWEEN cp_periodic_start_date
4655: AND cp_periodic_end_date
4656: AND ppa2.action_type in ( 'R', 'Q', 'B', 'V' )
4657: AND EXISTS (SELECT 1 FROM pay_run_results prr
4658: WHERE prr.assignment_action_id = paa.assignment_action_id
4659: AND prr.element_type_id = pee.element_type_id )
4660: AND NOT EXISTS (
4661: SELECT 1