APPS.PQH_REI_BUS dependencies on PQH_ROLES

Line 31: , pqh_roles rls

27: cursor csr_sec_grp is
28: select pbg.security_group_id
29: from per_business_groups pbg
30: , pqh_role_extra_info rei
31: , pqh_roles rls
32: where rei.role_extra_info_id = p_role_extra_info_id
33: and rei.role_id = rls.role_id
34: and pbg.business_group_id = rls.business_group_id;
35:

Line 97: , pqh_roles rls

93: cursor csr_leg_code is
94: select pbg.legislation_code
95: from per_business_groups pbg
96: , pqh_role_extra_info rei
97: , pqh_roles rls
98: where rei.role_extra_info_id = p_role_extra_info_id
99: and rei.role_id = rls.role_id
100: and pbg.business_group_id = rls.business_group_id;
101: --

Line 244: -- Verify that the value in role_ID is in the pqh_roles Table.

240: -- ----------------------------------------------------------------------------
241: -- {Start Of Comments}
242: --
243: -- Description:
244: -- Verify that the value in role_ID is in the pqh_roles Table.
245: --
246: -- Pre Conditions:
247: --
248: --

Line 279: from pqh_roles

275: l_dummy varchar2(1);
276:
277: cursor c_valid_role (id number) is
278: select 'x'
279: from pqh_roles
280: where role_id = id;
281: --
282: Begin
283: hr_utility.set_location('Entering:'||l_proc, 1);

Line 295: -- Check that the role_id is in the pqh_roles table.

291: p_argument_value => p_role_id
292: );
293: hr_utility.set_location(l_proc, 2);
294: --
295: -- Check that the role_id is in the pqh_roles table.
296: --
297: open c_valid_role (p_role_id);
298: fetch c_valid_role into l_dummy;
299: if c_valid_role%notfound then