APPS.HXC_DEPOSIT_PROCESS_PKG SQL Statements

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

Line: 123

	  -- if there are any attributes to insert

	IF ( p_timecard.count <> 0 )
	THEN

      hxc_time_attributes_api.create_attributes
        (p_timecard               => p_timecard
        ,p_process_id             => l_process_id
        ,p_time_building_block_id => nvl(l_time_building_block_id_o
        				    ,l_time_building_block_id)
        ,p_tbb_ovn                => l_object_version_number --l_tbb_ovn
        ,p_time_attribute_id      => l_time_attribute_id
        ,p_object_version_number  => l_tat_ovn
        );

Line: 234

SELECT	ts.time_source_id
FROM	hxc_time_sources ts
WHERE 	name = p_source_name;

Line: 241

  select deposit_process_id
  from hxc_deposit_processes
  where time_source_id	= l_time_source_id
  and   name 		= p_process_name;

Line: 282

 select null
 from  hxc_time_building_blocks tbb
 where tbb.time_building_block_id = p_time_building_block_id
 and tbb.object_version_number = p_object_version_number
 and tbb.date_to = hr_general.end_of_time;

Line: 288

 select null
 from  hxc_time_building_blocks tbb
 where tbb.time_building_block_id = p_time_building_block_id
 and p_object_version_number = (select max(object_version_number) from hxc_time_building_blocks where time_building_block_id = tbb.time_building_block_id)
 and tbb.date_to = to_date('31/12/4712','DD/MM/YYYY');

Line: 295

  select null
  from  hxc_time_building_blocks tbb
  where tbb.time_building_block_id        = p_time_building_block_id
  and  ((select max(object_version_number)
         from hxc_time_building_blocks
         where time_building_block_id = tbb.time_building_block_id)
                                          = p_object_version_number)
  and   tbb.date_to                       = to_date('31/12/4712','DD/MM/YYYY');