DBA Data[Home] [Help]

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 786: per_all_people_f ppf,

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'
790: AND pei.person_id = ppf.person_id