APPS.HR_AE_ASSIGNMENT_API dependencies on PER_BUSINESS_GROUPS

Line 156: l_business_group_id per_business_groups.business_group_id%TYPE;

152:
153: l_assignment_number per_assignments_f.assignment_number%TYPE;
154: l_effective_date DATE;
155: --
156: l_business_group_id per_business_groups.business_group_id%TYPE;
157: l_legislation_code per_business_groups.legislation_code%TYPE;
158: l_proc VARCHAR2(72) := g_package||'create_ae_secondary_emp_asg';
159: --
160: -- Declare cursors

Line 157: l_legislation_code per_business_groups.legislation_code%TYPE;

153: l_assignment_number per_assignments_f.assignment_number%TYPE;
154: l_effective_date DATE;
155: --
156: l_business_group_id per_business_groups.business_group_id%TYPE;
157: l_legislation_code per_business_groups.legislation_code%TYPE;
158: l_proc VARCHAR2(72) := g_package||'create_ae_secondary_emp_asg';
159: --
160: -- Declare cursors
161: --

Line 165: per_business_groups pbg

161: --
162: CURSOR csr_legislation IS
163: SELECT NULL
164: FROM per_assignments_f paf,
165: per_business_groups pbg
166: WHERE paf.person_id = p_person_id
167: AND l_effective_date BETWEEN paf.effective_start_date AND paf.effective_end_date
168: AND pbg.business_group_id = paf.business_group_id
169: AND pbg.legislation_code = 'AE';

Line 408: l_legislation_code per_business_groups.legislation_code%TYPE;

404: -- Declare cursors AND local variables
405: --
406: l_proc VARCHAR2(72) := g_package||'update_ae_emp_asg';
407: l_effective_date DATE;
408: l_legislation_code per_business_groups.legislation_code%TYPE;
409: l_business_group_id per_business_groups.business_group_id%type;
410: a varchar2(100);
411:
412: --

Line 409: l_business_group_id per_business_groups.business_group_id%type;

405: --
406: l_proc VARCHAR2(72) := g_package||'update_ae_emp_asg';
407: l_effective_date DATE;
408: l_legislation_code per_business_groups.legislation_code%TYPE;
409: l_business_group_id per_business_groups.business_group_id%type;
410: a varchar2(100);
411:
412: --
413: CURSOR check_legislation

Line 420: per_business_groups bgp

416: )
417: IS
418: SELECT bgp.legislation_code
419: FROM per_assignments_f asg,
420: per_business_groups bgp
421: WHERE asg.business_group_id = bgp.business_group_id
422: AND asg.assignment_id = c_assignment_id
423: AND c_effective_date BETWEEN effective_start_date AND effective_end_date;
424: --