[Home] [Help]
163: -- Declare cursors and local variables
164: --
165: l_assignment_number per_assignments_f.assignment_number%TYPE;
166: l_effective_date date;
167: l_legislation_code per_business_groups.legislation_code%TYPE;
168: l_proc varchar2(72) := g_package||'create_fr_secondary_emp_asg';
169: --
170: -- Declare dummy variables
171: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
175: --
176: cursor csr_legislation is
177: select null
178: from per_assignments_f paf,
179: per_business_groups pbg
180: where paf.person_id = p_person_id
181: and l_effective_date between paf.effective_start_date
182: and paf.effective_end_date
183: and pbg.business_group_id = paf.business_group_id
481: l_proc varchar2(72) := g_package||'update_fr_emp_asg';
482: l_effective_date date;
483: l_soft_coding_keyflex_id per_assignments_f.soft_coding_keyflex_id%TYPE;
484: l_concatenated_segments varchar2(2000);
485: l_legislation_code per_business_groups.legislation_code%TYPE;
486: l_work_pattern_start_date varchar2(20);
487: l_working_days_per_year varchar2(20);
488: --
489: cursor check_legislation
492: )
493: is
494: select bgp.legislation_code
495: from per_assignments_f asg,
496: per_business_groups bgp
497: where asg.business_group_id = bgp.business_group_id
498: and asg.assignment_id = c_assignment_id
499: and c_effective_date
500: between effective_start_date and effective_end_date;