APPS.HR_COPY_GSP SQL Statements

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

Line: 12

  select item_type_id,
         item_type_usage_id,
         sequence_number,
         name
  from   hr_summary_item_type_usage
  where  template_id = p_template_id
  order by sequence_number;

Line: 21

  select valid_key_type_id
  from   hr_summary_key_type_usage
  where  item_type_usage_id = p_itu_id;

Line: 26

  select ru.restriction_type,
         ru.restriction_usage_id,
         ru.valid_restriction_id
  from   hr_summary_restriction_usage ru
  where  ru.item_type_usage_id = p_itu_id;

Line: 33

  select value
  from   hr_summary_restriction_value
  where  restriction_usage_id = p_id;

Line: 115

  select item_type_id
  from   hr_summary_item_type_usage
  where  item_type_usage_id = p_itu_id;

Line: 120

  select nvl(max(sequence_number),0)+1
  from   hr_summary_item_type_usage
  where  template_id = p_template_id;

Line: 125

  select valid_key_type_id
  from   hr_summary_key_type_usage
  where  item_type_usage_id = p_itu_id;

Line: 130

  select ru.restriction_type,
         ru.restriction_usage_id,
         ru.valid_restriction_id
  from   hr_summary_restriction_usage ru
  where  ru.item_type_usage_id = p_itu_id;

Line: 137

  select value
  from   hr_summary_restriction_value
  where  restriction_usage_id = p_id;

Line: 217

  select name,
         title,
         units,
         datatype,
         count_clause1,
         count_clause2,
         where_clause
  from   hr_summary_item_type
  where  item_type_id = p_item_type_id;

Line: 228

  select restriction_type_id
  from   hr_summary_valid_restriction
  where  item_type_id = p_item_type_id;

Line: 233

  select key_type_id
  from   hr_summary_valid_key_type
  where  item_type_id = p_item_type_id;