View: PER_ABSENCE_ATTENDANCES_V

Product:	PER - Human Resources
Description:	Employee periods of absence.
Implementation/DBA Data:	APPS.PER_ABSENCE_ATTENDANCES_V

View Text

SELECT ABA.ROWID
, 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.REQUEST_ID
, ABA.PROGRAM_APPLICATION_ID
, ABA.PROGRAM_ID
, ABA.PROGRAM_UPDATE_DATE
, 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
, ABA.OBJECT_VERSION_NUMBER
, ABT.NAME
, IV.ELEMENT_TYPE_ID
, ABT.ABSENCE_CATEGORY
, HRL.MEANING CATEGORY_MEANING
, ABT.HOURS_OR_DAYS
, IVTL.NAME
, ABT.INCREASING_OR_DECREASING_FLAG
, IV.UOM
, ABT.INPUT_VALUE_ID
, ABT.DATE_EFFECTIVE
, ABT.DATE_END
, PEP.FULL_NAME
, NVL(PEP.EMPLOYEE_NUMBER
, PEP.NPW_NUMBER)
, PEP2.FULL_NAME
, NVL(PEP2.EMPLOYEE_NUMBER
, PEP2.NPW_NUMBER)
, L.MEANING
, ABA.LINKED_ABSENCE_ID
, ABA.SICKNESS_START_DATE
, ABA.SICKNESS_END_DATE
, ABA.ACCEPT_LATE_NOTIFICATION_FLAG
, ABA.REASON_FOR_NOTIFICATION_DELAY
, ABA.PREGNANCY_RELATED_ILLNESS
, ABA.MATERNITY_ID
, HM.DUE_DATE
, ABS_INFORMATION_CATEGORY
, ABS_INFORMATION1
, ABS_INFORMATION2
, ABS_INFORMATION3
, ABS_INFORMATION4
, ABS_INFORMATION5
, ABS_INFORMATION6
, ABS_INFORMATION7
, ABS_INFORMATION8
, ABS_INFORMATION9
, ABS_INFORMATION10
, ABS_INFORMATION11
, ABS_INFORMATION12
, ABS_INFORMATION13
, ABS_INFORMATION14
, ABS_INFORMATION15
, ABS_INFORMATION16
, ABS_INFORMATION17
, ABS_INFORMATION18
, ABS_INFORMATION19
, ABS_INFORMATION20
, ABS_INFORMATION21
, ABS_INFORMATION22
, ABS_INFORMATION23
, ABS_INFORMATION24
, ABS_INFORMATION25
, ABS_INFORMATION26
, ABS_INFORMATION27
, ABS_INFORMATION28
, ABS_INFORMATION29
, ABS_INFORMATION30
FROM PER_ABSENCE_ATTENDANCES ABA
, PER_ABSENCE_ATTENDANCE_TYPES ABT
, PER_ABS_ATTENDANCE_REASONS ABR
, PAY_INPUT_VALUES_F_TL IVTL
, PAY_INPUT_VALUES_F IV
, PER_ALL_PEOPLE_F PEP
, PER_ALL_PEOPLE_F PEP2
, SSP_MATERNITIES HM
, HR_LOOKUPS HRL
, HR_LOOKUPS L
WHERE ABA.ABSENCE_ATTENDANCE_TYPE_ID = ABT.ABSENCE_ATTENDANCE_TYPE_ID
AND ABT.INPUT_VALUE_ID = IV.INPUT_VALUE_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 ABT.ABSENCE_CATEGORY = HRL.LOOKUP_CODE(+)
AND HRL.LOOKUP_TYPE(+) = 'ABSENCE_CATEGORY'
AND ABR.NAME = L.LOOKUP_CODE (+)
AND L.LOOKUP_TYPE (+) = 'ABSENCE_REASON'
AND ABA.MATERNITY_ID = HM.MATERNITY_ID (+)
AND NVL(ABA.DATE_NOTIFICATION
, SYSDATE) BETWEEN NVL( IV.EFFECTIVE_START_DATE
, NVL(ABA.DATE_NOTIFICATION
, SYSDATE))
AND NVL(IV.EFFECTIVE_END_DATE
, NVL(ABA.DATE_NOTIFICATION
, SYSDATE))
AND NVL(ABA.DATE_NOTIFICATION
, SYSDATE) BETWEEN NVL(PEP.EFFECTIVE_START_DATE
, NVL(ABA.DATE_NOTIFICATION
, SYSDATE))
AND NVL(PEP.EFFECTIVE_END_DATE
, NVL(ABA.DATE_NOTIFICATION
, SYSDATE))
AND NVL(ABA.DATE_NOTIFICATION
, SYSDATE) BETWEEN NVL( PEP2.EFFECTIVE_START_DATE
, NVL(ABA.DATE_NOTIFICATION
, SYSDATE))
AND NVL(PEP2.EFFECTIVE_END_DATE
, NVL(ABA.DATE_NOTIFICATION
, SYSDATE))
AND IV.INPUT_VALUE_ID = IVTL.INPUT_VALUE_ID (+)
AND DECODE(IVTL.INPUT_VALUE_ID
, NULL
, '1'
, IVTL.LANGUAGE) = DECODE(IVTL.INPUT_VALUE_ID
, NULL
, '1'
, USERENV('LANG'))

Columns