APPS.BEN_CWB_WF_NTF dependencies on PQH_ROLES

Line 778: FROM pqh_roles

774: IS
775: CURSOR c1
776: IS
777: SELECT role_id, role_name
778: FROM pqh_roles
779: WHERE role_type_cd = 'CWB';
780:
781: CURSOR c2 (l_role_id NUMBER)
782: IS

Line 788: pqh_roles rls

784: usr.user_name user_name, usr.user_id user_id
785: FROM per_people_extra_info pei,
786: per_all_people_f ppf,
787: fnd_user usr,
788: pqh_roles rls
789: WHERE information_type = 'PQH_ROLE_USERS'
790: AND pei.person_id = ppf.person_id
791: AND TRUNC (SYSDATE) BETWEEN ppf.effective_start_date
792: AND ppf.effective_end_date