APPS.PER_RSC_SHD SQL Statements

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

Line: 60

    select
      rating_scale_id,
      business_group_id,
      name,
      type,
      object_version_number,
      description,
      max_scale_step,
      min_scale_step,
      default_flag,
      attribute_category,
      attribute1,
      attribute2,
      attribute3,
      attribute4,
      attribute5,
      attribute6,
      attribute7,
      attribute8,
      attribute9,
      attribute10,
      attribute11,
      attribute12,
      attribute13,
      attribute14,
      attribute15,
      attribute16,
      attribute17,
      attribute18,
      attribute19,
      attribute20
    from	per_rating_scales
    where	rating_scale_id = p_rating_scale_id;

Line: 160

    select 	rating_scale_id,
	business_group_id,
	name,
	type,
	object_version_number,
	description,
	max_scale_step,
	min_scale_step,
        default_flag,
        attribute_category,
        attribute1,
        attribute2,
        attribute3,
        attribute4,
        attribute5,
        attribute6,
        attribute7,
        attribute8,
        attribute9,
        attribute10,
        attribute11,
        attribute12,
        attribute13,
        attribute14,
        attribute15,
        attribute16,
        attribute17,
        attribute18,
        attribute19,
        attribute20
    from	per_rating_scales
    where	rating_scale_id = p_rating_scale_id
    for	update nowait;