Product: | PER - Human Resources |
---|---|
Description: | Used to support user interface |
Implementation/DBA Data: | APPS.PER_EVENTS_V3 |
SELECT INTERVIEW_TYPE.MEANING INTERVIEW_TYPE
, LOCATION.LOCATION_CODE LOCATION
, EVENT.ROWID ROW_ID
, EVENT.EVENT_ID
, EVENT.BUSINESS_GROUP_ID + 0 BUSINESS_GROUP_ID
, EVENT.LOCATION_ID
, EVENT.INTERNAL_CONTACT_PERSON_ID
, EVENT.ORGANIZATION_RUN_BY_ID
, EVENT.ASSIGNMENT_ID
, EVENT.DATE_START
, EVENT.TYPE
, EVENT.COMMENTS
, EVENT.CONTACT_TELEPHONE_NUMBER
, EVENT.DATE_END
, EVENT.EMP_OR_APL
, EVENT.EVENT_OR_INTERVIEW
, EVENT.EXTERNAL_CONTACT
, TO_DATE (EVENT.TIME_END
, 'HH24:MI') TIME_END
, TO_DATE (EVENT.TIME_START
, 'HH24:MI') TIME_START
, EVENT.REQUEST_ID
, EVENT.PROGRAM_APPLICATION_ID
, EVENT.PROGRAM_ID
, EVENT.PROGRAM_UPDATE_DATE
, EVENT.ATTRIBUTE_CATEGORY
, EVENT.ATTRIBUTE1
, EVENT.ATTRIBUTE2
, EVENT.ATTRIBUTE3
, EVENT.ATTRIBUTE4
, EVENT.ATTRIBUTE5
, EVENT.ATTRIBUTE6
, EVENT.ATTRIBUTE7
, EVENT.ATTRIBUTE8
, EVENT.ATTRIBUTE9
, EVENT.ATTRIBUTE10
, EVENT.ATTRIBUTE11
, EVENT.ATTRIBUTE12
, EVENT.ATTRIBUTE13
, EVENT.ATTRIBUTE14
, EVENT.ATTRIBUTE15
, EVENT.ATTRIBUTE16
, EVENT.ATTRIBUTE17
, EVENT.ATTRIBUTE18
, EVENT.ATTRIBUTE19
, EVENT.ATTRIBUTE20
, EVENT.LAST_UPDATE_DATE
, EVENT.LAST_UPDATED_BY
, EVENT.LAST_UPDATE_LOGIN
, EVENT.CREATED_BY
, EVENT.CREATION_DATE
, STATUS.ASSIGNMENT_STATUS_TYPE_ID
, STATUSTL.USER_STATUS STATUS_AFTER_INTERVIEW
FROM PER_EVENTS EVENT
, PER_ASSIGNMENT_STATUS_TYPES STATUS
, PER_ASSIGNMENT_STATUS_TYPES_TL STATUSTL
, PER_ALL_ASSIGNMENTS_F ASSIGNMENT
, HR_LOOKUPS INTERVIEW_TYPE
, HR_LOCATIONS LOCATION
WHERE ASSIGNMENT.ASSIGNMENT_STATUS_TYPE_ID = STATUS.ASSIGNMENT_STATUS_TYPE_ID
AND EVENT.EVENT_OR_INTERVIEW = 'I'
AND EVENT.LOCATION_ID = LOCATION.LOCATION_ID (+)
AND EVENT.ASSIGNMENT_ID = ASSIGNMENT.ASSIGNMENT_ID
AND (INTERVIEW_TYPE.LOOKUP_CODE = EVENT.TYPE
AND INTERVIEW_TYPE.LOOKUP_TYPE = 'APL_INTERVIEW_TYPE')
AND EVENT.DATE_START BETWEEN ASSIGNMENT.EFFECTIVE_START_DATE
AND ASSIGNMENT.EFFECTIVE_END_DATE
AND STATUS.ASSIGNMENT_STATUS_TYPE_ID = STATUSTL.ASSIGNMENT_STATUS_TYPE_ID
AND STATUSTL.LANGUAGE = USERENV('LANG')