APPS.PER_BBA_SHD SQL Statements

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

Line: 64

    select
      balance_amount_id,
      balance_type_id,
      processed_assignment_id,
      business_group_id,
      ytd_amount,
      fytd_amount,
      ptd_amount,
      mtd_amount,
      qtd_amount,
      run_amount,
      object_version_number,
      bba_attribute_category,
      bba_attribute1,
      bba_attribute2,
      bba_attribute3,
      bba_attribute4,
      bba_attribute5,
      bba_attribute6,
      bba_attribute7,
      bba_attribute8,
      bba_attribute9,
      bba_attribute10,
      bba_attribute11,
      bba_attribute12,
      bba_attribute13,
      bba_attribute14,
      bba_attribute15,
      bba_attribute16,
      bba_attribute17,
      bba_attribute18,
      bba_attribute19,
      bba_attribute20,
      bba_attribute21,
      bba_attribute22,
      bba_attribute23,
      bba_attribute24,
      bba_attribute25,
      bba_attribute26,
      bba_attribute27,
      bba_attribute28,
      bba_attribute29,
      bba_attribute30
    from	per_bf_balance_amounts
    where	balance_amount_id = p_balance_amount_id;

Line: 176

    select       balance_amount_id,
      balance_type_id,
      processed_assignment_id,
      business_group_id,
      ytd_amount,
      fytd_amount,
      ptd_amount,
      mtd_amount,
      qtd_amount,
      run_amount,
      object_version_number,
      bba_attribute_category,
      bba_attribute1,
      bba_attribute2,
      bba_attribute3,
      bba_attribute4,
      bba_attribute5,
      bba_attribute6,
      bba_attribute7,
      bba_attribute8,
      bba_attribute9,
      bba_attribute10,
      bba_attribute11,
      bba_attribute12,
      bba_attribute13,
      bba_attribute14,
      bba_attribute15,
      bba_attribute16,
      bba_attribute17,
      bba_attribute18,
      bba_attribute19,
      bba_attribute20,
      bba_attribute21,
      bba_attribute22,
      bba_attribute23,
      bba_attribute24,
      bba_attribute25,
      bba_attribute26,
      bba_attribute27,
      bba_attribute28,
      bba_attribute29,
      bba_attribute30
    from	per_bf_balance_amounts
    where	balance_amount_id = p_balance_amount_id
    for	update nowait;