DBA Data[Home] [Help]

APPS.PAY_SA_ARCHIVE dependencies on PAY_RUN_RESULTS

Line 1510: ,pay_run_results rr

1506:
1507: CURSOR csr_result_value(p_run_assact_id NUMBER,p_payroll_action_id NUMBER) IS
1508: SELECT rrv.result_value , pai.action_information2, pai.action_information3,pai.action_information5
1509: FROM pay_run_result_values rrv
1510: ,pay_run_results rr
1511: ,pay_assignment_actions paa
1512: ,pay_payroll_actions ppa
1513: ,pay_action_information pai
1514: WHERE rrv.input_value_id = pai.action_information3

Line 2056: ,pay_run_results rr

2052: ,p_ele_type_id NUMBER
2053: ,p_assignment_action_id NUMBER) IS
2054: SELECT rrv.result_value
2055: FROM pay_run_result_values rrv
2056: ,pay_run_results rr
2057: ,pay_assignment_actions paa
2058: ,pay_payroll_actions ppa
2059: WHERE rrv.input_value_id = p_iv_id
2060: AND rr.element_type_id = p_ele_type_id