APPS.HR_CONSTRAINT_CHECK SQL Statements

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

Line: 42

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

Line: 52

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

Line: 63

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

Line: 74

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

Line: 83

  select application_id, application_short_name
    from fnd_application
   order by application_short_name;

Line: 211

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

Line: 223

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

Line: 235

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

Line: 244

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

Line: 262

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