APPS.HXC_TIMECARD_BLOCK_UTILS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 240

  select 'Y'
    from hxc_time_building_blocks tbb
   where tbb.time_building_block_id = p_block_id
     and tbb.object_version_number = p_block_ovn;

Line: 310

Function is_updated_block
          (p_block in HXC_BLOCK_TYPE)
          return BOOLEAN is

l_prev_block hxc_block_type;

Line: 341

End is_updated_block;

Line: 422

select *
  from hxc_time_building_blocks
 where time_building_block_id = p_time_building_block_id
   and object_version_number = p_time_building_block_ovn;