APPS.HR_DE_ASSIGNMENT_API dependencies on PER_BUSINESS_GROUPS

Line 186: l_legislation_code per_business_groups.legislation_code%TYPE;

182: -- Declare cursors and local variables
183: --
184: l_assignment_number per_assignments_f.assignment_number%TYPE;
185: l_effective_date date;
186: l_legislation_code per_business_groups.legislation_code%TYPE;
187: l_proc varchar2(72) := g_package||'create_de_secondary_emp_asg';
188: --
189: -- Declare dummy variables
190: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;

Line 198: per_business_groups pbg

194: --
195: cursor csr_legislation is
196: select null
197: from per_assignments_f paf,
198: per_business_groups pbg
199: where paf.person_id = p_person_id
200: and l_effective_date between paf.effective_start_date
201: and paf.effective_end_date
202: and pbg.business_group_id = paf.business_group_id

Line 542: l_legislation_code per_business_groups.legislation_code%TYPE;

538: l_proc varchar2(72) := g_package||'update_ca_emp_asg';
539: l_effective_date date;
540: l_soft_coding_keyflex_id per_assignments_f.soft_coding_keyflex_id%TYPE;
541: l_concatenated_segments varchar2(2000);
542: l_legislation_code per_business_groups.legislation_code%TYPE;
543: --
544: cursor check_legislation
545: (c_assignment_id per_assignments_f.assignment_id%TYPE,
546: c_effective_date date

Line 551: per_business_groups bgp

547: )
548: is
549: select bgp.legislation_code
550: from per_assignments_f asg,
551: per_business_groups bgp
552: where asg.business_group_id = bgp.business_group_id
553: and asg.assignment_id = c_assignment_id
554: and c_effective_date
555: between effective_start_date and effective_end_date;