APPS.BEN_CWB_EMP_ELIG dependencies on PER_ALL_PEOPLE_F

Line 58: FROM per_people_extra_info pei , per_all_people_f ppf ,

54: IS
55: cursor c1(c_role_id in number) is
56: SELECT pei.person_id person_id, ppf.full_name person_name ,
57: usr.user_name user_name, usr.user_id user_id
58: FROM per_people_extra_info pei , per_all_people_f ppf ,
59: fnd_user usr , pqh_roles rls
60: WHERE information_type = 'PQH_ROLE_USERS' and
61: pei.person_id = ppf.person_id
62: AND TRUNC(SYSDATE) BETWEEN ppf.effective_start_date and ppf.effective_end_date