VIEW: APPS.HRBV_ABSENCE_ATTENDANCES_V

Source

View Text - Preformatted

SELECT ABS.ABSENCE_DAYS, ABS.ABSENCE_HOURS, ABS.COMMENTS, ABS.DATE_END, ABS.DATE_NOTIFICATION, ABS.DATE_PROJECTED_END, ABS.DATE_PROJECTED_START, ABS.DATE_START, ABS.OCCURRENCE, ABS.SSP1_ISSUED, ABS.TIME_END, ABS.TIME_PROJECTED_END, ABS.TIME_PROJECTED_START, ABS.TIME_START, ABS.PROGRAM_UPDATE_DATE, ABS.SICKNESS_START_DATE, ABS.SICKNESS_END_DATE, ABS.PREGNANCY_RELATED_ILLNESS, ABS.REASON_FOR_NOTIFICATION_DELAY, ABS.ABS_INFORMATION_CATEGORY, ABS.ABS_INFORMATION1, ABS.ABS_INFORMATION2, ABS.ABS_INFORMATION3, ABS.ABS_INFORMATION4, ABS.ABS_INFORMATION5, ABS.ABS_INFORMATION6, ABS.ABS_INFORMATION7, ABS.ABS_INFORMATION8, ABS.ABS_INFORMATION9, ABS.ABS_INFORMATION10, ABS.ABS_INFORMATION11, ABS.ABS_INFORMATION12, ABS.ABS_INFORMATION13, ABS.ABS_INFORMATION14, ABS.ABS_INFORMATION15, ABS.ABS_INFORMATION16, ABS.ABS_INFORMATION17, ABS.ABS_INFORMATION18, ABS.ABS_INFORMATION19, ABS.ABS_INFORMATION20, ABS.ABS_INFORMATION21, ABS.ABS_INFORMATION22, ABS.ABS_INFORMATION23, ABS.ABS_INFORMATION24, ABS.ABS_INFORMATION25, ABS.ABS_INFORMATION26, ABS.ABS_INFORMATION27, ABS.ABS_INFORMATION28, ABS.ABS_INFORMATION29, ABS.ABS_INFORMATION30, '_DF:PER:PER_ABSENCE_ATTENDANCES:ABS', ABS.ACCEPT_LATE_NOTIFICATION_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',ABS.ACCEPT_LATE_NOTIFICATION_FLAG), HR_API.RETURN_LEGISLATION_CODE(ABS.BUSINESS_GROUP_ID), ABS.ABSENCE_ATTENDANCE_ID, ABS.BUSINESS_GROUP_ID, ABS.ABSENCE_ATTENDANCE_TYPE_ID, ABS.ABS_ATTENDANCE_REASON_ID, ABS.PERSON_ID, ABS.AUTHORISING_PERSON_ID, ABS.REPLACEMENT_PERSON_ID, ABS.PERIOD_OF_INCAPACITY_ID, ABS.MATERNITY_ID, ABS.LINKED_ABSENCE_ID, ABS.BATCH_ID, ABS.LAST_UPDATE_DATE, ABS.LAST_UPDATED_BY, ABS.CREATED_BY, ABS.CREATION_DATE, CASE WHEN ABS.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, ABS.BUSINESS_GROUP_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE FROM PER_ABSENCE_ATTENDANCES ABS WITH READ ONLY

View Text - HTML Formatted

SELECT ABS.ABSENCE_DAYS
, ABS.ABSENCE_HOURS
, ABS.COMMENTS
, ABS.DATE_END
, ABS.DATE_NOTIFICATION
, ABS.DATE_PROJECTED_END
, ABS.DATE_PROJECTED_START
, ABS.DATE_START
, ABS.OCCURRENCE
, ABS.SSP1_ISSUED
, ABS.TIME_END
, ABS.TIME_PROJECTED_END
, ABS.TIME_PROJECTED_START
, ABS.TIME_START
, ABS.PROGRAM_UPDATE_DATE
, ABS.SICKNESS_START_DATE
, ABS.SICKNESS_END_DATE
, ABS.PREGNANCY_RELATED_ILLNESS
, ABS.REASON_FOR_NOTIFICATION_DELAY
, ABS.ABS_INFORMATION_CATEGORY
, ABS.ABS_INFORMATION1
, ABS.ABS_INFORMATION2
, ABS.ABS_INFORMATION3
, ABS.ABS_INFORMATION4
, ABS.ABS_INFORMATION5
, ABS.ABS_INFORMATION6
, ABS.ABS_INFORMATION7
, ABS.ABS_INFORMATION8
, ABS.ABS_INFORMATION9
, ABS.ABS_INFORMATION10
, ABS.ABS_INFORMATION11
, ABS.ABS_INFORMATION12
, ABS.ABS_INFORMATION13
, ABS.ABS_INFORMATION14
, ABS.ABS_INFORMATION15
, ABS.ABS_INFORMATION16
, ABS.ABS_INFORMATION17
, ABS.ABS_INFORMATION18
, ABS.ABS_INFORMATION19
, ABS.ABS_INFORMATION20
, ABS.ABS_INFORMATION21
, ABS.ABS_INFORMATION22
, ABS.ABS_INFORMATION23
, ABS.ABS_INFORMATION24
, ABS.ABS_INFORMATION25
, ABS.ABS_INFORMATION26
, ABS.ABS_INFORMATION27
, ABS.ABS_INFORMATION28
, ABS.ABS_INFORMATION29
, ABS.ABS_INFORMATION30
, '_DF:PER:PER_ABSENCE_ATTENDANCES:ABS'
, ABS.ACCEPT_LATE_NOTIFICATION_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ABS.ACCEPT_LATE_NOTIFICATION_FLAG)
, HR_API.RETURN_LEGISLATION_CODE(ABS.BUSINESS_GROUP_ID)
, ABS.ABSENCE_ATTENDANCE_ID
, ABS.BUSINESS_GROUP_ID
, ABS.ABSENCE_ATTENDANCE_TYPE_ID
, ABS.ABS_ATTENDANCE_REASON_ID
, ABS.PERSON_ID
, ABS.AUTHORISING_PERSON_ID
, ABS.REPLACEMENT_PERSON_ID
, ABS.PERIOD_OF_INCAPACITY_ID
, ABS.MATERNITY_ID
, ABS.LINKED_ABSENCE_ID
, ABS.BATCH_ID
, ABS.LAST_UPDATE_DATE
, ABS.LAST_UPDATED_BY
, ABS.CREATED_BY
, ABS.CREATION_DATE
, CASE WHEN ABS.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, ABS.BUSINESS_GROUP_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
FROM PER_ABSENCE_ATTENDANCES ABS WITH READ ONLY