APPS.PQP_US_PENSION_EXTRACTS dependencies on PAY_RUN_RESULT_VALUES

Line 216: ,pay_run_result_values prv

212: ,c_element_type_id IN NUMBER
213: ,c_input_value_id IN NUMBER) IS
214: SELECT prv.result_value
215: FROM pay_run_results prr
216: ,pay_run_result_values prv
217: WHERE prr.assignment_action_id = c_asg_action_id
218: AND prr.element_type_id = c_element_type_id
219: AND prv.input_value_id = c_input_value_id
220: AND prv.run_result_id = prr.run_result_id;

Line 4327: l_result_value pay_run_result_values.result_value%TYPE;

4323: ) RETURN VARCHAR2 IS
4324:
4325: l_element_type_id pay_element_types_f.element_type_id%TYPE;
4326: l_input_value_id pay_input_values_f.input_value_id%TYPE;
4327: l_result_value pay_run_result_values.result_value%TYPE;
4328: l_screen_entry_value pay_element_entry_values_f.screen_entry_value%TYPE;
4329: l_effective_date DATE;
4330: l_return_value VARCHAR2(50) := '0';
4331: l_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;