APPS.PQP_PENSION_EXTRACTS dependencies on PAY_RUN_RESULT_VALUES

Line 250: ,pay_run_result_values prv

246: ,c_element_type_id IN NUMBER
247: ,c_input_value_id IN NUMBER) IS
248: SELECT prv.result_value
249: FROM pay_run_results prr
250: ,pay_run_result_values prv
251: WHERE prr.assignment_action_id = c_asg_action_id
252: AND prr.element_type_id = c_element_type_id
253: AND prv.input_value_id = c_input_value_id
254: AND prv.run_result_id = prr.run_result_id;

Line 3381: l_result_value pay_run_result_values.result_value%TYPE;

3377: ) RETURN VARCHAR2 IS
3378:
3379: l_element_type_id pay_element_types_f.element_type_id%TYPE;
3380: l_input_value_id pay_input_values_f.input_value_id%TYPE;
3381: l_result_value pay_run_result_values.result_value%TYPE;
3382: l_screen_entry_value pay_element_entry_values_f.screen_entry_value%TYPE;
3383: l_effective_date DATE;
3384: l_return_value VARCHAR2(50) := '0';
3385: l_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;