APPS.HR_SA_ASSIGNMENT_API dependencies on PER_BUSINESS_GROUPS

Line 153: l_business_group_id per_business_groups.business_group_id%TYPE;

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

Line 154: l_legislation_code per_business_groups.legislation_code%TYPE;

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

Line 162: per_business_groups pbg

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

Line 403: l_legislation_code per_business_groups.legislation_code%TYPE;

399: -- Declare cursors AND local variables
400: --
401: l_proc VARCHAR2(72) := g_package||'update_sa_emp_asg';
402: l_effective_date DATE;
403: l_legislation_code per_business_groups.legislation_code%TYPE;
404: l_business_group_id per_business_groups.business_group_id%type;
405: a varchar2(100);
406:
407: --

Line 404: l_business_group_id per_business_groups.business_group_id%type;

400: --
401: l_proc VARCHAR2(72) := g_package||'update_sa_emp_asg';
402: l_effective_date DATE;
403: l_legislation_code per_business_groups.legislation_code%TYPE;
404: l_business_group_id per_business_groups.business_group_id%type;
405: a varchar2(100);
406:
407: --
408: CURSOR check_legislation

Line 415: per_business_groups bgp

411: )
412: IS
413: SELECT bgp.legislation_code
414: FROM per_assignments_f asg,
415: per_business_groups bgp
416: WHERE asg.business_group_id = bgp.business_group_id
417: AND asg.assignment_id = c_assignment_id
418: AND c_effective_date BETWEEN effective_start_date AND effective_end_date;
419: --