APPS.PAY_SA_ARCHIVE dependencies on PAY_RUN_RESULT_VALUES

Line 1509: FROM pay_run_result_values rrv

1505: p_effective_date IN DATE ) IS
1506:
1507: CURSOR csr_result_value(p_run_assact_id NUMBER,p_payroll_action_id NUMBER) IS
1508: SELECT rrv.result_value , pai.action_information2, pai.action_information3,pai.action_information5
1509: FROM pay_run_result_values rrv
1510: ,pay_run_results rr
1511: ,pay_assignment_actions paa
1512: ,pay_payroll_actions ppa
1513: ,pay_action_information pai

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

1525: and pai.action_information6 = 'M'
1526: and pai.action_information5 in ('E','D'); /* only check for Earning and deduction elements */
1527: rec_result_value csr_result_value%ROWTYPE;
1528:
1529: l_result_value pay_run_result_values.result_value%TYPE := 0;
1530: l_run_result_id NUMBER := 0;
1531: l_action_info_id NUMBER;
1532: l_ovn NUMBER;
1533: l_element_context VARCHAR2(10);

Line 2055: FROM pay_run_result_values rrv

2051: CURSOR csr_result_value(p_iv_id NUMBER
2052: ,p_ele_type_id NUMBER
2053: ,p_assignment_action_id NUMBER) IS
2054: SELECT rrv.result_value
2055: FROM pay_run_result_values rrv
2056: ,pay_run_results rr
2057: ,pay_assignment_actions paa
2058: ,pay_payroll_actions ppa
2059: WHERE rrv.input_value_id = p_iv_id

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

2065: AND ppa.action_type IN ('Q','R')
2066: AND rrv.result_value IS NOT NULL;
2067:
2068: rec_get_element csr_get_element%ROWTYPE;
2069: l_result_value pay_run_result_values.result_value%TYPE := 0;
2070: l_action_info_id NUMBER;
2071: l_ovn NUMBER;
2072: l_element_context VARCHAR2(10);
2073: l_index NUMBER := 0;