eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.HXC_APPL_PERIOD_DETAILS_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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