APPS.PAY_SA_ARCHIVE dependencies on PAY_RUN_RESULT_VALUES

Line 1947: FROM pay_run_result_values rrv

1943: CURSOR csr_result_value(p_iv_id NUMBER
1944: ,p_ele_type_id NUMBER
1945: ,p_assignment_action_id NUMBER) IS
1946: SELECT rrv.result_value
1947: FROM pay_run_result_values rrv
1948: ,pay_run_results rr
1949: ,pay_assignment_actions paa
1950: ,pay_payroll_actions ppa
1951: WHERE rrv.input_value_id = p_iv_id

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

1957: AND ppa.action_type IN ('Q','R')
1958: AND rrv.result_value IS NOT NULL;
1959:
1960: rec_get_element csr_get_element%ROWTYPE;
1961: l_result_value pay_run_result_values.result_value%TYPE := 0;
1962: l_action_info_id NUMBER;
1963: l_ovn NUMBER;
1964: l_element_context VARCHAR2(10);
1965: l_index NUMBER := 0;