APPS.PQH_SS_UTILITY dependencies on PER_PEOPLE_EXTRA_INFO

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