Product: | PER - Human Resources |
---|---|
Description: | Used to support user interface. |
Implementation/DBA Data: | APPS.PER_SECURITY_USERS_V |
SELECT PSU.SECURITY_USER_ID
, PSU.SECURITY_PROFILE_ID
, PSU.USER_ID
, FNDU.USER_NAME
, FNDU.EMPLOYEE_ID
, PAPF.FULL_NAME
, PSU.OBJECT_VERSION_NUMBER
, PSU.CREATED_BY
, PSU.CREATION_DATE
, PSU.LAST_UPDATED_BY
, PSU.LAST_UPDATE_LOGIN
, PSU.LAST_UPDATE_DATE
FROM PER_SECURITY_USERS PSU
, PER_ALL_PEOPLE_F PAPF
, FND_USER FNDU
, FND_SESSIONS FNDS
WHERE PSU.USER_ID = FNDU.USER_ID
AND FNDU.EMPLOYEE_ID = PAPF.PERSON_ID(+)
AND FNDS.SESSION_ID = USERENV('SESSIONID')
AND FNDS.EFFECTIVE_DATE BETWEEN NVL(PAPF.EFFECTIVE_START_DATE
, FNDS.EFFECTIVE_DATE)
AND NVL(PAPF.EFFECTIVE_END_DATE
, FNDS.EFFECTIVE_DATE) ORDER BY FNDU.USER_NAME