185: g_lst_yr_term varchar2(10);--Bug:3686549
186:
187: type exclusion_asg is record
188: (employee_name per_all_people_f.full_name%type,
189: assignment_number per_all_assignments_f.assignment_number%type,
190: assignment_id per_all_assignments_f.assignment_id%type,
191: reason varchar2(100)
192: );
193:
186:
187: type exclusion_asg is record
188: (employee_name per_all_people_f.full_name%type,
189: assignment_number per_all_assignments_f.assignment_number%type,
190: assignment_id per_all_assignments_f.assignment_id%type,
191: reason varchar2(100)
192: );
193:
194: --Change done
290: function get_exclusion_info(flag varchar2 ,p_assignment_id number) return varchar2;
291:
292: function get_assignment_id(p_assignment_id number) return number;
293:
294: function populate_exclusion_table(p_assignment_id per_all_assignments_f.assignment_id%type,
295: p_financial_year varchar2,
296: p_financial_year_end date,
297: p_tax_unit_id number --2610141
298: )