VIEW: APPS.HXC_APPROVAL_DETAILS_V

Source

View Text - Preformatted

SELECT hap.time_building_block_id, hap.object_version_number , hap.resource_id, hap.approval_status, htdetail.detail_measure, htdetail.detail_comment_text, decode(htdetail.detail_attribute_category, hma_project.context, decode(hma_project.segment, 'ATTRIBUTE1' , htdetail.detail_attribute1, 'ATTRIBUTE2' , htdetail.detail_attribute2, 'ATTRIBUTE3' , htdetail.detail_attribute3, 'ATTRIBUTE4' , htdetail.detail_attribute4, 'ATTRIBUTE5' , htdetail.detail_attribute5, 'ATTRIBUTE6' , htdetail.detail_attribute6, 'ATTRIBUTE7' , htdetail.detail_attribute7, 'ATTRIBUTE8' , htdetail.detail_attribute8, 'ATTRIBUTE9' , htdetail.detail_attribute9, 'ATTRIBUTE10' , htdetail.detail_attribute10, 'ATTRIBUTE11' , htdetail.detail_attribute11, 'ATTRIBUTE12' , htdetail.detail_attribute12, 'ATTRIBUTE13' , htdetail.detail_attribute13, 'ATTRIBUTE14' , htdetail.detail_attribute14, 'ATTRIBUTE15' , htdetail.detail_attribute15, 'ATTRIBUTE16' , htdetail.detail_attribute16, 'ATTRIBUTE17' , htdetail.detail_attribute17, 'ATTRIBUTE18' , htdetail.detail_attribute18, 'ATTRIBUTE19' , htdetail.detail_attribute19, 'ATTRIBUTE20' , htdetail.detail_attribute20, 'ATTRIBUTE21' , htdetail.detail_attribute21, 'ATTRIBUTE22' , htdetail.detail_attribute22, 'ATTRIBUTE23' , htdetail.detail_attribute23, 'ATTRIBUTE24' , htdetail.detail_attribute24, 'ATTRIBUTE25' , htdetail.detail_attribute25, 'ATTRIBUTE26' , htdetail.detail_attribute26, 'ATTRIBUTE27' , htdetail.detail_attribute27, 'ATTRIBUTE28' , htdetail.detail_attribute28, 'ATTRIBUTE29' , htdetail.detail_attribute29, 'ATTRIBUTE30' , htdetail.detail_attribute30 ), null), decode(htdetail.detail_attribute_category, hma_task.context,decode(hma_task.segment, 'ATTRIBUTE1' , htdetail.detail_attribute1, 'ATTRIBUTE2' , htdetail.detail_attribute2, 'ATTRIBUTE3' , htdetail.detail_attribute3, 'ATTRIBUTE4' , htdetail.detail_attribute4, 'ATTRIBUTE5' , htdetail.detail_attribute5, 'ATTRIBUTE6' , htdetail.detail_attribute6, 'ATTRIBUTE7' , htdetail.detail_attribute7, 'ATTRIBUTE8' , htdetail.detail_attribute8, 'ATTRIBUTE9' , htdetail.detail_attribute9, 'ATTRIBUTE10' , htdetail.detail_attribute10, 'ATTRIBUTE11' , htdetail.detail_attribute11, 'ATTRIBUTE12' , htdetail.detail_attribute12, 'ATTRIBUTE13' , htdetail.detail_attribute13, 'ATTRIBUTE14' , htdetail.detail_attribute14, 'ATTRIBUTE15' , htdetail.detail_attribute15, 'ATTRIBUTE16' , htdetail.detail_attribute16, 'ATTRIBUTE17' , htdetail.detail_attribute17, 'ATTRIBUTE18' , htdetail.detail_attribute18, 'ATTRIBUTE19' , htdetail.detail_attribute19, 'ATTRIBUTE20' , htdetail.detail_attribute20, 'ATTRIBUTE21' , htdetail.detail_attribute21, 'ATTRIBUTE22' , htdetail.detail_attribute22, 'ATTRIBUTE23' , htdetail.detail_attribute23, 'ATTRIBUTE24' , htdetail.detail_attribute24, 'ATTRIBUTE25' , htdetail.detail_attribute25, 'ATTRIBUTE26' , htdetail.detail_attribute26, 'ATTRIBUTE27' , htdetail.detail_attribute27, 'ATTRIBUTE28' , htdetail.detail_attribute28, 'ATTRIBUTE29' , htdetail.detail_attribute29, 'ATTRIBUTE30' , htdetail.detail_attribute30 ) , null), decode(htdetail.detail_attribute_category, hma_expenditure.context,decode(hma_expenditure.segment, 'ATTRIBUTE1' , htdetail.detail_attribute1, 'ATTRIBUTE2' , htdetail.detail_attribute2, 'ATTRIBUTE3' , htdetail.detail_attribute3, 'ATTRIBUTE4' , htdetail.detail_attribute4, 'ATTRIBUTE5' , htdetail.detail_attribute5, 'ATTRIBUTE6' , htdetail.detail_attribute6, 'ATTRIBUTE7' , htdetail.detail_attribute7, 'ATTRIBUTE8' , htdetail.detail_attribute8, 'ATTRIBUTE9' , htdetail.detail_attribute9, 'ATTRIBUTE10' , htdetail.detail_attribute10, 'ATTRIBUTE11' , htdetail.detail_attribute11, 'ATTRIBUTE12' , htdetail.detail_attribute12, 'ATTRIBUTE13' , htdetail.detail_attribute13, 'ATTRIBUTE14' , htdetail.detail_attribute14, 'ATTRIBUTE15' , htdetail.detail_attribute15, 'ATTRIBUTE16' , htdetail.detail_attribute16, 'ATTRIBUTE17' , htdetail.detail_attribute17, 'ATTRIBUTE18' , htdetail.detail_attribute18, 'ATTRIBUTE19' , htdetail.detail_attribute19, 'ATTRIBUTE20' , htdetail.detail_attribute20, 'ATTRIBUTE21' , htdetail.detail_attribute21, 'ATTRIBUTE22' , htdetail.detail_attribute22, 'ATTRIBUTE23' , htdetail.detail_attribute23, 'ATTRIBUTE24' , htdetail.detail_attribute24, 'ATTRIBUTE25' , htdetail.detail_attribute25, 'ATTRIBUTE26' , htdetail.detail_attribute26, 'ATTRIBUTE27' , htdetail.detail_attribute27, 'ATTRIBUTE28' , htdetail.detail_attribute28, 'ATTRIBUTE29' , htdetail.detail_attribute29, 'ATTRIBUTE30' , htdetail.detail_attribute30 ) , null), decode(htdetail.detail_attribute_category, hma_hours_type.context,substr(decode(hma_hours_type.segment, 'ATTRIBUTE1' , htdetail.detail_attribute1, 'ATTRIBUTE2' , htdetail.detail_attribute2, 'ATTRIBUTE3' , htdetail.detail_attribute3, 'ATTRIBUTE4' , htdetail.detail_attribute4, 'ATTRIBUTE5' , htdetail.detail_attribute5, 'ATTRIBUTE6' , htdetail.detail_attribute6, 'ATTRIBUTE7' , htdetail.detail_attribute7, 'ATTRIBUTE8' , htdetail.detail_attribute8, 'ATTRIBUTE9' , htdetail.detail_attribute9, 'ATTRIBUTE10' , htdetail.detail_attribute10, 'ATTRIBUTE11' , htdetail.detail_attribute11, 'ATTRIBUTE12' , htdetail.detail_attribute12, 'ATTRIBUTE13' , htdetail.detail_attribute13, 'ATTRIBUTE14' , htdetail.detail_attribute14, 'ATTRIBUTE15' , htdetail.detail_attribute15, 'ATTRIBUTE16' , htdetail.detail_attribute16, 'ATTRIBUTE17' , htdetail.detail_attribute17, 'ATTRIBUTE18' , htdetail.detail_attribute18, 'ATTRIBUTE19' , htdetail.detail_attribute19, 'ATTRIBUTE20' , htdetail.detail_attribute20, 'ATTRIBUTE21' , htdetail.detail_attribute21, 'ATTRIBUTE22' , htdetail.detail_attribute22, 'ATTRIBUTE23' , htdetail.detail_attribute23, 'ATTRIBUTE24' , htdetail.detail_attribute24, 'ATTRIBUTE25' , htdetail.detail_attribute25, 'ATTRIBUTE26' , htdetail.detail_attribute26, 'ATTRIBUTE27' , htdetail.detail_attribute27, 'ATTRIBUTE28' , htdetail.detail_attribute28, 'ATTRIBUTE29' , htdetail.detail_attribute29, 'ATTRIBUTE30' , htdetail.detail_attribute30 ) ,11,20) , null), ht.tcrd_start_time, ht.tcrd_stop_time, hr_general.decode_lookup('HXC_APPROVAL_STATUS',ht.tcrd_approval_status), ht.tcrd_comment_text, ht.tcrd_submission_date, ht.tcrd_resource_id, ht.tcrd_resource_type, ppf.full_name, hap.application from hxc_application_periods_v hap, hxc_timecard_days_v htday, hxc_timecard_details_v htdetail, hxc_timecards_v ht, per_people_f ppf ,hxc_mapping_attributes_v hma_project ,hxc_mapping_attributes_v hma_task,hxc_mapping_attributes_v hma_expenditure ,hxc_mapping_attributes_v hma_hours_type WHERE htday.day_start_time >= hap.start_time and htday.day_start_time <= hap.stop_time and htday.day_resource_id = hap.resource_id and htdetail.detail_parent_timecard_id = htday.day_timecard_id and htdetail.detail_parent_object_version = htday.day_timecard_ovn and ht.tcrd_time_building_block_id = htday.day_parent_id and ht.tcrd_object_version_number = htday.day_parent_ovn and sysdate between ppf.effective_start_date and ppf.effective_end_date and ppf.person_id = hap.resource_id and hma_project.map = 'OTC Deposit Process Mapping' and hma_project.field_name ='Project_Id' and hma_task.map = 'OTC Deposit Process Mapping' and hma_task.field_name ='Task_Id' and hma_expenditure.map = 'OTC Deposit Process Mapping' and hma_expenditure.field_name ='Expenditure_Type' and hma_hours_type.map = 'OTC Deposit Process Mapping' and hma_hours_type.field_name = 'Dummy Element Context'

