DBA Data[Home] [Help]

APPS.CSI_MIG_SLABS_PKG SQL Statements

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

Line: 38

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

  delete from cs_upg_slabs
  where  source_table = p_table_name
  and    module       = p_module;
Line: 92

       INSERT INTO CS_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: 126

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

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