View: HXC_APPLICATION_PERIODS_V

Product:	HXC - Time and Labor Engine
Description:
Implementation/DBA Data:	APPS.HXC_APPLICATION_PERIODS_V

View Text

SELECT HAP.TIME_BUILDING_BLOCK_ID
, HAP.OBJECT_VERSION_NUMBER
, HAP.START_TIME
, HAP.STOP_TIME
, HAP.TYPE
, HAP.MEASURE
, HAP.UNIT_OF_MEASURE
, HAP.PARENT_BUILDING_BLOCK_ID
, HAP.PARENT_BUILDING_BLOCK_OVN
, HAP.SCOPE
, HAP.APPROVAL_STYLE_ID
, HAP.APPROVAL_STATUS
, HAP.RESOURCE_TYPE
, HAP.RESOURCE_ID
, HTA.ATTRIBUTE6
, HTA.ATTRIBUTE1
, HTA.ATTRIBUTE2
, HTA.ATTRIBUTE3
, HTA.ATTRIBUTE7
, HAP.OBJECT_VERSION_NUMBER
, HAP.CREATION_DATE
FROM HXC_TIME_BUILDING_BLOCKS HAP
, HXC_TIME_ATTRIBUTE_USAGES HTAU
, HXC_TIME_ATTRIBUTES HTA
WHERE HAP.SCOPE = 'APPLICATION_PERIOD'
AND HAP.TYPE = 'RANGE'
AND HAP.DATE_TO = HR_GENERAL.END_OF_TIME
AND HAP.RESOURCE_TYPE = 'PERSON'
AND HAP.TIME_BUILDING_BLOCK_ID = HTAU.TIME_BUILDING_BLOCK_ID
AND HAP.OBJECT_VERSION_NUMBER = HTAU.TIME_BUILDING_BLOCK_OVN
AND HTAU.TIME_ATTRIBUTE_ID = HTA.TIME_ATTRIBUTE_ID
AND HTA.ATTRIBUTE_CATEGORY = 'APPROVAL'
AND HAP.OBJECT_VERSION_NUMBER = (SELECT MAX(OBJECT_VERSION_NUMBER)
FROM HXC_TIME_BUILDING_BLOCKS
WHERE TIME_BUILDING_BLOCK_ID = HAP.TIME_BUILDING_BLOCK_ID)

Columns