APPS.HXC_TIMECARD dependencies on HR_GENERAL

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

323: */
324:
325: l_timecard_index := hxc_timecard_block_utils.find_active_timecard_index(p_blocks);
326:
327: if(hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).date_to) = hr_general.end_of_time) then
328: l_resubmit := hxc_timecard_approval.is_timecard_resubmitted
329: (p_blocks(l_timecard_index).time_building_block_id
330: ,p_blocks(l_timecard_index).object_version_number
331: ,p_blocks(l_timecard_index).resource_id

Line 1096: where tbb.date_to = hr_general.end_of_time

1092: ) is
1093: select tbb.time_building_block_id
1094: ,tbb.object_version_number
1095: from hxc_time_building_blocks tbb
1096: where tbb.date_to = hr_general.end_of_time
1097: start with (tbb.time_building_block_id = p_tc_id)
1098: connect by prior tbb.time_building_block_id = tbb.parent_building_block_id
1099: and prior tbb.object_version_number = tbb.parent_building_block_ovn;
1100:

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

1253: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type) is
1254: select tbb.object_version_number, tbb.resource_id, tbb.start_time, tbb.stop_time
1255: from hxc_time_building_blocks tbb
1256: where tbb.time_building_block_id = p_timecard_id
1257: and tbb.date_to = hr_general.end_of_time;
1258:
1259: l_blocks hxc_block_table_type := hxc_block_table_type();
1260: l_attributes hxc_attribute_table_type := hxc_attribute_table_type();
1261: l_messages hxc_message_table_type := hxc_message_table_type();