DBA Data[Home] [Help]

APPS.PA_WORKPLAN_WORKFLOW_CLIENT dependencies on FND_GLOBAL

Line 555: where fu.user_id = fnd_global.USER_ID

551: UNION /*Added this clause for Approver 4291185 */
552: select distinct fu.user_id, fu.user_name, papf.email_address,
553: papf.full_name person_name
554: from fnd_user fu, per_all_people_f papf
555: where fu.user_id = fnd_global.USER_ID
556: and papf.person_id = fu.employee_id
557: and trunc(sysdate) between papf.effective_start_date
558: and nvl(papf.effective_end_date, sysdate+1)
559: and trunc(sysdate) between fu.start_date

Line 690: where fu.user_id = fnd_global.USER_ID

686: UNION
687: select distinct fu.user_id, fu.user_name, papf.email_address,
688: papf.full_name person_name
689: from fnd_user fu, per_all_people_f papf
690: where fu.user_id = fnd_global.USER_ID
691: and papf.person_id = fu.employee_id
692: and trunc(sysdate) between papf.effective_start_date
693: and nvl(papf.effective_end_date, sysdate+1)
694: and trunc(sysdate) between fu.start_date