VIEW: APPS.PER_ABSENCE_ATTENDANCES_V

Source

View Text - Preformatted

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 ,ABA.APPROVAL_STATUS ,ABA.CONFIRMED_UNTIL ,ABA.SOURCE ,ABA.ADVANCE_PAY ,ABA.ABSENCE_CASE_ID FROM PER_ABSENCE_ATTENDANCES ABA, PER_ABS_ATTENDANCE_TYPES_VL 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_START,NVL (DATE_PROJECTED_START,SYSDATE)) BETWEEN NVL(PEP.EFFECTIVE_START_DATE, NVL(ABA.DATE_START,NVL (DATE_PROJECTED_START,SYSDATE))) AND NVL(PEP.EFFECTIVE_END_DATE, NVL(ABA.DATE_START,NVL (DATE_PROJECTED_START,SYSDATE))) AND NVL(ABA.DATE_START,NVL (DATE_PROJECTED_START,SYSDATE)) BETWEEN NVL( PEP2.EFFECTIVE_START_DATE, NVL(ABA.DATE_START,NVL (DATE_PROJECTED_START,SYSDATE))) AND NVL(PEP2.EFFECTIVE_END_DATE, NVL(ABA.DATE_START,NVL (DATE_PROJECTED_START,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'))

View Text - HTML Formatted

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
, ABA.APPROVAL_STATUS
, ABA.CONFIRMED_UNTIL
, ABA.SOURCE
, ABA.ADVANCE_PAY
, ABA.ABSENCE_CASE_ID
FROM PER_ABSENCE_ATTENDANCES ABA
, PER_ABS_ATTENDANCE_TYPES_VL 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_START
, NVL (DATE_PROJECTED_START
, SYSDATE)) BETWEEN NVL(PEP.EFFECTIVE_START_DATE
, NVL(ABA.DATE_START
, NVL (DATE_PROJECTED_START
, SYSDATE)))
AND NVL(PEP.EFFECTIVE_END_DATE
, NVL(ABA.DATE_START
, NVL (DATE_PROJECTED_START
, SYSDATE)))
AND NVL(ABA.DATE_START
, NVL (DATE_PROJECTED_START
, SYSDATE)) BETWEEN NVL( PEP2.EFFECTIVE_START_DATE
, NVL(ABA.DATE_START
, NVL (DATE_PROJECTED_START
, SYSDATE)))
AND NVL(PEP2.EFFECTIVE_END_DATE
, NVL(ABA.DATE_START
, NVL (DATE_PROJECTED_START
, 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'))