500: cursor get_agg_start_end_dates is
501: select
502: pay_gb_eoy_archive.get_agg_active_start(p_person_rec.assignment_id,l_tax_ref,l_effective_date) start_date,
503: pay_gb_eoy_archive.get_agg_active_end(p_person_rec.assignment_id,l_tax_ref,l_effective_date) end_date
504: from dual;
505:
506: cursor csr_get_irregular_details is
507: SELECT AEI_INFORMATION3
508: FROM PER_ASSIGNMENT_EXTRA_INFO
1944: -- Create one assignment action for every assignment
1945: hr_utility.set_location('Archiving for assignment_id '||asg_rec.assignment_id, 50);
1946: select pay_assignment_actions_s.nextval
1947: into lockingactid
1948: from dual;
1949:
1950: -- Insert assignment into pay_assignment_actions
1951: hr_nonrun_asact.insact
1952: (
2001: -- Create one assignment action for every assignment
2002: hr_utility.set_location('Archiving for assignment_id '||asg_rec.assignment_id, 50);
2003: select pay_assignment_actions_s.nextval
2004: into lockingactid
2005: from dual;
2006:
2007: -- Insert assignment into pay_assignment_actions
2008: hr_nonrun_asact.insact
2009: (
2176: -- Create one assignment action for every assignment
2177: hr_utility.set_location('Archiving for assignment_id '||asg_rec.assignment_id, 50);
2178: select pay_assignment_actions_s.nextval
2179: into lockingactid
2180: from dual;
2181:
2182: -- Insert assignment into pay_assignment_actions
2183: hr_nonrun_asact.insact
2184: (