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_TCSUMMARY_MIGRATE dependencies on HXC_TIME_ATTRIBUTE_USAGES

Line 163: ,hxc_time_attribute_usages tau

159:
160: cursor c_app_periods(p_resource_id in hxc_time_building_blocks.resource_id%type) is
161: select distinct tbb.time_building_block_id
162: from hxc_time_building_blocks tbb
163: ,hxc_time_attribute_usages tau
164: ,hxc_time_attributes ta
165: where tbb.scope = 'APPLICATION_PERIOD' and
166: tbb.date_to = hr_general.end_of_time and
167: tbb.resource_id = p_resource_id and

Line 353: FROM hxc_time_attribute_usages

349: (SELECT DISTINCT attribute1
350: FROM hxc_time_attributes
351: WHERE time_attribute_id IN
352: (SELECT time_attribute_id
353: FROM hxc_time_attribute_usages
354: WHERE time_building_block_id IN
355: (SELECT htb2.time_building_block_id
356: FROM hxc_time_building_blocks htb2
357: WHERE htb2.scope = 'APPLICATION_PERIOD' AND

Line 383: FROM hxc_time_attribute_usages

379: (SELECT COUNT(distinct attribute1)
380: FROM hxc_time_attributes
381: WHERE time_attribute_id IN
382: (SELECT time_attribute_id
383: FROM hxc_time_attribute_usages
384: WHERE time_building_block_id IN
385: (SELECT htb2.time_building_block_id
386: FROM hxc_time_building_blocks htb2
387: WHERE htb2.scope = 'APPLICATION_PERIOD' AND

Line 410: FROM hxc_time_attribute_usages

406: (SELECT DISTINCT attribute1
407: FROM hxc_time_attributes
408: WHERE time_attribute_id IN
409: (SELECT time_attribute_id
410: FROM hxc_time_attribute_usages
411: WHERE time_building_block_id IN
412: (SELECT htb2.time_building_block_id
413: FROM hxc_time_building_blocks htb2
414: WHERE htb2.scope = 'APPLICATION_PERIOD' AND

Line 1022: ,hxc_time_attribute_usages tau

1018:
1019: cursor c_app_periods(p_start_date date, p_end_date date) is
1020: select distinct tbb.time_building_block_id
1021: from hxc_time_building_blocks tbb
1022: ,hxc_time_attribute_usages tau
1023: ,hxc_time_attributes ta
1024: where tbb.scope = 'APPLICATION_PERIOD' and
1025: tbb.date_to = hr_general.end_of_time and
1026: tau.time_building_block_id = tbb.time_building_block_id and

Line 1046: ,hxc_time_attribute_usages tau

1042:
1043: cursor c_app_periods_bg(p_start_date date, p_end_date date) is
1044: select distinct tbb.time_building_block_id
1045: from hxc_time_building_blocks tbb
1046: ,hxc_time_attribute_usages tau
1047: ,hxc_time_attributes ta
1048: where tbb.scope = 'APPLICATION_PERIOD' and
1049: tbb.date_to = hr_general.end_of_time and
1050: tau.time_building_block_id = tbb.time_building_block_id and