View Text - HTML Formatted

SELECT HAP.TIME_BUILDING_BLOCK_ID
, HAP.OBJECT_VERSION_NUMBER
, HAP.RESOURCE_ID
, HAP.APPROVAL_STATUS
, HTDETAIL.DETAIL_MEASURE
, HTDETAIL.DETAIL_COMMENT_TEXT
, DECODE(HTDETAIL.DETAIL_ATTRIBUTE_CATEGORY
, HMA_PROJECT.CONTEXT
, DECODE(HMA_PROJECT.SEGMENT
, 'ATTRIBUTE1'
, HTDETAIL.DETAIL_ATTRIBUTE1
, 'ATTRIBUTE2'
, HTDETAIL.DETAIL_ATTRIBUTE2
, 'ATTRIBUTE3'
, HTDETAIL.DETAIL_ATTRIBUTE3
, 'ATTRIBUTE4'
, HTDETAIL.DETAIL_ATTRIBUTE4
, 'ATTRIBUTE5'
, HTDETAIL.DETAIL_ATTRIBUTE5
, 'ATTRIBUTE6'
, HTDETAIL.DETAIL_ATTRIBUTE6
, 'ATTRIBUTE7'
, HTDETAIL.DETAIL_ATTRIBUTE7
, 'ATTRIBUTE8'
, HTDETAIL.DETAIL_ATTRIBUTE8
, 'ATTRIBUTE9'
, HTDETAIL.DETAIL_ATTRIBUTE9
, 'ATTRIBUTE10'
, HTDETAIL.DETAIL_ATTRIBUTE10
, 'ATTRIBUTE11'
, HTDETAIL.DETAIL_ATTRIBUTE11
, 'ATTRIBUTE12'
, HTDETAIL.DETAIL_ATTRIBUTE12
, 'ATTRIBUTE13'
, HTDETAIL.DETAIL_ATTRIBUTE13
, 'ATTRIBUTE14'
, HTDETAIL.DETAIL_ATTRIBUTE14
, 'ATTRIBUTE15'
, HTDETAIL.DETAIL_ATTRIBUTE15
, 'ATTRIBUTE16'
, HTDETAIL.DETAIL_ATTRIBUTE16
, 'ATTRIBUTE17'
, HTDETAIL.DETAIL_ATTRIBUTE17
, 'ATTRIBUTE18'
, HTDETAIL.DETAIL_ATTRIBUTE18
, 'ATTRIBUTE19'
, HTDETAIL.DETAIL_ATTRIBUTE19
, 'ATTRIBUTE20'
, HTDETAIL.DETAIL_ATTRIBUTE20
, 'ATTRIBUTE21'
, HTDETAIL.DETAIL_ATTRIBUTE21
, 'ATTRIBUTE22'
, HTDETAIL.DETAIL_ATTRIBUTE22
, 'ATTRIBUTE23'
, HTDETAIL.DETAIL_ATTRIBUTE23
, 'ATTRIBUTE24'
, HTDETAIL.DETAIL_ATTRIBUTE24
, 'ATTRIBUTE25'
, HTDETAIL.DETAIL_ATTRIBUTE25
, 'ATTRIBUTE26'
, HTDETAIL.DETAIL_ATTRIBUTE26
, 'ATTRIBUTE27'
, HTDETAIL.DETAIL_ATTRIBUTE27
, 'ATTRIBUTE28'
, HTDETAIL.DETAIL_ATTRIBUTE28
, 'ATTRIBUTE29'
, HTDETAIL.DETAIL_ATTRIBUTE29
, 'ATTRIBUTE30'
, HTDETAIL.DETAIL_ATTRIBUTE30 )
, NULL)
, DECODE(HTDETAIL.DETAIL_ATTRIBUTE_CATEGORY
, HMA_TASK.CONTEXT
, DECODE(HMA_TASK.SEGMENT
, 'ATTRIBUTE1'
, HTDETAIL.DETAIL_ATTRIBUTE1
, 'ATTRIBUTE2'
, HTDETAIL.DETAIL_ATTRIBUTE2
, 'ATTRIBUTE3'
, HTDETAIL.DETAIL_ATTRIBUTE3
, 'ATTRIBUTE4'
, HTDETAIL.DETAIL_ATTRIBUTE4
, 'ATTRIBUTE5'
, HTDETAIL.DETAIL_ATTRIBUTE5
, 'ATTRIBUTE6'
, HTDETAIL.DETAIL_ATTRIBUTE6
, 'ATTRIBUTE7'
, HTDETAIL.DETAIL_ATTRIBUTE7
, 'ATTRIBUTE8'
, HTDETAIL.DETAIL_ATTRIBUTE8
, 'ATTRIBUTE9'
, HTDETAIL.DETAIL_ATTRIBUTE9
, 'ATTRIBUTE10'
, HTDETAIL.DETAIL_ATTRIBUTE10
, 'ATTRIBUTE11'
, HTDETAIL.DETAIL_ATTRIBUTE11
, 'ATTRIBUTE12'
, HTDETAIL.DETAIL_ATTRIBUTE12
, 'ATTRIBUTE13'
, HTDETAIL.DETAIL_ATTRIBUTE13
, 'ATTRIBUTE14'
, HTDETAIL.DETAIL_ATTRIBUTE14
, 'ATTRIBUTE15'
, HTDETAIL.DETAIL_ATTRIBUTE15
, 'ATTRIBUTE16'
, HTDETAIL.DETAIL_ATTRIBUTE16
, 'ATTRIBUTE17'
, HTDETAIL.DETAIL_ATTRIBUTE17
, 'ATTRIBUTE18'
, HTDETAIL.DETAIL_ATTRIBUTE18
, 'ATTRIBUTE19'
, HTDETAIL.DETAIL_ATTRIBUTE19
, 'ATTRIBUTE20'
, HTDETAIL.DETAIL_ATTRIBUTE20
, 'ATTRIBUTE21'
, HTDETAIL.DETAIL_ATTRIBUTE21
, 'ATTRIBUTE22'
, HTDETAIL.DETAIL_ATTRIBUTE22
, 'ATTRIBUTE23'
, HTDETAIL.DETAIL_ATTRIBUTE23
, 'ATTRIBUTE24'
, HTDETAIL.DETAIL_ATTRIBUTE24
, 'ATTRIBUTE25'
, HTDETAIL.DETAIL_ATTRIBUTE25
, 'ATTRIBUTE26'
, HTDETAIL.DETAIL_ATTRIBUTE26
, 'ATTRIBUTE27'
, HTDETAIL.DETAIL_ATTRIBUTE27
, 'ATTRIBUTE28'
, HTDETAIL.DETAIL_ATTRIBUTE28
, 'ATTRIBUTE29'
, HTDETAIL.DETAIL_ATTRIBUTE29
, 'ATTRIBUTE30'
, HTDETAIL.DETAIL_ATTRIBUTE30 )
, NULL)
, DECODE(HTDETAIL.DETAIL_ATTRIBUTE_CATEGORY
, HMA_EXPENDITURE.CONTEXT
, DECODE(HMA_EXPENDITURE.SEGMENT
, 'ATTRIBUTE1'
, HTDETAIL.DETAIL_ATTRIBUTE1
, 'ATTRIBUTE2'
, HTDETAIL.DETAIL_ATTRIBUTE2
, 'ATTRIBUTE3'
, HTDETAIL.DETAIL_ATTRIBUTE3
, 'ATTRIBUTE4'
, HTDETAIL.DETAIL_ATTRIBUTE4
, 'ATTRIBUTE5'
, HTDETAIL.DETAIL_ATTRIBUTE5
, 'ATTRIBUTE6'
, HTDETAIL.DETAIL_ATTRIBUTE6
, 'ATTRIBUTE7'
, HTDETAIL.DETAIL_ATTRIBUTE7
, 'ATTRIBUTE8'
, HTDETAIL.DETAIL_ATTRIBUTE8
, 'ATTRIBUTE9'
, HTDETAIL.DETAIL_ATTRIBUTE9
, 'ATTRIBUTE10'
, HTDETAIL.DETAIL_ATTRIBUTE10
, 'ATTRIBUTE11'
, HTDETAIL.DETAIL_ATTRIBUTE11
, 'ATTRIBUTE12'
, HTDETAIL.DETAIL_ATTRIBUTE12
, 'ATTRIBUTE13'
, HTDETAIL.DETAIL_ATTRIBUTE13
, 'ATTRIBUTE14'
, HTDETAIL.DETAIL_ATTRIBUTE14
, 'ATTRIBUTE15'
, HTDETAIL.DETAIL_ATTRIBUTE15
, 'ATTRIBUTE16'
, HTDETAIL.DETAIL_ATTRIBUTE16
, 'ATTRIBUTE17'
, HTDETAIL.DETAIL_ATTRIBUTE17
, 'ATTRIBUTE18'
, HTDETAIL.DETAIL_ATTRIBUTE18
, 'ATTRIBUTE19'
, HTDETAIL.DETAIL_ATTRIBUTE19
, 'ATTRIBUTE20'
, HTDETAIL.DETAIL_ATTRIBUTE20
, 'ATTRIBUTE21'
, HTDETAIL.DETAIL_ATTRIBUTE21
, 'ATTRIBUTE22'
, HTDETAIL.DETAIL_ATTRIBUTE22
, 'ATTRIBUTE23'
, HTDETAIL.DETAIL_ATTRIBUTE23
, 'ATTRIBUTE24'
, HTDETAIL.DETAIL_ATTRIBUTE24
, 'ATTRIBUTE25'
, HTDETAIL.DETAIL_ATTRIBUTE25
, 'ATTRIBUTE26'
, HTDETAIL.DETAIL_ATTRIBUTE26
, 'ATTRIBUTE27'
, HTDETAIL.DETAIL_ATTRIBUTE27
, 'ATTRIBUTE28'
, HTDETAIL.DETAIL_ATTRIBUTE28
, 'ATTRIBUTE29'
, HTDETAIL.DETAIL_ATTRIBUTE29
, 'ATTRIBUTE30'
, HTDETAIL.DETAIL_ATTRIBUTE30 )
, NULL)
, DECODE(HTDETAIL.DETAIL_ATTRIBUTE_CATEGORY
, HMA_HOURS_TYPE.CONTEXT
, SUBSTR(DECODE(HMA_HOURS_TYPE.SEGMENT
, 'ATTRIBUTE1'
, HTDETAIL.DETAIL_ATTRIBUTE1
, 'ATTRIBUTE2'
, HTDETAIL.DETAIL_ATTRIBUTE2
, 'ATTRIBUTE3'
, HTDETAIL.DETAIL_ATTRIBUTE3
, 'ATTRIBUTE4'
, HTDETAIL.DETAIL_ATTRIBUTE4
, 'ATTRIBUTE5'
, HTDETAIL.DETAIL_ATTRIBUTE5
, 'ATTRIBUTE6'
, HTDETAIL.DETAIL_ATTRIBUTE6
, 'ATTRIBUTE7'
, HTDETAIL.DETAIL_ATTRIBUTE7
, 'ATTRIBUTE8'
, HTDETAIL.DETAIL_ATTRIBUTE8
, 'ATTRIBUTE9'
, HTDETAIL.DETAIL_ATTRIBUTE9
, 'ATTRIBUTE10'
, HTDETAIL.DETAIL_ATTRIBUTE10
, 'ATTRIBUTE11'
, HTDETAIL.DETAIL_ATTRIBUTE11
, 'ATTRIBUTE12'
, HTDETAIL.DETAIL_ATTRIBUTE12
, 'ATTRIBUTE13'
, HTDETAIL.DETAIL_ATTRIBUTE13
, 'ATTRIBUTE14'
, HTDETAIL.DETAIL_ATTRIBUTE14
, 'ATTRIBUTE15'
, HTDETAIL.DETAIL_ATTRIBUTE15
, 'ATTRIBUTE16'
, HTDETAIL.DETAIL_ATTRIBUTE16
, 'ATTRIBUTE17'
, HTDETAIL.DETAIL_ATTRIBUTE17
, 'ATTRIBUTE18'
, HTDETAIL.DETAIL_ATTRIBUTE18
, 'ATTRIBUTE19'
, HTDETAIL.DETAIL_ATTRIBUTE19
, 'ATTRIBUTE20'
, HTDETAIL.DETAIL_ATTRIBUTE20
, 'ATTRIBUTE21'
, HTDETAIL.DETAIL_ATTRIBUTE21
, 'ATTRIBUTE22'
, HTDETAIL.DETAIL_ATTRIBUTE22
, 'ATTRIBUTE23'
, HTDETAIL.DETAIL_ATTRIBUTE23
, 'ATTRIBUTE24'
, HTDETAIL.DETAIL_ATTRIBUTE24
, 'ATTRIBUTE25'
, HTDETAIL.DETAIL_ATTRIBUTE25
, 'ATTRIBUTE26'
, HTDETAIL.DETAIL_ATTRIBUTE26
, 'ATTRIBUTE27'
, HTDETAIL.DETAIL_ATTRIBUTE27
, 'ATTRIBUTE28'
, HTDETAIL.DETAIL_ATTRIBUTE28
, 'ATTRIBUTE29'
, HTDETAIL.DETAIL_ATTRIBUTE29
, 'ATTRIBUTE30'
, HTDETAIL.DETAIL_ATTRIBUTE30 )
, 11
, 20)
, NULL)
, HT.TCRD_START_TIME
, HT.TCRD_STOP_TIME
, HR_GENERAL.DECODE_LOOKUP('HXC_APPROVAL_STATUS'
, HT.TCRD_APPROVAL_STATUS)
, HT.TCRD_COMMENT_TEXT
, HT.TCRD_SUBMISSION_DATE
, HT.TCRD_RESOURCE_ID
, HT.TCRD_RESOURCE_TYPE
, PPF.FULL_NAME
, HAP.APPLICATION
FROM HXC_APPLICATION_PERIODS_V HAP
, HXC_TIMECARD_DAYS_V HTDAY
, HXC_TIMECARD_DETAILS_V HTDETAIL
, HXC_TIMECARDS_V HT
, PER_PEOPLE_F PPF
, HXC_MAPPING_ATTRIBUTES_V HMA_PROJECT
, HXC_MAPPING_ATTRIBUTES_V HMA_TASK
, HXC_MAPPING_ATTRIBUTES_V HMA_EXPENDITURE
, HXC_MAPPING_ATTRIBUTES_V HMA_HOURS_TYPE
WHERE HTDAY.DAY_START_TIME >= HAP.START_TIME
AND HTDAY.DAY_START_TIME <= HAP.STOP_TIME
AND HTDAY.DAY_RESOURCE_ID = HAP.RESOURCE_ID
AND HTDETAIL.DETAIL_PARENT_TIMECARD_ID = HTDAY.DAY_TIMECARD_ID
AND HTDETAIL.DETAIL_PARENT_OBJECT_VERSION = HTDAY.DAY_TIMECARD_OVN
AND HT.TCRD_TIME_BUILDING_BLOCK_ID = HTDAY.DAY_PARENT_ID
AND HT.TCRD_OBJECT_VERSION_NUMBER = HTDAY.DAY_PARENT_OVN
AND SYSDATE BETWEEN PPF.EFFECTIVE_START_DATE
AND PPF.EFFECTIVE_END_DATE
AND PPF.PERSON_ID = HAP.RESOURCE_ID
AND HMA_PROJECT.MAP = 'OTC DEPOSIT PROCESS MAPPING'
AND HMA_PROJECT.FIELD_NAME ='PROJECT_ID'
AND HMA_TASK.MAP = 'OTC DEPOSIT PROCESS MAPPING'
AND HMA_TASK.FIELD_NAME ='TASK_ID'
AND HMA_EXPENDITURE.MAP = 'OTC DEPOSIT PROCESS MAPPING'
AND HMA_EXPENDITURE.FIELD_NAME ='EXPENDITURE_TYPE'
AND HMA_HOURS_TYPE.MAP = 'OTC DEPOSIT PROCESS MAPPING'
AND HMA_HOURS_TYPE.FIELD_NAME = 'DUMMY ELEMENT CONTEXT'