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_UPGRADE_PKG dependencies on HXC_TIME_BUILDING_BLOCKS

Line 101: FROM hxc_time_building_blocks_ar ar,

97: -- Bug 9790410
98: -- Added to pick up the summary id from HXT table.
99: CURSOR get_tim_id
100: IS SELECT DISTINCT sum.id
101: FROM hxc_time_building_blocks_ar ar,
102: hxt_sum_hours_worked_f sum
103: WHERE ar.time_building_block_id = sum.time_building_block_id
104: AND ar.object_version_number = sum.time_building_block_ovn
105: AND ar.scope = 'DETAIL';

Line 869: hxc_time_building_blocks det,

865: hld.resource_type,
866: hld.comment_text,
867: tc.time_building_block_id
868: FROM hxc_latest_details hld,
869: hxc_time_building_blocks det,
870: hxc_time_building_blocks day,
871: hxc_time_building_blocks tc
872: WHERE hld.time_building_block_id BETWEEN p_start
873: AND p_end

Line 870: hxc_time_building_blocks day,

866: hld.comment_text,
867: tc.time_building_block_id
868: FROM hxc_latest_details hld,
869: hxc_time_building_blocks det,
870: hxc_time_building_blocks day,
871: hxc_time_building_blocks tc
872: WHERE hld.time_building_block_id BETWEEN p_start
873: AND p_end
874: AND hld.time_building_block_id = det.time_building_block_id

Line 871: hxc_time_building_blocks tc

867: tc.time_building_block_id
868: FROM hxc_latest_details hld,
869: hxc_time_building_blocks det,
870: hxc_time_building_blocks day,
871: hxc_time_building_blocks tc
872: WHERE hld.time_building_block_id BETWEEN p_start
873: AND p_end
874: AND hld.time_building_block_id = det.time_building_block_id
875: AND hld.object_version_number = det.object_version_number

Line 921: hxc_time_building_blocks det,

917: hld.resource_type,
918: hld.comment_text,
919: tc.time_building_block_id
920: FROM hxc_latest_details hld,
921: hxc_time_building_blocks det,
922: hxc_time_building_blocks day,
923: hxc_time_building_blocks tc
924: WHERE hld.time_building_block_id BETWEEN p_start
925: AND p_end

Line 922: hxc_time_building_blocks day,

918: hld.comment_text,
919: tc.time_building_block_id
920: FROM hxc_latest_details hld,
921: hxc_time_building_blocks det,
922: hxc_time_building_blocks day,
923: hxc_time_building_blocks tc
924: WHERE hld.time_building_block_id BETWEEN p_start
925: AND p_end
926: AND hld.time_building_block_id = det.time_building_block_id

Line 923: hxc_time_building_blocks tc

919: tc.time_building_block_id
920: FROM hxc_latest_details hld,
921: hxc_time_building_blocks det,
922: hxc_time_building_blocks day,
923: hxc_time_building_blocks tc
924: WHERE hld.time_building_block_id BETWEEN p_start
925: AND p_end
926: AND hld.time_building_block_id = det.time_building_block_id
927: AND hld.object_version_number = det.object_version_number

Line 959: hxc_time_building_blocks_ar ar

955: IS SELECT DISTINCT sum.id,
956: sum.tim_id,
957: ar.data_set_id
958: FROM hxt_sum_hours_worked_f sum,
959: hxc_time_building_blocks_ar ar
960: WHERE sum.id BETWEEN p_start
961: AND p_end
962: AND sum.time_building_block_id = ar.time_building_block_id
963: AND sum.time_building_block_ovn = ar.object_version_number ;

Line 1003: hxc_time_building_blocks day,

999: DECODE(hrp.NAME, 'HR Retrieval Process', p_bee_id,
1000: hrp.retrieval_process_id),
1001: DECODE(detail.date_to, hr_general.end_of_time,NULL,'D')
1002: FROM hxc_upg_master_temp temp,
1003: hxc_time_building_blocks day,
1004: hxc_time_building_blocks detail,
1005: hxc_latest_details hld,
1006: hxc_application_set_comps_v hasc,
1007: hxc_retrieval_processes hrp

Line 1004: hxc_time_building_blocks detail,

1000: hrp.retrieval_process_id),
1001: DECODE(detail.date_to, hr_general.end_of_time,NULL,'D')
1002: FROM hxc_upg_master_temp temp,
1003: hxc_time_building_blocks day,
1004: hxc_time_building_blocks detail,
1005: hxc_latest_details hld,
1006: hxc_application_set_comps_v hasc,
1007: hxc_retrieval_processes hrp
1008: WHERE temp.master_id = day.parent_building_block_id