35: where days.parent_building_block_id = p_id
36: and days.parent_building_block_ovn = p_ovn
37: and details.parent_building_block_id = days.time_building_block_id
38: and details.parent_building_block_ovn = days.object_version_number
39: and days.date_to = hr_general.end_of_time
40: and details.date_to = hr_general.end_of_time;
41:
42: CURSOR c_tc_resource_id(
43: p_timecard_id hxc_time_building_blocks.time_building_block_id%TYPE,
36: and days.parent_building_block_ovn = p_ovn
37: and details.parent_building_block_id = days.time_building_block_id
38: and details.parent_building_block_ovn = days.object_version_number
39: and days.date_to = hr_general.end_of_time
40: and details.date_to = hr_general.end_of_time;
41:
42: CURSOR c_tc_resource_id(
43: p_timecard_id hxc_time_building_blocks.time_building_block_id%TYPE,
44: p_timecard_ovn hxc_time_building_blocks.object_version_number%TYPE
256: ,creation_date
257: ,data_set_id
258: from hxc_time_building_blocks
259: where time_building_block_id = p_id
260: and date_to = hr_general.end_of_time
261: and scope = 'TIMECARD';
262:
263: cursor c_check_for_reasons is
264: select 'Y'