DBA Data[Home] [Help]

APPS.PAY_MX_YREND_ARCH dependencies on PAY_RUN_RESULTS

Line 1559: FROM pay_run_results prr,

1555: cp_start_date DATE,
1556: cp_end_date DATE
1557: ) IS
1558: SELECT DISTINCT ppa.effective_date
1559: FROM pay_run_results prr,
1560: pay_run_result_values prrv,
1561: pay_assignment_actions paa,
1562: pay_payroll_actions ppa,
1563: pay_input_values_f piv,

Line 1673: FROM pay_run_results prr

1669:
1670: CURSOR c_get_anntaxadj_article ( cp_assignment_action_id NUMBER
1671: ,cp_input_value_id NUMBER ) IS
1672: SELECT result_value
1673: FROM pay_run_results prr
1674: ,pay_run_result_values prrv
1675: WHERE prr.assignment_action_id = cp_assignment_action_id
1676: AND prrv.run_result_id = prr.run_result_id
1677: AND prrv.input_value_id = cp_input_value_id;