[Home] [Help]
APPS.BEN_CWB_WF_NTF dependencies on PER_PEOPLE_EXTRA_INFO
Line 785: FROM per_people_extra_info pei,
781: CURSOR c2 (l_role_id NUMBER)
782: IS
783: SELECT pei.person_id person_id, ppf.full_name person_name,
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'