DBA Data[Home] [Help]

APPS.PAY_FI_ARCHIVE_PYSA dependencies on PAY_RUN_RESULTS

Line 1610: ,pay_run_results rr

1606: ,p_ele_type_id NUMBER
1607: ,p_assignment_action_id NUMBER) IS
1608: SELECT rrv.result_value
1609: FROM pay_run_result_values rrv
1610: ,pay_run_results rr
1611: ,pay_assignment_actions paa
1612: ,pay_payroll_actions ppa
1613: WHERE rrv.input_value_id = p_iv_id
1614: AND rr.element_type_id = p_ele_type_id

Line 2785: ,pay_run_results rr

2781: ,p_ele_type_id NUMBER
2782: ,p_assignment_action_id NUMBER) IS
2783: SELECT rrv.result_value
2784: FROM pay_run_result_values rrv
2785: ,pay_run_results rr
2786: ,pay_assignment_actions paa
2787: ,pay_payroll_actions ppa
2788: WHERE rrv.input_value_id = p_iv_id
2789: AND rr.element_type_id = p_ele_type_id