APPS.HXC_UPGRADE_PKG dependencies on HXC_TIME_BUILDING_BLOCKS_AR

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 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 ;