APPS.PQH_SS_UTILITY dependencies on PQH_ROLES

Line 209: FROM pqh_roles

205: --
206: --
207: CURSOR cur_role IS
208: SELECT decode(business_group_id,null,'Y','N') global_role, role_name, role_id
209: FROM pqh_roles
210: WHERE role_type_cd = p_roleTypeCd
211: AND enable_flag = 'Y'
212: AND ( business_group_id = p_businessGroupId OR business_group_id IS NULL);
213: --

Line 273: l_roleName PQH_ROLES.role_name%TYPE;

269: ,p_editAllowed OUT NOCOPY VARCHAR2 ) IS
270: --
271: --
272: l_roleId NUMBER;
273: l_roleName PQH_ROLES.role_name%TYPE;
274: l_flag VARCHAR2(10);
275: dummy VARCHAR2(1);
276: --
277: --

Line 280: FROM pqh_roles

276: --
277: --
278: CURSOR cur_role (p_role_type_cd VARCHAR2) IS
279: SELECT role_id
280: FROM pqh_roles
281: WHERE role_type_cd = p_role_type_cd
282: AND enable_flag = 'Y'
283: AND ( business_group_id = p_businessGroupId OR business_group_id IS NULL); -- either cross business_group or the bg of logged user
284: --

Line 288: from per_people_extra_info pei , pqh_roles rls

284: --
285: --
286: CURSOR cur_edit (p_roleId NUMBER) IS
287: SELECT 'X'
288: from per_people_extra_info pei , pqh_roles rls
289: WHERE information_type = 'PQH_ROLE_USERS'
290: and rls.role_id = to_number(pei.pei_information3)
291: and nvl(pei.pei_information5,'Y') ='Y'
292: and rls.role_id = p_roleId