DBA Data[Home] [Help]

APPS.HXC_TIMECARD_DEPOSIT_COMMON dependencies on HR_GENERAL

Line 117: where tbb.date_to = hr_general.end_of_time

113: ) is
114: select tbb.time_building_block_id
115: ,tbb.object_version_number
116: from hxc_time_building_blocks tbb
117: where tbb.date_to = hr_general.end_of_time
118: start with (tbb.time_building_block_id = p_tc_id)
119: connect by prior tbb.time_building_block_id = tbb.parent_building_block_id
120: and prior tbb.object_version_number = tbb.parent_building_block_ovn;
121:

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

201: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type) is
202: select tbb.object_version_number
203: from hxc_time_building_blocks tbb
204: where tbb.time_building_block_id = p_timecard_id
205: and tbb.date_to = hr_general.end_of_time;
206:
207: l_blocks hxc_block_table_type := hxc_block_table_type();
208: l_attributes hxc_attribute_table_type := hxc_attribute_table_type();
209: l_messages hxc_message_table_type := hxc_message_table_type();