SELECT
  CoPayment.coPaymentID,
  CoPayment.caseID,
  CoPayment.maxCoPayLimit,
  CoPayment.effectiveFromDate,
  CoPayment.effectiveToDate,
  CoPayment.coPayLimitReached,
  CoPayment.status,
  CoPayment.versionNo
INTO
  :coPaymentID,
  :caseID,
  :maxCoPayLimit,
  :effectiveFromDate,
  :effectiveToDate,
  :coPayLimitReached,
  :status,
  :versionNo 
FROM
  CoPayment 
WHERE CoPayment.caseID = :caseID