DBA Data[Home] [Help]

APPS.OKE_CONTRACT_APPROVAL_PVT dependencies on FND_USER

Line 685: select user_name display_name from fnd_user where user_id=fnd_global.user_id and EMPLOYEE_ID is null

681: where orig_system = 'FND_USR'
682: and orig_system_id=fnd_global.user_id
683: -- changed to boost perf
684: */
685: select user_name display_name from fnd_user where user_id=fnd_global.user_id and EMPLOYEE_ID is null
686: union all
687: select
688: PER.FULL_NAME display_name
689: from

Line 691: FND_USER USR

687: select
688: PER.FULL_NAME display_name
689: from
690: PER_PEOPLE_F PER,
691: FND_USER USR
692: where trunc(SYSDATE)
693: between PER.EFFECTIVE_START_DATE and PER.EFFECTIVE_END_DATE
694: and PER.PERSON_ID = USR.EMPLOYEE_ID
695: and USR.USER_ID = fnd_global.user_id