APPS.ICX_CAT_INTERMEDIA_INDEX_PVT SQL Statements

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

Line: 9

  SELECT language_code,
         nls_language,
         installed_flag
  FROM   fnd_languages
  WHERE  installed_flag IN ('B', 'I');

Line: 338

      SELECT MIN(TO_NUMBER(value))
      INTO l_parallel
      FROM v$parameter
      WHERE name IN ('parallel_max_servers', 'cpu_count');

Line: 345

      SELECT ROUND(LEAST((LEAST(2147483648 , TO_NUMBER(sys_params.value)/3) / l_parallel), ctx_params.par_value) / 1048576)
      INTO  l_mem
      FROM v$parameter sys_params, ctx_parameters ctx_params
      WHERE sys_params.name IN ('pga_aggregate_target')
      AND ctx_params.par_name = 'MAX_INDEX_MEMORY';