APPS.PQP_US_PENSION_EXTRACTS dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 189: ,pay_element_entry_values_f pev

185: ,c_assignment_id IN NUMBER
186: ,c_input_value_id IN NUMBER) IS
187: SELECT pev.screen_entry_value
188: FROM pay_input_values_f piv
189: ,pay_element_entry_values_f pev
190: ,pay_element_entries_f pee
191: ,pay_element_links_f pel
192: WHERE c_effective_date BETWEEN piv.effective_start_date
193: AND piv.effective_end_date

Line 659: ,pay_element_entry_values_f pev

655: ,c_input_value_id IN NUMBER) IS
656: SELECT pev.screen_entry_value
657: ,pee.effective_start_date
658: FROM pay_input_values_f piv
659: ,pay_element_entry_values_f pev
660: ,pay_element_entries_f pee
661: ,pay_element_links_f pel
662: WHERE c_effective_date BETWEEN piv.effective_start_date
663: AND piv.effective_end_date

Line 3785: l_screen_entry_value pay_element_entry_values_f.screen_entry_value%TYPE;

3781: l_input_value_id pay_input_values_f.input_value_id%TYPE;
3782: l_get_value BOOLEAN;
3783: l_ele_type_id pay_element_types_f.element_type_id%TYPE;
3784: l_prev_ele_type_id pay_element_types_f.element_type_id%TYPE;
3785: l_screen_entry_value pay_element_entry_values_f.screen_entry_value%TYPE;
3786: l_Count NUMBER(5) := 0;
3787: BEGIN
3788: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
3789: -- If its for a single Assig. action, then take global variable

Line 4328: l_screen_entry_value pay_element_entry_values_f.screen_entry_value%TYPE;

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;
4332: l_error_message VARCHAR2(3000);