APPS.PAY_DK_ARCHIVE dependencies on PAY_RUN_RESULT_VALUES

Line 2018: FROM pay_run_result_values rrv

2014: CURSOR csr_result_value(p_iv_id NUMBER
2015: ,p_ele_type_id NUMBER
2016: ,p_assignment_action_id NUMBER) IS
2017: SELECT rrv.result_value
2018: FROM pay_run_result_values rrv
2019: ,pay_run_results rr
2020: ,pay_assignment_actions paa
2021: ,pay_payroll_actions ppa
2022: WHERE rrv.input_value_id = p_iv_id

Line 2034: -- l_result_value pay_run_result_values.result_value%TYPE := 0;

2030: ------------------------------
2031:
2032: rec_get_element csr_get_element%ROWTYPE;
2033: /*Bug fix 6193177*/
2034: -- l_result_value pay_run_result_values.result_value%TYPE := 0;
2035: l_result_value pay_run_result_values.result_value%TYPE ;
2036: l_action_info_id NUMBER;
2037: l_ovn NUMBER;
2038: l_element_context VARCHAR2(10);

Line 2035: l_result_value pay_run_result_values.result_value%TYPE ;

2031:
2032: rec_get_element csr_get_element%ROWTYPE;
2033: /*Bug fix 6193177*/
2034: -- l_result_value pay_run_result_values.result_value%TYPE := 0;
2035: l_result_value pay_run_result_values.result_value%TYPE ;
2036: l_action_info_id NUMBER;
2037: l_ovn NUMBER;
2038: l_element_context VARCHAR2(10);
2039: l_index NUMBER := 0;

Line 3237: FROM pay_run_result_values rrv

3233: ,p_assignment_action_id NUMBER) IS
3234: SELECT rrv.result_value
3235: /* Added for Pension changes */
3236: , rr.run_result_id
3237: FROM pay_run_result_values rrv
3238: ,pay_run_results rr
3239: ,pay_assignment_actions paa
3240: ,pay_payroll_actions ppa
3241: WHERE rrv.input_value_id = p_iv_id

Line 3279: pay_run_result_values rrv

3275: CURSOR csr_get_pp_name(p_effective_date DATE ,
3276: p_run_result_id NUMBER) IS
3277: SELECT hou.name
3278: FROM
3279: pay_run_result_values rrv
3280: , pay_input_values_f iv
3281: , hr_organization_units hou
3282: WHERE rrv.run_result_id = p_run_result_id
3283: AND rrv.input_value_id = iv.input_value_id

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

3288: AND p_effective_date between hou.date_from and nvl(hou.date_to, p_effective_date);
3289:
3290: ---------------
3291:
3292: l_result_value pay_run_result_values.result_value%TYPE := 0;
3293: l_action_info_id NUMBER;
3294: l_ovn NUMBER;
3295: l_element_context VARCHAR2(10);
3296: l_index NUMBER := 0;