137: iv.lookup_type,
138: iv.default_value,
139: null,
140: null
141: from pay_input_values_f_tl ivtl,
142: pay_input_values_f iv
143: where iv.element_type_id = p_element_type_id
144: and p_effective_date
145: between iv.effective_start_date and iv.effective_end_date
138: iv.default_value,
139: null,
140: null
141: from pay_input_values_f_tl ivtl,
142: pay_input_values_f iv
143: where iv.element_type_id = p_element_type_id
144: and p_effective_date
145: between iv.effective_start_date and iv.effective_end_date
146: and ivtl.input_value_id = iv.input_value_id
308: liv.default_value,
309: eev.screen_entry_value
310: from pay_element_entry_values_f eev,
311: pay_link_input_values_f liv,
312: pay_input_values_f iv,
313: pay_input_values_f_tl ivtl
314: where eev.element_entry_id = p_ee_rec.element_entry_id
315: and eev.effective_start_date = p_ee_rec.effective_start_date
316: and eev.effective_end_date = p_ee_rec.effective_end_date
309: eev.screen_entry_value
310: from pay_element_entry_values_f eev,
311: pay_link_input_values_f liv,
312: pay_input_values_f iv,
313: pay_input_values_f_tl ivtl
314: where eev.element_entry_id = p_ee_rec.element_entry_id
315: and eev.effective_start_date = p_ee_rec.effective_start_date
316: and eev.effective_end_date = p_ee_rec.effective_end_date
317: and liv.element_link_id = p_ee_rec.element_link_id
394: is
395: l_proc varchar2(61) := c_package || 'set_eev';
396: --
397: l_index number;
398: l_default_value pay_input_values_f.default_value%TYPE;
399: l_entry_value pay_element_entry_values_f.screen_entry_value%TYPE;
400: l_new_value pay_element_entry_values_f.screen_entry_value%TYPE;
401: begin
402: hr_utility.set_location('Entering : ' || l_proc, 10);