APPS.PAY_KW_ARCHIVE dependencies on PAY_RUN_RESULT_VALUES

Line 1771: FROM pay_run_result_values rrv

1767: CURSOR csr_result_value(p_iv_id NUMBER
1768: ,p_ele_type_id NUMBER
1769: ,p_assignment_action_id NUMBER) IS
1770: SELECT rrv.result_value
1771: FROM pay_run_result_values rrv
1772: ,pay_run_results rr
1773: ,pay_assignment_actions paa
1774: ,pay_payroll_actions ppa
1775: WHERE rrv.input_value_id = p_iv_id

Line 1785: l_result_value pay_run_result_values.result_value%TYPE := 0;

1781: AND ppa.action_type IN ('Q','R')
1782: AND rrv.result_value IS NOT NULL;
1783:
1784: rec_get_element csr_get_element%ROWTYPE;
1785: l_result_value pay_run_result_values.result_value%TYPE := 0;
1786: l_action_info_id NUMBER;
1787: l_ovn NUMBER;
1788: l_element_context VARCHAR2(10);
1789: l_index NUMBER := 0;