APPS.HR_INDEX_CHECK SQL Statements

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

Line: 42

  select table_name,
         index_name
    from all_indexes
   where table_name like 'BEN_%'
      and index_name not like 'SYS_%'
      and ((owner = c_per_owner) or
           (owner = c_ben_owner))
    order by table_name, index_name;

Line: 52

  select table_name,
         index_name
    from all_indexes
   where ((table_name like 'PER_%')  or
          ((table_name like 'HR_%') and
           (table_name not like 'HRI_%')))
      and index_name not like 'SYS_%'
      and owner = c_per_owner
    order by table_name, index_name;

Line: 63

  select table_name,
         index_name
    from all_indexes
   where ((table_name like 'HR_EDW%') or
          (table_name like 'HRI_%'))
      and index_name not like 'SYS_%'
      and owner = c_owner
    order by table_name, index_name;

Line: 74

  select table_name,
	 index_name
    from all_indexes
   where table_name like c_prod
     and index_name not like 'SYS_%'
     and owner = c_owner
   order by table_name, index_name;

Line: 83

  select application_id, application_short_name
    from fnd_application
   order by application_short_name;

Line: 181

PROCEDURE insert_line(p_line IN varchar2) IS
BEGIN
  insert into hr_api_user_hook_reports
    (session_id,
     line,
     text)
   values
    (userenv('SESSIONID'),
     g_number,
     p_line);

Line: 193

END insert_line;

Line: 203

PROCEDURE insert_legend IS
  l_line varchar2(80);

Line: 207

  insert_line(l_line);

Line: 209

  insert_line(l_line);

Line: 211

  insert_line(l_line);

Line: 213

  insert_line(l_line);

Line: 215

  insert_line(l_line);

Line: 217

  insert_line(l_line);

Line: 218

  l_line := '*          may have been inserted by the customer, or created by the        * ';

Line: 219

  insert_line(l_line);

Line: 221

  insert_line(l_line);

Line: 223

  insert_line(l_line);

Line: 225

  insert_line(l_line);

Line: 227

  insert_line(l_line);

Line: 229

  insert_line(l_line);

Line: 231

  insert_line(l_line);

Line: 233

  insert_line(l_line);

Line: 235

  insert_line(l_line);

Line: 237

  insert_line(l_line);

Line: 239

  insert_line(l_line);

Line: 241

  insert_line(l_line);

Line: 243

  insert_line(l_line);

Line: 244

END insert_legend;

Line: 275

     insert_legend;

Line: 280

     insert into hr_api_user_hook_reports
      (session_id,
       line,
       text)
     values
      (userenv('SESSIONID'),
       g_number,
       l_text);

Line: 292

     insert into hr_api_user_hook_reports
      (session_id,
       line,
       text)
     values
      (userenv('SESSIONID'),
       g_number,
       l_text);

Line: 304

     insert into hr_api_user_hook_reports
      (session_id,
       line,
       text)
     values
      (userenv('SESSIONID'),
       g_number,
       l_text);

Line: 313

     insert into hr_api_user_hook_reports
      (session_id,
       line,
       text)
     values
      (userenv('SESSIONID'),
       g_number,
       '    ');

Line: 333

    insert into hr_api_user_hook_reports
      (session_id,
       line,
       text)
    values
      (userenv('SESSIONID'),
       g_number,
       l_text);

Line: 476

  insert into hr_api_user_hook_reports
    (session_id,
     line,
     text)
  values
    (userenv('SESSIONID'),
     g_number,
     l_line);

Line: 489

  insert into hr_api_user_hook_reports
    (session_id,
     line,
     text)
  values
    (userenv('SESSIONID'),
     g_number,
     l_line);

Line: 515

   select table_name,
          index_name
     from all_indexes
    where table_name like 'BEN_%'
      and index_name not like 'SYS_%'
      and index_name like '%FK%'
      and ((owner = c_per_owner) or
           (owner = c_ben_owner))
    order by table_name, index_name;

Line: 526

   select table_name,
          index_name
     from all_indexes
    where ((table_name like 'PER_%')  or
           ((table_name like 'HR_%') and
            (table_name not like 'HRI_%')))
      and index_name not like 'SYS_%'
      and index_name like '%FK%'
      and owner = c_per_owner
    order by table_name, index_name;

Line: 538

   select table_name,
          index_name
     from all_indexes
    where ((table_name like 'HRI_%') or
           (table_name like 'HRI_EDW%'))
      and index_name not like 'SYS_%'
      and index_name like '%FK%'
      and owner = c_owner
    order by table_name, index_name;

Line: 550

   select table_name,
          index_name
     from all_indexes
    where table_name like c_prod
      and index_name not like 'SYS_%'
      and index_name like '%FK%'
      and owner = c_owner
    order by table_name, index_name;

Line: 560

  select application_id, application_short_name
    from fnd_application
   order by application_short_name;