VIEW: APPS.PER_ABSENCE_ATTENDANCES_V2

Source

View Text - Preformatted

SELECT PEO.FULL_NAME EMPLOYEE_NAME , PEO.EMPLOYEE_NUMBER , AA.LAST_UPDATE_DATE , AA.LAST_UPDATED_BY , AA.LAST_UPDATE_LOGIN , AA.CREATED_BY , AA.CREATION_DATE , AA.ABSENCE_ATTENDANCE_ID , AA.BUSINESS_GROUP_ID + 0 BUSINESS_GROUP_ID , AA.ABSENCE_ATTENDANCE_TYPE_ID , AA.PERSON_ID , AA.DATE_START , AA.DATE_END , AAT.NAME ABSENCE_TYPE , AAT.ABSENCE_CATEGORY ,AA.APPROVAL_STATUS ,AA.CONFIRMED_UNTIL ,AA.SOURCE ,AA.ADVANCE_PAY FROM PER_ABSENCE_ATTENDANCES AA, PER_ABS_ATTENDANCE_TYPES_VL AAT, PER_PEOPLE_F PEO WHERE AAT.ABSENCE_ATTENDANCE_TYPE_ID = AA.ABSENCE_ATTENDANCE_TYPE_ID AND PEO.PERSON_ID = AA.PERSON_ID AND ((NVL(AA.DATE_START, AA.DATE_PROJECTED_START) BETWEEN PEO.EFFECTIVE_START_DATE AND PEO.EFFECTIVE_END_DATE) OR (AA.DATE_START IS NULL AND AA.DATE_PROJECTED_START IS NULL AND PEO.EFFECTIVE_START_DATE = (SELECT MAX(PEO2.EFFECTIVE_START_DATE) FROM PER_ALL_PEOPLE_F PEO2 WHERE PEO2.PERSON_ID = PEO.PERSON_ID)))

View Text - HTML Formatted

SELECT PEO.FULL_NAME EMPLOYEE_NAME
, PEO.EMPLOYEE_NUMBER
, AA.LAST_UPDATE_DATE
, AA.LAST_UPDATED_BY
, AA.LAST_UPDATE_LOGIN
, AA.CREATED_BY
, AA.CREATION_DATE
, AA.ABSENCE_ATTENDANCE_ID
, AA.BUSINESS_GROUP_ID + 0 BUSINESS_GROUP_ID
, AA.ABSENCE_ATTENDANCE_TYPE_ID
, AA.PERSON_ID
, AA.DATE_START
, AA.DATE_END
, AAT.NAME ABSENCE_TYPE
, AAT.ABSENCE_CATEGORY
, AA.APPROVAL_STATUS
, AA.CONFIRMED_UNTIL
, AA.SOURCE
, AA.ADVANCE_PAY
FROM PER_ABSENCE_ATTENDANCES AA
, PER_ABS_ATTENDANCE_TYPES_VL AAT
, PER_PEOPLE_F PEO
WHERE AAT.ABSENCE_ATTENDANCE_TYPE_ID = AA.ABSENCE_ATTENDANCE_TYPE_ID
AND PEO.PERSON_ID = AA.PERSON_ID
AND ((NVL(AA.DATE_START
, AA.DATE_PROJECTED_START) BETWEEN PEO.EFFECTIVE_START_DATE
AND PEO.EFFECTIVE_END_DATE) OR (AA.DATE_START IS NULL
AND AA.DATE_PROJECTED_START IS NULL
AND PEO.EFFECTIVE_START_DATE = (SELECT MAX(PEO2.EFFECTIVE_START_DATE)
FROM PER_ALL_PEOPLE_F PEO2
WHERE PEO2.PERSON_ID = PEO.PERSON_ID)))