APPS.HXT_OTC_RETRIEVAL_INTERFACE dependencies on HXC_TIME_BUILDING_BLOCKS

Line 429: FROM hxc_time_building_blocks

425: CURSOR get_times(p_id IN NUMBER,
426: p_ovn IN NUMBER)
427: IS SELECT start_time,
428: stop_time
429: FROM hxc_time_building_blocks
430: WHERE time_building_block_id = p_id
431: AND object_version_number = p_ovn;
432:
433: FUNCTION timecard_id (

Line 880: l_bld_blk_id hxc_time_building_blocks.time_building_block_id%TYPE;

876: p_element_type_id OUT NOCOPY NUMBER
877: )
878: IS
879: l_att_index BINARY_INTEGER;
880: l_bld_blk_id hxc_time_building_blocks.time_building_block_id%TYPE;
881: l_bb_id_changed BOOLEAN := FALSE;
882: BEGIN
883: --
884: -- Get the attributes of the detail record - element name, input values