Product: | PER - Human Resources |
---|---|
Description: | History of periods of absence for employees. |
Implementation/DBA Data: | APPS.PER_ABSENCE_ATTENDANCES_V3 |
SELECT ABA.ABSENCE_ATTENDANCE_ID
, ABA.BUSINESS_GROUP_ID
, ABA.ABSENCE_ATTENDANCE_TYPE_ID
, ABA.ABS_ATTENDANCE_REASON_ID
, ABA.PERSON_ID
, ABA.AUTHORISING_PERSON_ID
, ABA.REPLACEMENT_PERSON_ID
, ABA.PERIOD_OF_INCAPACITY_ID
, ABA.ABSENCE_DAYS
, ABA.ABSENCE_HOURS
, ABA.COMMENTS
, ABA.DATE_END
, ABA.DATE_NOTIFICATION
, ABA.DATE_PROJECTED_END
, ABA.DATE_PROJECTED_START
, ABA.DATE_START
, ABA.OCCURRENCE
, ABA.SSP1_ISSUED
, ABA.TIME_END
, ABA.TIME_PROJECTED_END
, ABA.TIME_PROJECTED_START
, ABA.TIME_START
, ABA.ATTRIBUTE_CATEGORY
, ABA.ATTRIBUTE1
, ABA.ATTRIBUTE2
, ABA.ATTRIBUTE3
, ABA.ATTRIBUTE4
, ABA.ATTRIBUTE5
, ABA.ATTRIBUTE6
, ABA.ATTRIBUTE7
, ABA.ATTRIBUTE8
, ABA.ATTRIBUTE9
, ABA.ATTRIBUTE10
, ABA.ATTRIBUTE11
, ABA.ATTRIBUTE12
, ABA.ATTRIBUTE13
, ABA.ATTRIBUTE14
, ABA.ATTRIBUTE15
, ABA.ATTRIBUTE16
, ABA.ATTRIBUTE17
, ABA.ATTRIBUTE18
, ABA.ATTRIBUTE19
, ABA.ATTRIBUTE20
, ABA.LAST_UPDATE_DATE
, ABA.LAST_UPDATED_BY
, ABA.LAST_UPDATE_LOGIN
, ABA.CREATED_BY
, ABA.CREATION_DATE
, ABT.NAME
, PEP.FULL_NAME
, PEP.EMPLOYEE_NUMBER
, PEP2.FULL_NAME
, PEP2.EMPLOYEE_NUMBER
, REAS.MEANING
, CAT.MEANING
FROM PER_ABSENCE_ATTENDANCES ABA
, PER_ABSENCE_ATTENDANCE_TYPES ABT
, PER_ABS_ATTENDANCE_REASONS ABR
, PER_ALL_PEOPLE_F PEP
, PER_ALL_PEOPLE_F PEP2
, HR_LOOKUPS REAS
, HR_LOOKUPS CAT
WHERE ABA.ABSENCE_ATTENDANCE_TYPE_ID = ABT.ABSENCE_ATTENDANCE_TYPE_ID
AND ABA.AUTHORISING_PERSON_ID = PEP.PERSON_ID (+)
AND ABA.REPLACEMENT_PERSON_ID = PEP2.PERSON_ID (+)
AND ABA.ABS_ATTENDANCE_REASON_ID = ABR.ABS_ATTENDANCE_REASON_ID (+)
AND ABR.NAME = REAS.LOOKUP_CODE (+)
AND REAS.LOOKUP_TYPE (+) = 'ABSENCE_REASON'
AND ABT.ABSENCE_CATEGORY = CAT.LOOKUP_CODE (+)
AND CAT.LOOKUP_TYPE (+) = 'ABSENCE_CATEGORY'
AND NVL(ABA.DATE_NOTIFICATION
, ABA.DATE_START) BETWEEN NVL(PEP.EFFECTIVE_START_DATE
, ABA.DATE_NOTIFICATION)
AND NVL(PEP.EFFECTIVE_END_DATE
, ABA.DATE_NOTIFICATION)
AND NVL(ABA.DATE_NOTIFICATION
, ABA.DATE_START) BETWEEN NVL(PEP2.EFFECTIVE_START_DATE
, ABA.DATE_NOTIFICATION)
AND NVL(PEP2.EFFECTIVE_END_DATE
, ABA.DATE_NOTIFICATION)