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

Line 485: ,pay_run_results RR

481: ,pay_action_interlocks pai
482: ,per_all_assignments_f as1
483: ,hr_soft_coding_keyflex hsck
484: ,pay_run_result_values TARGET
485: ,pay_run_results RR
486: WHERE ppa.payroll_action_id = p_payroll_action_id
487: AND appa.effective_date BETWEEN l_canonical_start_date
488: AND l_canonical_end_date
489: AND as1.person_id BETWEEN p_start_person

Line 544: ,pay_run_results RR

540: ,pay_assignment_actions act1
541: ,pay_action_interlocks pai
542: ,per_all_assignments_f as1
543: ,pay_run_result_values TARGET
544: ,pay_run_results RR
545: WHERE ppa.payroll_action_id = p_payroll_action_id
546: AND appa.effective_date BETWEEN l_canonical_start_date
547: AND l_canonical_end_date
548: AND as1.person_id BETWEEN p_start_person

Line 897: pay_run_results prr,

893: p_element_name IN VARCHAR2,
894: p_input_val_name IN VARCHAR2) IS
895: SELECT prrv.result_value FROM
896: pay_assignment_actions paa,
897: pay_run_results prr,
898: pay_element_types_f petf,
899: pay_input_values_f pivf,
900: pay_run_result_values prrv
901: WHERE paa.assignment_id = p_assignment_id

Line 912: pay_run_results prr,

908: AND prrv.input_value_id = pivf.input_value_id
909: AND prrv.run_result_id = prr.run_result_id
910: AND paa.action_sequence = (SELECT MAX(paa.action_sequence) FROM
911: pay_assignment_actions paa,
912: pay_run_results prr,
913: pay_element_types_f
914: WHERE paa.assignment_id = p_assignment_id
915: AND paa.assignment_action_id = prr.assignment_action_id
916: AND prr.element_type_id = petf.element_type_id