APPS.HR_AE_ASSIGNMENT_API dependencies on PER_BUSINESS_GROUPS

Line 162: l_business_group_id per_business_groups.business_group_id%TYPE;

158:
159: l_assignment_number per_assignments_f.assignment_number%TYPE;
160: l_effective_date DATE;
161: --
162: l_business_group_id per_business_groups.business_group_id%TYPE;
163: l_legislation_code per_business_groups.legislation_code%TYPE;
164: l_proc VARCHAR2(72) := g_package||'create_ae_secondary_emp_asg';
165: --
166: -- Declare cursors

Line 163: l_legislation_code per_business_groups.legislation_code%TYPE;

159: l_assignment_number per_assignments_f.assignment_number%TYPE;
160: l_effective_date DATE;
161: --
162: l_business_group_id per_business_groups.business_group_id%TYPE;
163: l_legislation_code per_business_groups.legislation_code%TYPE;
164: l_proc VARCHAR2(72) := g_package||'create_ae_secondary_emp_asg';
165: --
166: -- Declare cursors
167: --

Line 171: per_business_groups pbg

167: --
168: CURSOR csr_legislation IS
169: SELECT NULL
170: FROM per_assignments_f paf,
171: per_business_groups pbg
172: WHERE paf.person_id = p_person_id
173: AND l_effective_date BETWEEN paf.effective_start_date AND paf.effective_end_date
174: AND pbg.business_group_id = paf.business_group_id
175: AND pbg.legislation_code = 'AE';

Line 422: l_legislation_code per_business_groups.legislation_code%TYPE;

418: -- Declare cursors AND local variables
419: --
420: l_proc VARCHAR2(72) := g_package||'update_ae_emp_asg';
421: l_effective_date DATE;
422: l_legislation_code per_business_groups.legislation_code%TYPE;
423: l_business_group_id per_business_groups.business_group_id%type;
424: a varchar2(100);
425:
426: --

Line 423: l_business_group_id per_business_groups.business_group_id%type;

419: --
420: l_proc VARCHAR2(72) := g_package||'update_ae_emp_asg';
421: l_effective_date DATE;
422: l_legislation_code per_business_groups.legislation_code%TYPE;
423: l_business_group_id per_business_groups.business_group_id%type;
424: a varchar2(100);
425:
426: --
427: CURSOR check_legislation

Line 434: per_business_groups bgp

430: )
431: IS
432: SELECT bgp.legislation_code
433: FROM per_assignments_f asg,
434: per_business_groups bgp
435: WHERE asg.business_group_id = bgp.business_group_id
436: AND asg.assignment_id = c_assignment_id
437: AND c_effective_date BETWEEN effective_start_date AND effective_end_date;
438: --