APPS.HXC_TIME_CATEGORY_UTILS_PKG dependencies on HR_GENERAL

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

2170: END IF;
2171:
2172: -- only copy blocks which are NOT deleted
2173:
2174: IF ( FND_DATE.CANONICAL_TO_DATE(p_blocks(l_ind).date_to) = hr_general.end_of_time )
2175: THEN
2176:
2177: IF ( g_debug ) THEN
2178: hr_utility.trace('Scope : start time '||p_blocks(l_ind).scope||' : '||p_blocks(l_ind).start_time);

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

2258:
2259: END IF; -- t_scope(x) = 'DETAIL'
2260:
2261:
2262: END IF; -- IF ( FND_DATE.CANONICAL_TO_DATE(p_blocks(l_ind).date_to) = hr_general.end_of_time )
2263:
2264: l_ind := p_blocks.NEXT(l_ind);
2265:
2266: END LOOP;

Line 2371: and detail.date_to = hr_general.end_of_time

2367: and detail.parent_building_block_id =
2368: day.time_building_block_id
2369: and detail.parent_building_block_ovn =
2370: day.object_version_number
2371: and detail.date_to = hr_general.end_of_time
2372: and tbb_latest.time_building_block_id = detail.time_building_Block_id
2373: and tbb_latest.object_version_number = detail.object_version_number
2374: and tau.time_building_block_id = tbb_latest.time_building_block_id
2375: and tau.time_building_block_ovn = tbb_latest.object_Version_number

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

3276: and detail.parent_building_block_ovn =
3277: day.object_version_number
3278: and tbb_latest.time_building_block_id = detail.time_building_Block_id
3279: and tbb_latest.object_version_number = detail.object_version_number
3280: and detail.date_to = hr_general.end_of_time;
3281:
3282:
3283: -- local variable defintions
3284:

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

4740: and detail.parent_building_block_ovn =
4741: day.object_version_number
4742: and tbb_latest.time_building_block_id = detail.time_building_Block_id
4743: and tbb_latest.object_version_number = detail.object_version_number
4744: and detail.date_to = hr_general.end_of_time;
4745:
4746:
4747: l_timecard_hrs NUMBER := 0;
4748: l_time_category_id hxc_time_categories.time_category_id%TYPE;

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

4833: and detail.parent_building_block_ovn =
4834: day.object_version_number
4835: and tbb_latest.time_building_block_id = detail.time_building_Block_id
4836: and tbb_latest.object_version_number = detail.object_version_number
4837: and detail.date_to = hr_general.end_of_time;
4838:
4839: CURSOR c_tc_resource_id(
4840: p_tc_bbid hxc_time_building_blocks.time_building_block_id%TYPE,
4841: p_tbb_ovn hxc_time_building_blocks.object_version_number%TYPE