[Home] [Help]
160: ) is
161: --
162: -- Declare cursors and local variables
163: --
164: l_assignment_number per_assignments_f.assignment_number%TYPE;
165: l_effective_date date;
166: l_legislation_code per_business_groups.legislation_code%TYPE;
167: l_proc varchar2(72) := g_package||'create_ca_secondary_emp_asg';
168: --
167: l_proc varchar2(72) := g_package||'create_ca_secondary_emp_asg';
168: --
169: -- Declare dummy variables
170: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
171: l_soft_coding_keyflex_id per_assignments_f.soft_coding_keyflex_id%TYPE;
172: --
173: -- Declare cursors
174: --
175: cursor csr_legislation is
173: -- Declare cursors
174: --
175: cursor csr_legislation is
176: select null
177: from per_assignments_f paf,
178: per_business_groups pbg
179: where paf.person_id = p_person_id
180: and l_effective_date between paf.effective_start_date
181: and paf.effective_end_date
477: -- Declare cursors and local variables
478: --
479: l_proc varchar2(72) := g_package||'update_ca_emp_asg';
480: l_effective_date date;
481: l_soft_coding_keyflex_id per_assignments_f.soft_coding_keyflex_id%TYPE;
482: l_concatenated_segments varchar2(2000);
483: l_legislation_code per_business_groups.legislation_code%TYPE;
484: --
485: cursor check_legislation
482: l_concatenated_segments varchar2(2000);
483: l_legislation_code per_business_groups.legislation_code%TYPE;
484: --
485: cursor check_legislation
486: (c_assignment_id per_assignments_f.assignment_id%TYPE,
487: c_effective_date date
488: )
489: is
490: select bgp.legislation_code
487: c_effective_date date
488: )
489: is
490: select bgp.legislation_code
491: from per_assignments_f asg,
492: per_business_groups bgp
493: where asg.business_group_id = bgp.business_group_id
494: and asg.assignment_id = c_assignment_id
495: and c_effective_date