Product: | PER - Human Resources |
---|---|
Description: | Used to support user interface |
Implementation/DBA Data: | APPS.PER_APPLICATIONS_V |
SELECT APL.ROWID ROW_ID
, APL.APPLICATION_ID
, APL.BUSINESS_GROUP_ID
, APL.PERSON_ID
, APL.DATE_RECEIVED
, APL.COMMENTS
, APL.CURRENT_EMPLOYER
, APL.DATE_END
, APL.PROJECTED_HIRE_DATE
, APL.SUCCESSFUL_FLAG
, APL.TERMINATION_REASON
, HL.MEANING REASON_MEANING
, APL.APPL_ATTRIBUTE_CATEGORY
, APL.APPL_ATTRIBUTE1
, APL.APPL_ATTRIBUTE2
, APL.APPL_ATTRIBUTE3
, APL.APPL_ATTRIBUTE4
, APL.APPL_ATTRIBUTE5
, APL.APPL_ATTRIBUTE6
, APL.APPL_ATTRIBUTE7
, APL.APPL_ATTRIBUTE8
, APL.APPL_ATTRIBUTE9
, APL.APPL_ATTRIBUTE10
, APL.APPL_ATTRIBUTE11
, APL.APPL_ATTRIBUTE12
, APL.APPL_ATTRIBUTE13
, APL.APPL_ATTRIBUTE14
, APL.APPL_ATTRIBUTE15
, APL.APPL_ATTRIBUTE16
, APL.APPL_ATTRIBUTE17
, APL.APPL_ATTRIBUTE18
, APL.APPL_ATTRIBUTE19
, APL.APPL_ATTRIBUTE20
, APL.LAST_UPDATE_DATE
, APL.LAST_UPDATED_BY
, APL.LAST_UPDATE_LOGIN
, APL.CREATED_BY
, APL.CREATION_DATE
FROM PER_APPLICATIONS APL
, HR_LOOKUPS HL
, FND_SESSIONS FS
WHERE HL.LOOKUP_TYPE(+) = 'TERM_APL_REASON'
AND HL.LOOKUP_CODE(+) = APL.TERMINATION_REASON
AND FS.SESSION_ID = USERENV('SESSIONID')
AND APL.DATE_RECEIVED = (SELECT MAX(APP2.DATE_RECEIVED)
FROM PER_APPLICATIONS APP2
WHERE APP2.PERSON_ID = APL.PERSON_ID
AND APP2.DATE_RECEIVED <= FS.EFFECTIVE_DATE)