DBA Data[Home] [Help]

APPS.PAY_AE_ARCHIVE dependencies on PAY_RUN_RESULTS

Line 1538: ,pay_run_results rr

1534: ,p_assignment_action_id NUMBER) IS
1535: SELECT rrv.result_value
1536: ,rr.run_result_id /*Added for loan*/
1537: FROM pay_run_result_values rrv
1538: ,pay_run_results rr
1539: ,pay_assignment_actions paa
1540: ,pay_payroll_actions ppa
1541: WHERE rrv.input_value_id = p_iv_id
1542: AND rr.element_type_id = p_ele_type_id

Line 2035: ,pay_run_results rr

2031: ,p_ele_type_id NUMBER
2032: ,p_assignment_action_id NUMBER) IS
2033: SELECT rrv.result_value
2034: FROM pay_run_result_values rrv
2035: ,pay_run_results rr
2036: ,pay_assignment_actions paa
2037: ,pay_payroll_actions ppa
2038: WHERE rrv.input_value_id = p_iv_id
2039: AND rr.element_type_id = p_ele_type_id