DBA Data[Home] [Help]

APPS.BEN_FYI_NTFN_SS dependencies on FND_USER

Line 30: fnd_user usr,

26: usr.user_name,
27: usr.user_id user_id
28: from per_people_extra_info pei,
29: per_all_people_f ppf,
30: fnd_user usr,
31: pqh_roles rls
32: where pei.information_type = 'PQH_ROLE_USERS'
33: and pei.person_id = ppf.person_id
34: and trunc(sysdate) between ppf.effective_start_date and ppf.effective_end_date