DBA Data[Home] [Help]

APPS.PAY_DK_ARCHIVE dependencies on PAY_RUN_RESULTS

Line 2019: ,pay_run_results rr

2015: ,p_ele_type_id NUMBER
2016: ,p_assignment_action_id NUMBER) IS
2017: SELECT rrv.result_value
2018: FROM pay_run_result_values rrv
2019: ,pay_run_results rr
2020: ,pay_assignment_actions paa
2021: ,pay_payroll_actions ppa
2022: WHERE rrv.input_value_id = p_iv_id
2023: AND rr.element_type_id = p_ele_type_id

Line 3238: ,pay_run_results rr

3234: SELECT rrv.result_value
3235: /* Added for Pension changes */
3236: , rr.run_result_id
3237: FROM pay_run_result_values rrv
3238: ,pay_run_results rr
3239: ,pay_assignment_actions paa
3240: ,pay_payroll_actions ppa
3241: WHERE rrv.input_value_id = p_iv_id
3242: AND rr.element_type_id = p_ele_type_id