APPS.PER_FR_TERMINATION dependencies on PAY_ELEMENT_TYPES_F

Line 222: l_element_name pay_element_types_f.element_name%Type;

218: l_element_link_id number;
219: l_element_entry_id number;
220: l_effective_start_date date;
221: l_effective_end_date date;
222: l_element_name pay_element_types_f.element_name%Type;
223: l_input_value_id Number;
224: --
225: cursor c_get_asg is
226: select assignment_id

Line 235: from pay_element_types_f

231: and primary_flag = 'Y';
232: --
233: cursor c_element is
234: select element_type_id, element_name
235: from pay_element_types_f
236: where l_effective_date
237: between effective_start_date and effective_end_date
238: and element_name IN ('FR_LAST_DAY_WORKED', 'FR_TERMINATION_INFORMATION')
239: and legislation_code = 'FR';