APPS.HR_NZ_ASSIGNMENT_LEG_HOOK dependencies on PER_BUSINESS_GROUPS

Line 55: ,per_business_groups pbg

51: CURSOR csr_get_business_group_id(c_assignment_id per_assignments_f.assignment_id%TYPE
52: ,c_effective_date DATE) IS
53: SELECT paf.business_group_id
54: FROM per_assignments_f paf
55: ,per_business_groups pbg
56: WHERE paf.assignment_id = c_assignment_id
57: AND paf.business_group_id = pbg.business_group_id
58: AND c_effective_date BETWEEN paf.effective_start_date AND paf.effective_end_date
59: AND pbg.legislation_code = 'NZ';

Line 61: l_business_group_id per_business_groups.business_group_id%TYPE;

57: AND paf.business_group_id = pbg.business_group_id
58: AND c_effective_date BETWEEN paf.effective_start_date AND paf.effective_end_date
59: AND pbg.legislation_code = 'NZ';
60:
61: l_business_group_id per_business_groups.business_group_id%TYPE;
62: l_proc VARCHAR2(72) := g_package||'set_bus_grp_id';
63:
64: BEGIN
65: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 87: ,per_business_groups pbg

83: CURSOR csr_get_business_group_id (c_person_id per_people_f.person_id%TYPE
84: ,c_effective_date DATE) IS
85: SELECT ppf.business_group_id
86: FROM per_people_f ppf
87: ,per_business_groups pbg
88: WHERE ppf.person_id = c_person_id
89: AND ppf.business_group_id = pbg.business_group_id
90: AND c_effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date
91: AND pbg.legislation_code = 'NZ';

Line 93: l_business_group_id per_business_groups.business_group_id%TYPE;

89: AND ppf.business_group_id = pbg.business_group_id
90: AND c_effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date
91: AND pbg.legislation_code = 'NZ';
92: --
93: l_business_group_id per_business_groups.business_group_id%TYPE;
94: l_proc VARCHAR2(72) := g_package||'set_bus_grp_id';
95: --
96: BEGIN
97: hr_utility.set_location('Entering:'|| l_proc, 10);