APPS.BEN_CWB_EMP_ELIG dependencies on PQH_ROLES

Line 59: fnd_user usr , pqh_roles rls

55: cursor c1(c_role_id in number) is
56: SELECT pei.person_id person_id, ppf.full_name person_name ,
57: usr.user_name user_name, usr.user_id user_id
58: FROM per_people_extra_info pei , per_all_people_f ppf ,
59: fnd_user usr , pqh_roles rls
60: WHERE information_type = 'PQH_ROLE_USERS' and
61: pei.person_id = ppf.person_id
62: AND TRUNC(SYSDATE) BETWEEN ppf.effective_start_date and ppf.effective_end_date
63: and usr.employee_id = ppf.person_id

Line 69: from pqh_roles

65: and nvl(pei.pei_information5,'Y')='Y'
66: and rls.role_id = c_role_id;
67: cursor c2 is
68: select role_id
69: from pqh_roles
70: where role_type_cd ='CWB';
71: l_proc varchar2(80) := g_package||'.isCompManagerRole';
72: BEGIN
73: hr_utility.set_location ('Entering '||l_proc,15);