APPS.HR_DK_ASSIGNMENT_API dependencies on PER_BUSINESS_GROUPS

Line 150: l_business_group_id per_business_groups.business_group_id%TYPE;

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

Line 151: l_legislation_code per_business_groups.legislation_code%TYPE;

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

Line 159: per_business_groups pbg

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

Line 424: l_legislation_code per_business_groups.legislation_code%TYPE;

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

Line 425: l_business_group_id per_business_groups.business_group_id%type;

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

Line 436: per_business_groups bgp

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