30: l_effective_date date;
31: --
32: -- Declare OUT variables
33: --
34: l_element_type_usage_id pay_element_type_usages_f.element_type_usage_id%TYPE;
35: l_object_version_number pay_element_type_usages_f.object_version_number%TYPE;
36: l_effective_start_date pay_element_type_usages_f.effective_start_date%TYPE;
37: l_effective_end_date pay_element_type_usages_f.effective_end_date%TYPE;
38: --
31: --
32: -- Declare OUT variables
33: --
34: l_element_type_usage_id pay_element_type_usages_f.element_type_usage_id%TYPE;
35: l_object_version_number pay_element_type_usages_f.object_version_number%TYPE;
36: l_effective_start_date pay_element_type_usages_f.effective_start_date%TYPE;
37: l_effective_end_date pay_element_type_usages_f.effective_end_date%TYPE;
38: --
39: begin
32: -- Declare OUT variables
33: --
34: l_element_type_usage_id pay_element_type_usages_f.element_type_usage_id%TYPE;
35: l_object_version_number pay_element_type_usages_f.object_version_number%TYPE;
36: l_effective_start_date pay_element_type_usages_f.effective_start_date%TYPE;
37: l_effective_end_date pay_element_type_usages_f.effective_end_date%TYPE;
38: --
39: begin
40: hr_utility.set_location('Entering:'|| l_proc, 10);
33: --
34: l_element_type_usage_id pay_element_type_usages_f.element_type_usage_id%TYPE;
35: l_object_version_number pay_element_type_usages_f.object_version_number%TYPE;
36: l_effective_start_date pay_element_type_usages_f.effective_start_date%TYPE;
37: l_effective_end_date pay_element_type_usages_f.effective_end_date%TYPE;
38: --
39: begin
40: hr_utility.set_location('Entering:'|| l_proc, 10);
41: --
186: l_effective_date date;
187: --
188: -- Declare OUT variables
189: --
190: l_effective_start_date pay_element_type_usages_f.effective_start_date%TYPE;
191: l_effective_end_date pay_element_type_usages_f.effective_end_date%TYPE;
192: --
193: -- Declare IN OUT variables
194: --
187: --
188: -- Declare OUT variables
189: --
190: l_effective_start_date pay_element_type_usages_f.effective_start_date%TYPE;
191: l_effective_end_date pay_element_type_usages_f.effective_end_date%TYPE;
192: --
193: -- Declare IN OUT variables
194: --
195: l_object_version_number pay_element_type_usages_f.object_version_number%TYPE;
191: l_effective_end_date pay_element_type_usages_f.effective_end_date%TYPE;
192: --
193: -- Declare IN OUT variables
194: --
195: l_object_version_number pay_element_type_usages_f.object_version_number%TYPE;
196: --
197: begin
198: hr_utility.set_location('Entering:'|| l_proc, 10);
199: --
334: l_effective_date date;
335: --
336: -- Declare OUT variables
337: --
338: l_effective_start_date pay_element_type_usages_f.effective_start_date%TYPE;
339: l_effective_end_date pay_element_type_usages_f.effective_end_date%TYPE;
340: --
341: -- Declare IN OUT variables
342: --
335: --
336: -- Declare OUT variables
337: --
338: l_effective_start_date pay_element_type_usages_f.effective_start_date%TYPE;
339: l_effective_end_date pay_element_type_usages_f.effective_end_date%TYPE;
340: --
341: -- Declare IN OUT variables
342: --
343: l_object_version_number pay_element_type_usages_f.object_version_number%TYPE;
339: l_effective_end_date pay_element_type_usages_f.effective_end_date%TYPE;
340: --
341: -- Declare IN OUT variables
342: --
343: l_object_version_number pay_element_type_usages_f.object_version_number%TYPE;
344: --
345: begin
346: hr_utility.set_location('Entering:'|| l_proc, 10);
347: --