View: PER_ABS_ATTENDANCE_TYPES_V

Product:	PER - Human Resources
Description:	User defined absence types.
Implementation/DBA Data:	APPS.PER_ABS_ATTENDANCE_TYPES_V

View Text

SELECT ABT.ROWID
, ABT.ABSENCE_ATTENDANCE_TYPE_ID
, ABT.BUSINESS_GROUP_ID
, ABT.INPUT_VALUE_ID
, ABT.DATE_EFFECTIVE
, ABTL.NAME
, ABT.ABSENCE_CATEGORY
, ABT.COMMENTS
, ABT.DATE_END
, ABT.HOURS_OR_DAYS
, ABT.INCREASING_OR_DECREASING_FLAG
, ABT.REQUEST_ID
, ABT.PROGRAM_APPLICATION_ID
, ABT.PROGRAM_ID
, ABT.PROGRAM_UPDATE_DATE
, ABT.ATTRIBUTE_CATEGORY
, ABT.ATTRIBUTE1
, ABT.ATTRIBUTE2
, ABT.ATTRIBUTE3
, ABT.ATTRIBUTE4
, ABT.ATTRIBUTE5
, ABT.ATTRIBUTE6
, ABT.ATTRIBUTE7
, ABT.ATTRIBUTE8
, ABT.ATTRIBUTE9
, ABT.ATTRIBUTE10
, ABT.ATTRIBUTE11
, ABT.ATTRIBUTE12
, ABT.ATTRIBUTE13
, ABT.ATTRIBUTE14
, ABT.ATTRIBUTE15
, ABT.ATTRIBUTE16
, ABT.ATTRIBUTE17
, ABT.ATTRIBUTE18
, ABT.ATTRIBUTE19
, ABT.ATTRIBUTE20
, ABT.LAST_UPDATE_DATE
, ABT.LAST_UPDATED_BY
, ABT.LAST_UPDATE_LOGIN
, ABT.CREATED_BY
, ABT.CREATION_DATE
, LKP1.MEANING
, LKP2.MEANING
, LKP3.MEANING
, ELTTL.ELEMENT_NAME
, IPV.ELEMENT_TYPE_ID
, IPVTL.NAME
, IPV.UOM
, ABT.OBJECT_VERSION_NUMBER
, ABT.INFORMATION_CATEGORY
, ABT.INFORMATION1
, ABT.INFORMATION2
, ABT.INFORMATION3
, ABT.INFORMATION4
, ABT.INFORMATION5
, ABT.INFORMATION6
, ABT.INFORMATION7
, ABT.INFORMATION8
, ABT.INFORMATION9
, ABT.INFORMATION10
, ABT.INFORMATION11
, ABT.INFORMATION12
, ABT.INFORMATION13
, ABT.INFORMATION14
, ABT.INFORMATION15
, ABT.INFORMATION16
, ABT.INFORMATION17
, ABT.INFORMATION18
, ABT.INFORMATION19
, ABT.INFORMATION20
FROM PER_ABSENCE_ATTENDANCE_TYPES ABT
, PER_ABS_ATTENDANCE_TYPES_TL ABTL
, PAY_INPUT_VALUES_F IPV
, PAY_INPUT_VALUES_F_TL IPVTL
, PAY_ELEMENT_TYPES_F ELT
, PAY_ELEMENT_TYPES_F_TL ELTTL
, HR_LOOKUPS LKP1
, HR_LOOKUPS LKP2
, HR_LOOKUPS LKP3
WHERE ABT.INPUT_VALUE_ID = IPV.INPUT_VALUE_ID(+)
AND IPV.ELEMENT_TYPE_ID = ELT.ELEMENT_TYPE_ID(+)
AND ELT.ELEMENT_TYPE_ID = ELTTL.ELEMENT_TYPE_ID(+)
AND IPV.INPUT_VALUE_ID = IPVTL.INPUT_VALUE_ID(+)
AND ABT.INCREASING_OR_DECREASING_FLAG = LKP2.LOOKUP_CODE(+)
AND ABT.ABSENCE_CATEGORY = LKP3.LOOKUP_CODE(+)
AND ABT.HOURS_OR_DAYS = LKP1.LOOKUP_CODE(+)
AND LKP1.LOOKUP_TYPE(+) = 'HOURS_OR_DAYS'
AND LKP2.LOOKUP_TYPE(+) = 'INCREASING_OR_DECREASING'
AND LKP3.LOOKUP_TYPE(+) = 'ABSENCE_CATEGORY'
AND ABT.DATE_EFFECTIVE BETWEEN NVL(IPV.EFFECTIVE_START_DATE
, ABT.DATE_EFFECTIVE)
AND NVL(IPV.EFFECTIVE_END_DATE
, ABT.DATE_EFFECTIVE)
AND ABT.DATE_EFFECTIVE BETWEEN NVL(ELT.EFFECTIVE_START_DATE
, ABT.DATE_EFFECTIVE)
AND NVL(ELT.EFFECTIVE_END_DATE
, ABT.DATE_EFFECTIVE)
AND DECODE(ELT.ELEMENT_TYPE_ID
, NULL
, '1'
, ELTTL.LANGUAGE) = DECODE (ELT.ELEMENT_TYPE_ID
, NULL
, '1'
, USERENV('LANG'))
AND DECODE( IPVTL.INPUT_VALUE_ID
, NULL
, '1'
, IPVTL.LANGUAGE) = DECODE(IPVTL.INPUT_VALUE_ID
, NULL
, '1'
, USERENV('LANG'))
AND ABTL.ABSENCE_ATTENDANCE_TYPE_ID = ABT.ABSENCE_ATTENDANCE_TYPE_ID
AND ABTL.LANGUAGE = USERENV('LANG')

Columns