DBA Data[Home] [Help]

APPS.OKC_CONTRACT_APPROVAL_PVT dependencies on FND_USER

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

1026: where orig_system = 'FND_USR'
1027: and orig_system_id=fnd_global.user_id
1028: -- changed to boost perf
1029: */
1030: select user_name display_name from fnd_user where user_id=fnd_global.user_id and EMPLOYEE_ID is null
1031: union all
1032: select
1033: PER.FULL_NAME display_name
1034: from

Line 1036: FND_USER USR

1032: select
1033: PER.FULL_NAME display_name
1034: from
1035: PER_PEOPLE_F PER,
1036: FND_USER USR
1037: where trunc(SYSDATE)
1038: between PER.EFFECTIVE_START_DATE and PER.EFFECTIVE_END_DATE
1039: and PER.PERSON_ID = USR.EMPLOYEE_ID
1040: and USR.USER_ID = fnd_global.user_id