APPS.HXC_TIME_CATEGORY_UTILS_PKG dependencies on HR_GENERAL

Line 2195: IF ( FND_DATE.CANONICAL_TO_DATE(p_blocks(l_ind).date_to) = hr_general.end_of_time )

2191: END IF;
2192:
2193: -- only copy blocks which are NOT deleted
2194:
2195: IF ( FND_DATE.CANONICAL_TO_DATE(p_blocks(l_ind).date_to) = hr_general.end_of_time )
2196: THEN
2197:
2198: IF ( g_debug ) THEN
2199: hr_utility.trace('Scope : start time '||p_blocks(l_ind).scope||' : '||p_blocks(l_ind).start_time);

Line 2283: END IF; -- IF ( FND_DATE.CANONICAL_TO_DATE(p_blocks(l_ind).date_to) = hr_general.end_of_time )

2279:
2280: END IF; -- t_scope(x) = 'DETAIL'
2281:
2282:
2283: END IF; -- IF ( FND_DATE.CANONICAL_TO_DATE(p_blocks(l_ind).date_to) = hr_general.end_of_time )
2284:
2285: l_ind := p_blocks.NEXT(l_ind);
2286:
2287: END LOOP;

Line 2392: and detail.date_to = hr_general.end_of_time

2388: and detail.parent_building_block_id =
2389: day.time_building_block_id
2390: and detail.parent_building_block_ovn =
2391: day.object_version_number
2392: and detail.date_to = hr_general.end_of_time
2393: and tbb_latest.time_building_block_id = detail.time_building_Block_id
2394: and tbb_latest.object_version_number = detail.object_version_number
2395: and tau.time_building_block_id = tbb_latest.time_building_block_id
2396: and tau.time_building_block_ovn = tbb_latest.object_Version_number

Line 3397: and detail.date_to = hr_general.end_of_time;

3393: and detail.parent_building_block_ovn =
3394: day.object_version_number
3395: and tbb_latest.time_building_block_id = detail.time_building_Block_id
3396: and tbb_latest.object_version_number = detail.object_version_number
3397: and detail.date_to = hr_general.end_of_time;
3398:
3399:
3400: -- local variable defintions
3401:

Line 4861: and detail.date_to = hr_general.end_of_time;

4857: and detail.parent_building_block_ovn =
4858: day.object_version_number
4859: and tbb_latest.time_building_block_id = detail.time_building_Block_id
4860: and tbb_latest.object_version_number = detail.object_version_number
4861: and detail.date_to = hr_general.end_of_time;
4862:
4863:
4864: l_timecard_hrs NUMBER := 0;
4865: l_time_category_id hxc_time_categories.time_category_id%TYPE;

Line 4954: and detail.date_to = hr_general.end_of_time;

4950: and detail.parent_building_block_ovn =
4951: day.object_version_number
4952: and tbb_latest.time_building_block_id = detail.time_building_Block_id
4953: and tbb_latest.object_version_number = detail.object_version_number
4954: and detail.date_to = hr_general.end_of_time;
4955:
4956: CURSOR c_tc_resource_id(
4957: p_tc_bbid hxc_time_building_blocks.time_building_block_id%TYPE,
4958: p_tbb_ovn hxc_time_building_blocks.object_version_number%TYPE