APPS.PAY_AE_ARCHIVE dependencies on PAY_RUN_RESULT_VALUES

Line 1537: FROM pay_run_result_values rrv

1533: ,p_ele_type_id NUMBER
1534: ,p_assignment_action_id NUMBER) IS
1535: SELECT rrv.result_value
1536: ,rr.run_result_id /*Added for loan*/
1537: FROM pay_run_result_values rrv
1538: ,pay_run_results rr
1539: ,pay_assignment_actions paa
1540: ,pay_payroll_actions ppa
1541: WHERE rrv.input_value_id = p_iv_id

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

1547: AND ppa.action_type IN ('Q','R')
1548: AND rrv.result_value IS NOT NULL;
1549: rec_result_value csr_result_value%ROWTYPE;
1550:
1551: l_result_value pay_run_result_values.result_value%TYPE := 0;
1552: l_run_result_id NUMBER := 0;
1553: l_action_info_id NUMBER;
1554: l_ovn NUMBER;
1555: l_element_context VARCHAR2(10);

Line 2034: FROM pay_run_result_values rrv

2030: CURSOR csr_result_value(p_iv_id NUMBER
2031: ,p_ele_type_id NUMBER
2032: ,p_assignment_action_id NUMBER) IS
2033: SELECT rrv.result_value
2034: FROM pay_run_result_values rrv
2035: ,pay_run_results rr
2036: ,pay_assignment_actions paa
2037: ,pay_payroll_actions ppa
2038: WHERE rrv.input_value_id = p_iv_id

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

2044: AND ppa.action_type IN ('Q','R')
2045: AND rrv.result_value IS NOT NULL;
2046:
2047: rec_get_element csr_get_element%ROWTYPE;
2048: l_result_value pay_run_result_values.result_value%TYPE := 0;
2049: l_action_info_id NUMBER;
2050: l_ovn NUMBER;
2051: l_element_context VARCHAR2(10);
2052: l_index NUMBER := 0;