DBA Data[Home] [Help]

APPS.CSD_MIG_SLABS_PKG SQL Statements

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

Line: 42

   select slab_start, slab_end
   FROM   csd_upg_slabs
   where  slab_number  = p_slab_number
   and    source_table = p_table_name
   and    module       = p_module;
Line: 78

  delete from csd_upg_slabs
  where  source_table = p_table_name
  and    module       = p_module;
Line: 103

       INSERT INTO CSD_UPG_SLABS
      	(SOURCE_TABLE,
           MODULE,
           SLAB_NUMBER,
           SLAB_START,
           SLAB_END,
           CREATED_BY,
  	      CREATED_ON)
        VALUES (p_table_name,
           p_module,
           l_slab_num,
           l_last_slab + 1,
           l_max_slab,
           fnd_global.user_id,
           sysdate);
Line: 138

  l_min_str := 'select min('||p_pk_column||') from '||p_table_name;
Line: 139

  l_max_str := 'select max('||p_pk_column||') from '||p_table_name;