DBA Data[Home] [Help]

APPS.HXC_TBB_BUS dependencies on HXC_TIME_BUILDING_BLOCKS

Line 286: from hxc_time_building_blocks

282: l_proc varchar2(72);
283:
284: cursor c_timecard_parent is
285: select null
286: from hxc_time_building_blocks
287: where time_building_block_id = p_parent_building_block_id
288: and object_version_number = p_parent_building_block_ovn;
289:
290: cursor c_valid_parent is

Line 292: from hxc_time_building_blocks

288: and object_version_number = p_parent_building_block_ovn;
289:
290: cursor c_valid_parent is
291: select null
292: from hxc_time_building_blocks
293: where time_building_block_id = p_parent_building_block_id
294: and object_version_number = p_parent_building_block_ovn
295: and date_to = hr_general.end_of_time;
296:

Line 400: from hxc_time_building_blocks

396: ) is
397:
398: cursor c_timecard_scope is
399: select 'Y'
400: from hxc_time_building_blocks
401: where resource_id = p_resource_id
402: and scope = 'TIMECARD'
403: and resource_type = p_resource_type
404: and p_start_time <= stop_time