APPS.HR_SG_ASSIGNMENT_API dependencies on PER_BUSINESS_GROUPS

Line 122: l_business_group_id per_business_groups.business_group_id%TYPE;

118: --
119: l_assignment_number per_assignments_f.assignment_number%TYPE;
120: l_effective_date DATE;
121: --
122: l_business_group_id per_business_groups.business_group_id%TYPE;
123: l_legislation_code per_business_groups.legislation_code%TYPE;
124: l_proc VARCHAR2(72) := g_package||'create_sg_secondary_emp_asg';
125: --
126: -- Declare cursors

Line 123: l_legislation_code per_business_groups.legislation_code%TYPE;

119: l_assignment_number per_assignments_f.assignment_number%TYPE;
120: l_effective_date DATE;
121: --
122: l_business_group_id per_business_groups.business_group_id%TYPE;
123: l_legislation_code per_business_groups.legislation_code%TYPE;
124: l_proc VARCHAR2(72) := g_package||'create_sg_secondary_emp_asg';
125: --
126: -- Declare cursors
127: --

Line 131: per_business_groups pbg

127: --
128: CURSOR csr_legislation IS
129: SELECT NULL
130: FROM per_assignments_f paf,
131: per_business_groups pbg
132: WHERE paf.person_id = p_person_id
133: AND l_effective_date BETWEEN paf.effective_start_date AND paf.effective_end_date
134: AND pbg.business_group_id = paf.business_group_id
135: AND pbg.legislation_code = 'SG';

Line 332: l_legislation_code per_business_groups.legislation_code%TYPE;

328: -- Declare cursors AND local variables
329: --
330: l_proc VARCHAR2(72) := g_package||'update_sg_emp_asg';
331: l_effective_date DATE;
332: l_legislation_code per_business_groups.legislation_code%TYPE;
333: --
334:
335: CURSOR check_legislation
336: (c_assignment_id per_assignments_f.assignment_id%TYPE,

Line 343: per_business_groups bgp

339: IS
340:
341: SELECT bgp.legislation_code
342: FROM per_assignments_f asg,
343: per_business_groups bgp
344: WHERE asg.business_group_id = bgp.business_group_id
345: AND asg.assignment_id = c_assignment_id
346: AND c_effective_date BETWEEN effective_start_date AND effective_end_date;
347: