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_APAC_PAYSLIP_ARCHIVE dependencies on PAY_RUN_RESULTS

Line 337: ,pay_run_results RR

333: IS
334: select distinct CONTEXT.result_value
335: from pay_run_result_values CONTEXT
336: ,pay_input_values_f PIVF
337: ,pay_run_results RR
338: ,pay_payroll_actions PACT,
339: pay_assignment_actions paa
340: where CONTEXT.run_result_id = RR.run_result_id
341: and CONTEXT.input_value_id = PIVF.input_value_id

Line 497: pay_run_results prr

493: p_input_value_id NUMBER)
494: IS
495: SELECT prv.result_value value
496: FROM pay_run_result_values prv,
497: pay_run_results prr
498: WHERE prr.status IN ('P','PA')
499: AND prv.run_result_id = prr.run_result_id
500: AND prr.assignment_action_id = p_assignment_action_id
501: AND prr.element_type_id = p_element_type_id

Line 513: pay_run_results prr

509: p_input_value_id NUMBER)
510: IS
511: SELECT sum(fnd_number.canonical_to_number(prv.result_value)) value/*Bug 3228928*/
512: FROM pay_run_result_values prv,
513: pay_run_results prr
514: WHERE prr.status IN ('P','PA')
515: AND prv.run_result_id = prr.run_result_id
516: AND prr.assignment_action_id = p_assignment_action_id
517: AND prr.element_type_id = p_element_type_id