APPS.HR_HK_ASSIGNMENT_API dependencies on PER_BUSINESS_GROUPS

Line 137: l_business_group_id per_business_groups.business_group_id%TYPE;

133: --
134: l_assignment_number per_assignments_f.assignment_number%TYPE;
135: l_effective_date DATE;
136: --
137: l_business_group_id per_business_groups.business_group_id%TYPE;
138: l_legislation_code per_business_groups.legislation_code%TYPE;
139: l_proc VARCHAR2(72) := g_package||'create_hk_secondary_emp_asg';
140: --
141: -- Declare cursors

Line 138: l_legislation_code per_business_groups.legislation_code%TYPE;

134: l_assignment_number per_assignments_f.assignment_number%TYPE;
135: l_effective_date DATE;
136: --
137: l_business_group_id per_business_groups.business_group_id%TYPE;
138: l_legislation_code per_business_groups.legislation_code%TYPE;
139: l_proc VARCHAR2(72) := g_package||'create_hk_secondary_emp_asg';
140: --
141: -- Declare cursors
142: --

Line 146: per_business_groups pbg

142: --
143: CURSOR csr_legislation IS
144: SELECT NULL
145: FROM per_assignments_f paf,
146: per_business_groups pbg
147: WHERE paf.person_id = p_person_id
148: AND l_effective_date BETWEEN paf.effective_start_date AND paf.effective_end_date
149: AND pbg.business_group_id = paf.business_group_id
150: AND pbg.legislation_code = 'HK';

Line 386: l_legislation_code per_business_groups.legislation_code%TYPE;

382: -- Declare cursors AND local variables
383: --
384: l_proc VARCHAR2(72) := g_package||'update_hk_emp_asg';
385: l_effective_date DATE;
386: l_legislation_code per_business_groups.legislation_code%TYPE;
387: --
388: CURSOR check_legislation
389: (c_assignment_id per_assignments_f.assignment_id%TYPE,
390: c_effective_date DATE

Line 394: per_business_groups bgp

390: c_effective_date DATE
391: ) IS
392: SELECT bgp.legislation_code
393: FROM per_assignments_f asg,
394: per_business_groups bgp
395: WHERE asg.business_group_id = bgp.business_group_id
396: AND asg.assignment_id = c_assignment_id
397: AND c_effective_date BETWEEN effective_start_date AND effective_end_date;
398: --