213: l_element_link_id number;
214: l_element_entry_id number;
215: l_effective_start_date date;
216: l_effective_end_date date;
217: l_element_name pay_element_types_f.element_name%Type;
218: l_input_value_id Number;
219: --
220: cursor c_get_asg is
221: select assignment_id
226: and primary_flag = 'Y';
227: --
228: cursor c_element is
229: select element_type_id, element_name
230: from pay_element_types_f
231: where l_effective_date
232: between effective_start_date and effective_end_date
233: and element_name IN ('FR_LAST_DAY_WORKED', 'FR_TERMINATION_INFORMATION')
234: and legislation_code = 'FR';