169: --
170: -- Declare variables
171: --
172:
173: l_assignment_number per_assignments_f.assignment_number%TYPE;
174: l_effective_date DATE;
175: l_business_group_id per_all_people_f.business_group_id%TYPE;
176:
177: --
493: --
494: l_proc VARCHAR2(72);
495: l_effective_date DATE;
496: l_legislation_code per_business_groups.legislation_code%TYPE;
497: l_business_group_id per_assignments_f.business_group_id%TYPE;
498:
499: --
500:
501:
742: --
743: -- Declare variables
744: --
745: l_effective_date DATE;
746: l_business_group_id per_assignments_f.business_group_id%TYPE;
747:
748: --
749: l_proc VARCHAR2(72);
750: --
888: --
889: -- Declare variables
890: --
891: l_final_process_date DATE;
892: l_business_group_id per_assignments_f.business_group_id%TYPE;
893:
894: --
895: l_proc VARCHAR2(72);
896: --