[Home] [Help]
386: l_person_id per_all_assignments_f.person_id%type;
387: l_business_group_id per_all_assignments_f.business_group_id%type;
388: l_application_id per_all_assignments_f.application_id %type;
389: l_end_of_time DATE;
390: l_legislation_code per_business_groups.legislation_code%type;
391: l_date_end per_all_assignments_f.effective_end_date%type;
392: l_date_received Date;
393: l_date_end1 Date;
394: l_new_end_date Date;
498:
499: close csr_apl_assignments;
500: hr_utility.set_location('Only one Application :', 500);
501: select legislation_code into l_legislation_code
502: from per_business_groups
503: where business_group_id in
504: (select business_group_id
505: from per_all_assignments_f
506: where assignment_id = apl_assignment_id);