View: PER_ABSENCE_ATTENDANCES_V2

Product:	PER - Human Resources
Description:	List of employees by absence type.
Implementation/DBA Data:	APPS.PER_ABSENCE_ATTENDANCES_V2

View Text

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
FROM PER_ABSENCE_ATTENDANCES AA
, PER_ABSENCE_ATTENDANCE_TYPES 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)))

Columns