Product: | PER - Human Resources |
---|---|
Description: | Used to support user interface |
Implementation/DBA Data: | APPS.PER_PERSON_TYPE_USAGES_V |
SELECT PTU.ROWID ROW_ID
, PTU.PERSON_TYPE_USAGE_ID
, PTU.PERSON_ID
, PTU.PERSON_TYPE_ID
, PT.SYSTEM_PERSON_TYPE
, PTTL.USER_PERSON_TYPE
, PTU.EFFECTIVE_START_DATE
, PTU.EFFECTIVE_END_DATE
, PTU.OBJECT_VERSION_NUMBER
, PTU.LAST_UPDATED_BY
, PTU.LAST_UPDATE_DATE
, PTU.LAST_UPDATE_LOGIN
, PTU.CREATED_BY
, PTU.CREATION_DATE
, PTU.REQUEST_ID
, PTU.PROGRAM_APPLICATION_ID
, PTU.PROGRAM_ID
, PTU.PROGRAM_UPDATE_DATE
, PTU.ATTRIBUTE_CATEGORY
, PTU.ATTRIBUTE1
, PTU.ATTRIBUTE2
, PTU.ATTRIBUTE3
, PTU.ATTRIBUTE4
, PTU.ATTRIBUTE5
, PTU.ATTRIBUTE6
, PTU.ATTRIBUTE7
, PTU.ATTRIBUTE8
, PTU.ATTRIBUTE9
, PTU.ATTRIBUTE10
, PTU.ATTRIBUTE11
, PTU.ATTRIBUTE12
, PTU.ATTRIBUTE13
, PTU.ATTRIBUTE14
, PTU.ATTRIBUTE15
, PTU.ATTRIBUTE16
, PTU.ATTRIBUTE17
, PTU.ATTRIBUTE18
, PTU.ATTRIBUTE19
, PTU.ATTRIBUTE20
FROM PER_PERSON_TYPE_USAGES_F PTU
, FND_SESSIONS SE
, PER_PERSON_TYPES_TL PTTL
, PER_PERSON_TYPES PT
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN PTU.EFFECTIVE_START_DATE
AND PTU.EFFECTIVE_END_DATE
AND PT.PERSON_TYPE_ID = PTU.PERSON_TYPE_ID
AND PT.PERSON_TYPE_ID = PTTL.PERSON_TYPE_ID
AND PTTL.LANGUAGE = USERENV('LANG')