APPS.HXC_TIME_CATEGORY_UTILS_PKG dependencies on HXC_LATEST_DETAILS

Line 2362: hxc_latest_details tbb_latest,

2358: l_live_timecard VARCHAR2(875) := '
2359: SELECT DISTINCT detail.time_building_block_id bb_id
2360: from hxc_time_attributes ta,
2361: hxc_time_attribute_usages tau,
2362: hxc_latest_details tbb_latest,
2363: hxc_time_building_blocks detail,
2364: hxc_time_building_blocks day
2365: where day.parent_building_block_id = :p_tbb_id
2366: and day.parent_building_block_ovn = :p_tbb_ovn

Line 3057: , hxc_latest_details hld

3053: SELECT SUM( DECODE( tbb.type, ''RANGE'',
3054: (((tbb.stop_time)-(tbb.start_time))*24),
3055: NVL(tbb.measure, 0) )) hrs
3056: FROM hxc_time_building_blocks tbb
3057: , hxc_latest_details hld
3058: WHERE tbb.time_building_block_id = hld.time_building_block_id
3059: AND tbb.object_version_number = hld.object_version_number
3060: AND hld.time_building_block_id IN ( ';
3061:

Line 3156: , hxc_latest_details hld

3152: (((tbb.stop_time)-(tbb.start_time))*24),
3153: NVL(tbb.measure, 0) ))
3154: )) hrs
3155: FROM hxc_time_building_blocks tbb
3156: , hxc_latest_details hld
3157: WHERE tbb.time_building_block_id = hld.time_building_block_id
3158: AND tbb.object_version_number = hld.object_version_number
3159: AND hld.time_building_block_id IN ( ';
3160:

Line 3269: FROM hxc_latest_details tbb_latest,

3265:
3266: CURSOR csr_get_live_tbbs ( p_bb_id NUMBER, p_bb_ovn NUMBER ) IS
3267: SELECT detail.time_building_block_id bb_id,
3268: detail.scope
3269: FROM hxc_latest_details tbb_latest,
3270: hxc_time_building_blocks detail,
3271: hxc_time_building_blocks day
3272: where day.parent_building_block_id = p_bb_id
3273: and day.parent_building_block_ovn = p_bb_ovn

Line 4733: FROM hxc_latest_details tbb_latest,

4729: CURSOR csr_sum_all_timecard_hrs ( p_tbb_id NUMBER, p_tbb_ovn NUMBER ) IS
4730: SELECT SUM( DECODE( detail.type, 'RANGE',
4731: (((detail.stop_time)-(detail.start_time))*24),
4732: NVL(detail.measure, 0) )) hrs
4733: FROM hxc_latest_details tbb_latest,
4734: hxc_time_building_blocks detail,
4735: hxc_time_building_blocks day
4736: where day.parent_building_block_id = p_tbb_id
4737: and day.parent_building_block_ovn = p_tbb_ovn

Line 4826: FROM hxc_latest_details tbb_latest,

4822: CURSOR csr_timecard_hrs ( p_tbb_id NUMBER, p_tbb_ovn NUMBER ) IS
4823: SELECT DECODE( detail.type, 'RANGE',
4824: nvl((((detail.stop_time)-(detail.start_time))*24),0),
4825: NVL(detail.measure, 0) ) hrs
4826: FROM hxc_latest_details tbb_latest,
4827: hxc_time_building_blocks detail,
4828: hxc_time_building_blocks day
4829: where day.parent_building_block_id = p_tbb_id
4830: and day.parent_building_block_ovn = p_tbb_ovn