23: CURSOR csr_get_input_value_info(p_element_entry_id NUMBER
24: ,p_input_value_name VARCHAR2
25: ,p_date DATE) IS
26: SELECT pivf.input_value_id iv_start_date_id
27: FROM pay_input_values_f pivf
28: ,pay_element_entries_f peef
29: ,pay_element_types_f petf
30: WHERE peef.element_entry_id = p_element_entry_id
31: AND peef.element_type_id = petf.element_type_id
38: AND p_date BETWEEN pivf.effective_start_date
39: AND pivf.effective_end_date;
40: --
41: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
42: l_start_date_iv_id pay_input_values_f.input_value_id%TYPE;
43: l_end_date_iv_id pay_input_values_f.input_value_id%TYPE;
44: l_absence_id pay_input_values_f.input_value_id%TYPE;
45: l_ptm_percentage_iv_id pay_input_values_f.input_value_id%TYPE;
46: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;
39: AND pivf.effective_end_date;
40: --
41: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
42: l_start_date_iv_id pay_input_values_f.input_value_id%TYPE;
43: l_end_date_iv_id pay_input_values_f.input_value_id%TYPE;
44: l_absence_id pay_input_values_f.input_value_id%TYPE;
45: l_ptm_percentage_iv_id pay_input_values_f.input_value_id%TYPE;
46: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;
47: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;
40: --
41: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
42: l_start_date_iv_id pay_input_values_f.input_value_id%TYPE;
43: l_end_date_iv_id pay_input_values_f.input_value_id%TYPE;
44: l_absence_id pay_input_values_f.input_value_id%TYPE;
45: l_ptm_percentage_iv_id pay_input_values_f.input_value_id%TYPE;
46: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;
47: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;
48: l_ovn pay_element_entries_f.object_version_number%TYPE;
41: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
42: l_start_date_iv_id pay_input_values_f.input_value_id%TYPE;
43: l_end_date_iv_id pay_input_values_f.input_value_id%TYPE;
44: l_absence_id pay_input_values_f.input_value_id%TYPE;
45: l_ptm_percentage_iv_id pay_input_values_f.input_value_id%TYPE;
46: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;
47: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;
48: l_ovn pay_element_entries_f.object_version_number%TYPE;
49: l_o_start_dt pay_element_entries_f.effective_start_date%TYPE;
189: CURSOR csr_get_input_value_info(p_element_entry_id NUMBER
190: ,p_input_value_name VARCHAR2
191: ,p_date DATE) IS
192: SELECT pivf.input_value_id iv_start_date_id
193: FROM pay_input_values_f pivf
194: ,pay_element_entries_f peef
195: ,pay_element_types_f petf
196: WHERE peef.element_entry_id = p_element_entry_id
197: AND peef.element_type_id = petf.element_type_id
204: AND p_date BETWEEN pivf.effective_start_date
205: AND pivf.effective_end_date;
206: --
207: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
208: l_start_date_iv_id pay_input_values_f.input_value_id%TYPE;
209: l_end_date_iv_id pay_input_values_f.input_value_id%TYPE;
210: l_absence_type_iv_id pay_input_values_f.input_value_id%TYPE;
211: l_ptm_percentage_iv_id pay_input_values_f.input_value_id%TYPE;
212: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;
205: AND pivf.effective_end_date;
206: --
207: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
208: l_start_date_iv_id pay_input_values_f.input_value_id%TYPE;
209: l_end_date_iv_id pay_input_values_f.input_value_id%TYPE;
210: l_absence_type_iv_id pay_input_values_f.input_value_id%TYPE;
211: l_ptm_percentage_iv_id pay_input_values_f.input_value_id%TYPE;
212: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;
213: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;
206: --
207: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
208: l_start_date_iv_id pay_input_values_f.input_value_id%TYPE;
209: l_end_date_iv_id pay_input_values_f.input_value_id%TYPE;
210: l_absence_type_iv_id pay_input_values_f.input_value_id%TYPE;
211: l_ptm_percentage_iv_id pay_input_values_f.input_value_id%TYPE;
212: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;
213: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;
214: l_ovn pay_element_entries_f.object_version_number%TYPE;
207: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
208: l_start_date_iv_id pay_input_values_f.input_value_id%TYPE;
209: l_end_date_iv_id pay_input_values_f.input_value_id%TYPE;
210: l_absence_type_iv_id pay_input_values_f.input_value_id%TYPE;
211: l_ptm_percentage_iv_id pay_input_values_f.input_value_id%TYPE;
212: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;
213: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;
214: l_ovn pay_element_entries_f.object_version_number%TYPE;
215: l_o_start_dt pay_element_entries_f.effective_start_date%TYPE;
214: l_ovn pay_element_entries_f.object_version_number%TYPE;
215: l_o_start_dt pay_element_entries_f.effective_start_date%TYPE;
216: l_o_end_dt pay_element_entries_f.effective_end_date%TYPE;
217: l_o_warning BOOLEAN;
218: l_bus_grp_id pay_input_values_f.business_group_id%TYPE;
219:
220: --
221: BEGIN
222: --