DBA Data[Home] [Help]

APPS.PA_WORKPLAN_WORKFLOW dependencies on FND_GLOBAL

Line 498: where fu.user_id = fnd_global.USER_ID

494: UNION /*Added this clause for 4482957 */
495: select distinct fu.user_id, fu.user_name, papf.email_address,
496: papf.full_name person_name
497: from fnd_user fu, per_all_people_f papf
498: where fu.user_id = fnd_global.USER_ID
499: and papf.person_id = fu.employee_id
500: and trunc(sysdate) between papf.effective_start_date
501: and nvl(papf.effective_end_date, sysdate+1)
502: and trunc(sysdate) between fu.start_date