APPS.PAY_MX_YREND_ARCH dependencies on PAY_RUN_RESULTS

Line 1805: FROM pay_run_results prr,

1801: cp_start_date DATE,
1802: cp_end_date DATE
1803: ) IS
1804: SELECT /*+ index(PPA PAY_PAYROLL_ACTIONS_PK)*/ DISTINCT ppa.effective_date
1805: FROM pay_run_results prr,
1806: pay_run_result_values prrv,
1807: pay_assignment_actions paa,
1808: pay_payroll_actions ppa,
1809: pay_input_values_f piv,

Line 1919: FROM pay_run_results prr

1915:
1916: CURSOR c_get_anntaxadj_article ( cp_assignment_action_id NUMBER
1917: ,cp_input_value_id NUMBER ) IS
1918: SELECT result_value
1919: FROM pay_run_results prr
1920: ,pay_run_result_values prrv
1921: WHERE prr.assignment_action_id = cp_assignment_action_id
1922: AND prrv.run_result_id = prr.run_result_id
1923: AND prrv.input_value_id = cp_input_value_id;