View: HXC_APPL_PERIOD_DETAILS_V

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

View Text

SELECT HAP.TIME_BUILDING_BLOCK_ID
, HAP.RESOURCE_ID
, HAP.APPROVAL_STATUS
, HTB_TIMECARD.TIME_BUILDING_BLOCK_ID
, HTB_TIMECARD.START_TIME
, HTB_TIMECARD.STOP_TIME
, HTB_TIMECARD.APPROVAL_STATUS
, HTA.ATTRIBUTE1
FROM HXC_TIME_BUILDING_BLOCKS HAP
, HXC_TIME_BUILDING_BLOCKS HTB_TIMECARD
, 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 HTAU.TIME_ATTRIBUTE_ID = HTA.TIME_ATTRIBUTE_ID
AND HTA.ATTRIBUTE_CATEGORY = 'APPROVAL'
AND HAP.TIME_BUILDING_BLOCK_ID = HTAU.TIME_BUILDING_BLOCK_ID
AND HTAU.TIME_ATTRIBUTE_ID = HTA.TIME_ATTRIBUTE_ID
AND HTA.ATTRIBUTE_CATEGORY = 'APPROVAL'
AND HTB_TIMECARD.SCOPE = 'TIMECARD'
AND HTB_TIMECARD.TYPE = 'RANGE'
AND HTB_TIMECARD.DATE_TO = HR_GENERAL.END_OF_TIME
AND HTB_TIMECARD.RESOURCE_TYPE = 'PERSON'
AND HTB_TIMECARD.START_TIME >= HAP.START_TIME
AND HTB_TIMECARD.START_TIME <= HAP.STOP_TIME
AND HTB_TIMECARD.RESOURCE_ID = HAP.RESOURCE_ID

Columns