APPS.HXC_TIMECARD dependencies on HR_GENERAL

Line 596: if(hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).date_to) = hr_general.end_of_time) then

592: */
593:
594: l_timecard_index := hxc_timecard_block_utils.find_active_timecard_index(p_blocks);
595:
596: if(hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).date_to) = hr_general.end_of_time) then
597: l_resubmit := hxc_timecard_approval.is_timecard_resubmitted
598: (p_blocks(l_timecard_index).time_building_block_id
599: ,p_blocks(l_timecard_index).object_version_number
600: ,p_blocks(l_timecard_index).resource_id

Line 1680: where tbb.date_to = hr_general.end_of_time

1676: ) is
1677: select tbb.time_building_block_id
1678: ,tbb.object_version_number
1679: from hxc_time_building_blocks tbb
1680: where tbb.date_to = hr_general.end_of_time
1681: start with (tbb.time_building_block_id = p_tc_id)
1682: connect by prior tbb.time_building_block_id = tbb.parent_building_block_id
1683: and prior tbb.object_version_number = tbb.parent_building_block_ovn;
1684:

Line 1841: and tbb.date_to = hr_general.end_of_time;

1837: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type) is
1838: select tbb.object_version_number, tbb.resource_id, tbb.start_time, tbb.stop_time
1839: from hxc_time_building_blocks tbb
1840: where tbb.time_building_block_id = p_timecard_id
1841: and tbb.date_to = hr_general.end_of_time;
1842:
1843:
1844: -- Bug 13416941
1845: --