DBA Data[Home] [Help]

APPS.PA_WORKPLAN_WORKFLOW_CLIENT dependencies on FND_GLOBAL

Line 573: where fu.user_id = fnd_global.USER_ID

569: UNION /*Added this clause for Approver 4291185 */
570: select distinct fu.user_id, fu.user_name, papf.email_address,
571: papf.full_name person_name
572: from fnd_user fu, per_all_people_f papf
573: where fu.user_id = fnd_global.USER_ID
574: and papf.person_id = fu.employee_id
575: and trunc(sysdate) between papf.effective_start_date
576: and nvl(papf.effective_end_date, sysdate+1)
577: and trunc(sysdate) between fu.start_date

Line 708: where fu.user_id = fnd_global.USER_ID

704: UNION
705: select distinct fu.user_id, fu.user_name, papf.email_address,
706: papf.full_name person_name
707: from fnd_user fu, per_all_people_f papf
708: where fu.user_id = fnd_global.USER_ID
709: and papf.person_id = fu.employee_id
710: and trunc(sysdate) between papf.effective_start_date
711: and nvl(papf.effective_end_date, sysdate+1)
712: and trunc(sysdate) between fu.start_date