[Home] [Help]
74: where htau.time_building_block_id= :p_det_bb_id
75: and htau.time_building_block_ovn = :p_det_bb_ovn
76: and tbb.time_building_block_id = htau.time_building_block_id
77: and tbb.object_version_number = htau.time_building_block_ovn
78: and tbb.date_to = hr_general.end_of_time
79: and htau.time_attribute_id = hta.time_attribute_id
80: and hta.attribute_category = :p_context';
81: else
82: l_query := l_query ||
84: where htau.time_building_block_id= :p_det_bb_id
85: and htau.time_building_block_ovn = :p_det_bb_ovn
86: and tbb.time_building_block_id = htau.time_building_block_id
87: and tbb.object_version_number = htau.time_building_block_ovn
88: and tbb.date_to = hr_general.end_of_time
89: and htau.time_attribute_id = hta.time_attribute_id
90: and hta.bld_blk_info_type_id = bbit.bld_blk_info_type_id
91: and bbit.bld_blk_info_type = :p_context';
92: end if;
187: where time_building_block_id = :p_det_bb_id
188: and object_version_number = :p_det_bb_ovn';
189:
190: if(p_get_type=c_new_get_type) then
191: l_query := l_query || fnd_global.local_chr('10') ||'and date_to = hr_general.end_of_time';
192: end if;
193:
194: OPEN tbb_cr FOR l_query USING p_det_bb_id,p_det_bb_ovn;
195: FETCH tbb_cr INTO l_value;
239: ,tbb1.translation_display_key
240: from hxc_time_building_blocks tbb1
241: where tbb1.TIME_BUILDING_BLOCK_ID = p_bb_id
242: and tbb1.OBJECT_VERSION_NUMBER = p_bb_ovn
243: and decode(p_get_type,'NEW',hr_general.end_of_time,tbb1.date_to) = tbb1.date_to;
244:
245: l_block hxc_self_service_time_deposit.building_block_info;
246: l_block_index NUMBER;
247:
610: cursor get_old_det_ovn(p_det_bb_id NUMBER,p_last_creation_date DATE) is
611: select NVL(max(object_version_number),-1)
612: from hxc_time_building_blocks htbb
613: where htbb.creation_date <= (p_last_creation_date+0.000011574)
614: and date_to <> hr_general.end_of_time
615: and htbb.time_building_block_id = p_det_bb_id
616: and htbb.approval_status = hxc_timecard.c_submitted_status;
617:
618: BEGIN