APPS.HXC_TIME_CATEGORY_UTILS_PKG dependencies on HXC_LATEST_DETAILS

Line 2383: hxc_latest_details tbb_latest,

2379: l_live_timecard VARCHAR2(875) := '
2380: SELECT DISTINCT detail.time_building_block_id bb_id
2381: from hxc_time_attributes ta,
2382: hxc_time_attribute_usages tau,
2383: hxc_latest_details tbb_latest,
2384: hxc_time_building_blocks detail,
2385: hxc_time_building_blocks day
2386: where day.parent_building_block_id = :p_tbb_id
2387: and day.parent_building_block_ovn = :p_tbb_ovn

Line 3174: , hxc_latest_details hld

3170: SELECT SUM( DECODE( tbb.type, ''RANGE'',
3171: (((tbb.stop_time)-(tbb.start_time))*24),
3172: NVL(tbb.measure, 0) )) hrs
3173: FROM hxc_time_building_blocks tbb
3174: , hxc_latest_details hld
3175: WHERE tbb.time_building_block_id = hld.time_building_block_id
3176: AND tbb.object_version_number = hld.object_version_number
3177: AND hld.time_building_block_id IN ( ';
3178:

Line 3273: , hxc_latest_details hld

3269: (((tbb.stop_time)-(tbb.start_time))*24),
3270: NVL(tbb.measure, 0) ))
3271: )) hrs
3272: FROM hxc_time_building_blocks tbb
3273: , hxc_latest_details hld
3274: WHERE tbb.time_building_block_id = hld.time_building_block_id
3275: AND tbb.object_version_number = hld.object_version_number
3276: AND hld.time_building_block_id IN ( ';
3277:

Line 3386: FROM hxc_latest_details tbb_latest,

3382:
3383: CURSOR csr_get_live_tbbs ( p_bb_id NUMBER, p_bb_ovn NUMBER ) IS
3384: SELECT detail.time_building_block_id bb_id,
3385: detail.scope
3386: FROM hxc_latest_details tbb_latest,
3387: hxc_time_building_blocks detail,
3388: hxc_time_building_blocks day
3389: where day.parent_building_block_id = p_bb_id
3390: and day.parent_building_block_ovn = p_bb_ovn

Line 4850: FROM hxc_latest_details tbb_latest,

4846: CURSOR csr_sum_all_timecard_hrs ( p_tbb_id NUMBER, p_tbb_ovn NUMBER ) IS
4847: SELECT SUM( DECODE( detail.type, 'RANGE',
4848: (((detail.stop_time)-(detail.start_time))*24),
4849: NVL(detail.measure, 0) )) hrs
4850: FROM hxc_latest_details tbb_latest,
4851: hxc_time_building_blocks detail,
4852: hxc_time_building_blocks day
4853: where day.parent_building_block_id = p_tbb_id
4854: and day.parent_building_block_ovn = p_tbb_ovn

Line 4943: FROM hxc_latest_details tbb_latest,

4939: CURSOR csr_timecard_hrs ( p_tbb_id NUMBER, p_tbb_ovn NUMBER ) IS
4940: SELECT DECODE( detail.type, 'RANGE',
4941: nvl((((detail.stop_time)-(detail.start_time))*24),0),
4942: NVL(detail.measure, 0) ) hrs
4943: FROM hxc_latest_details tbb_latest,
4944: hxc_time_building_blocks detail,
4945: hxc_time_building_blocks day
4946: where day.parent_building_block_id = p_tbb_id
4947: and day.parent_building_block_ovn = p_tbb_ovn