Product: | PER - Human Resources |
---|---|
Description: | Used to support user interface |
Implementation/DBA Data: | APPS.PER_EVENTS_V |
SELECT PE.ROWID ROW_ID
, PE.EVENT_ID
, PE.BUSINESS_GROUP_ID
, HR.MEANING
, HL.LOCATION_CODE
, PE.LOCATION_ID
, PE.INTERNAL_CONTACT_PERSON_ID
, PE.ORGANIZATION_RUN_BY_ID
, PE.ASSIGNMENT_ID
, PE.DATE_START
, PE.TYPE
, PE.COMMENTS
, PE.CONTACT_TELEPHONE_NUMBER
, PE.DATE_END
, PE.EMP_OR_APL
, PE.EVENT_OR_INTERVIEW
, PE.EXTERNAL_CONTACT
, PE.TIME_END
, PE.TIME_START
, PE.REQUEST_ID
, PE.PROGRAM_APPLICATION_ID
, PE.PROGRAM_ID
, PE.PROGRAM_UPDATE_DATE
, PE.ATTRIBUTE_CATEGORY
, PE.ATTRIBUTE1
, PE.ATTRIBUTE2
, PE.ATTRIBUTE3
, PE.ATTRIBUTE4
, PE.ATTRIBUTE5
, PE.ATTRIBUTE6
, PE.ATTRIBUTE7
, PE.ATTRIBUTE8
, PE.ATTRIBUTE9
, PE.ATTRIBUTE10
, PE.ATTRIBUTE11
, PE.ATTRIBUTE12
, PE.ATTRIBUTE13
, PE.ATTRIBUTE14
, PE.ATTRIBUTE15
, PE.ATTRIBUTE16
, PE.ATTRIBUTE17
, PE.ATTRIBUTE18
, PE.ATTRIBUTE19
, PE.ATTRIBUTE20
, PE.LAST_UPDATE_DATE
, PE.LAST_UPDATED_BY
, PE.LAST_UPDATE_LOGIN
, PE.CREATED_BY
, PE.CREATION_DATE
FROM PER_EVENTS PE
, HR_LOOKUPS HR
, HR_LOCATIONS HL
WHERE PE.EVENT_OR_INTERVIEW = 'I'
AND PE.LOCATION_ID = HL.LOCATION_ID (+)
AND PE.TYPE = HR.LOOKUP_CODE
AND HR.LOOKUP_TYPE = 'EMP_INTERVIEW_TYPE'