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.

APPS.HXC_APP_PERIOD_SUMMARY_PKG dependencies on HXC_TIME_ATTRIBUTE_USAGES

Line 93: from hxc_time_building_blocks tbb, hxc_time_attribute_usages tau, hxc_time_attributes ta1

89: ,ta1.attribute4 notification_status
90: ,decode(ta1.attribute3,'NA',0,to_number(ta1.attribute3)) approver_id
91: ,tbb.object_version_number application_period_ovn
92: ,tbb.data_set_id
93: from hxc_time_building_blocks tbb, hxc_time_attribute_usages tau, hxc_time_attributes ta1
94: where tbb.time_building_block_id = p_id
95: and tbb.date_to = hr_general.end_of_time
96: and tbb.scope = 'APPLICATION_PERIOD'
97: and tau.time_building_block_id = tbb.time_building_block_id

Line 102: (select max(time_attribute_usage_id) from hxc_time_attribute_usages tau2

98: and tau.time_building_block_ovn = tbb.object_version_number
99: and tau.time_attribute_id = ta1.time_attribute_id
100: and ta1.attribute_category = 'APPROVAL'
101: and tau.time_attribute_usage_id =
102: (select max(time_attribute_usage_id) from hxc_time_attribute_usages tau2
103: where tau2.time_building_block_id = tau.time_building_block_id
104: and tau2.time_building_block_ovn = tau.time_building_block_ovn
105: );
106: