APPS.CS_SR_SYNC_INDEX_PKG SQL Statements

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

Line: 43

  SELECT COUNT(*) FROM dba_indexes
  WHERE index_name = UPPER(p_index_name)
  AND owner= UPPER(p_owner);

Line: 154

   select owner
   from   all_indexes
   where  index_name  = 'SUMMARY_CTX_INDEX'
   and    owner = p_owner
   and    index_type  = 'DOMAIN';

Line: 350

     SELECT to_number(nvl(VALUE, 0)) INTO  l_worker FROM v$parameter
     WHERE NAME = 'job_queue_processes';

Line: 433

   SELECT rowid
   FROM cs_incidents_all_tl;

Line: 450

        UPDATE cs_incidents_all_tl
        SET text_index = 'X'
        WHERE rowid = l_rowid_list(i);

Line: 639

       SELECT COUNT(*) FROM dba_indexes
       WHERE index_name = UPPER(p_index_name)
       AND owner= UPPER(p_owner);