APPS.BEN_CWB_WF_NTF dependencies on PER_ALL_PEOPLE_F

Line 147: per_all_people_f per

143: CURSOR c1
144: IS
145: SELECT per.full_name
146: FROM ben_per_in_ler pil,
147: per_all_people_f per
148: WHERE pil.per_in_ler_id = p_group_per_in_ler_id
149: AND pil.ws_mgr_id = per.person_id
150: AND sysdate between per.effective_start_date and per.effective_end_date;
151:

Line 781: per_all_people_f ppf,

777: IS
778: SELECT pei.person_id person_id, ppf.full_name person_name,
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