APPS.HR_AU_SUPER_API dependencies on PER_BUSINESS_GROUPS

Line 106: cursor csr_per_business_groups

102: --
103: l_procedure constant varchar2(60) := 'valid_business_group';
104: l_legislation_code varchar2(30);
105: --
106: cursor csr_per_business_groups
107: is
108: select legislation_code
109: from per_business_groups
110: where business_group_id = p_business_group_id;

Line 109: from per_business_groups

105: --
106: cursor csr_per_business_groups
107: is
108: select legislation_code
109: from per_business_groups
110: where business_group_id = p_business_group_id;
111: --
112: begin
113: hr_utility.set_location(g_package||l_procedure, 1);

Line 114: open csr_per_business_groups;

110: where business_group_id = p_business_group_id;
111: --
112: begin
113: hr_utility.set_location(g_package||l_procedure, 1);
114: open csr_per_business_groups;
115: fetch csr_per_business_groups
116: into l_legislation_code;
117: if csr_per_business_groups%notfound
118: then

Line 115: fetch csr_per_business_groups

111: --
112: begin
113: hr_utility.set_location(g_package||l_procedure, 1);
114: open csr_per_business_groups;
115: fetch csr_per_business_groups
116: into l_legislation_code;
117: if csr_per_business_groups%notfound
118: then
119: close csr_per_business_groups;

Line 117: if csr_per_business_groups%notfound

113: hr_utility.set_location(g_package||l_procedure, 1);
114: open csr_per_business_groups;
115: fetch csr_per_business_groups
116: into l_legislation_code;
117: if csr_per_business_groups%notfound
118: then
119: close csr_per_business_groups;
120: hr_utility.set_location(g_package||l_procedure, 2);
121: hr_utility.trace('p_business_group_id: '||to_char(p_business_group_id));

Line 119: close csr_per_business_groups;

115: fetch csr_per_business_groups
116: into l_legislation_code;
117: if csr_per_business_groups%notfound
118: then
119: close csr_per_business_groups;
120: hr_utility.set_location(g_package||l_procedure, 2);
121: hr_utility.trace('p_business_group_id: '||to_char(p_business_group_id));
122: return false;
123: end if;

Line 124: close csr_per_business_groups;

120: hr_utility.set_location(g_package||l_procedure, 2);
121: hr_utility.trace('p_business_group_id: '||to_char(p_business_group_id));
122: return false;
123: end if;
124: close csr_per_business_groups;
125: --
126: hr_utility.set_location(g_package||l_procedure, 10);
127: if l_legislation_code = g_legislation_code
128: then