APPS.BEN_CWB_WF_NTF dependencies on PQH_ROLES

Line 773: FROM pqh_roles

769: IS
770: CURSOR c1
771: IS
772: SELECT role_id, role_name
773: FROM pqh_roles
774: WHERE role_type_cd = 'CWB';
775:
776: CURSOR c2 (l_role_id NUMBER)
777: IS

Line 783: pqh_roles rls

779: usr.user_name user_name, usr.user_id user_id
780: FROM per_people_extra_info pei,
781: per_all_people_f ppf,
782: fnd_user usr,
783: pqh_roles rls
784: WHERE information_type = 'PQH_ROLE_USERS'
785: AND pei.person_id = ppf.person_id
786: AND TRUNC (SYSDATE) BETWEEN ppf.effective_start_date
787: AND ppf.effective_end_date