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_ATTRIBUTES

Line 164: ,hxc_time_attributes ta

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
168: tau.time_building_block_id = tbb.time_building_block_id and

Line 350: FROM hxc_time_attributes

346: ,COUNT(*) cnt
347: FROM hxc_application_set_comps_v
348: WHERE time_recipient_id IN
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

Line 380: FROM hxc_time_attributes

376: attribute_category = 'APPROVAL')
377: GROUP BY application_set_id)
378: WHERE cnt =
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

Line 407: FROM hxc_time_attributes

403: (SELECT application_set_id a
404: FROM hxc_application_set_comps_v
405: WHERE time_recipient_id NOT IN
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

Line 1023: ,hxc_time_attributes ta

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
1027: tau.time_building_block_ovn = tbb.object_version_number and

Line 1047: ,hxc_time_attributes ta

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
1051: tau.time_building_block_ovn = tbb.object_version_number and