SELECT
  reservationID,
  placementID,
  placeID,
  providerOfferingID,
  caseParticipantRoleID,
  unitAmount,
  unitAmountFixedIndicator,
  fromDate,
  toDate,
  dateOfExpiry,
  comments,
  status,
  versionNo
INTO
  :reservationID,
  :placementID,
  :placeID,
  :providerOfferingID,
  :caseParticipantRoleID,
  :unitAmount,
  :unitAmountFixedIndicator,
  :fromDate,
  :toDate,
  :dateOfExpiry,
  :comments,
  :status,
  :versionNo 
FROM
  Reservation 
WHERE
  fromDate >= :startDate
  AND fromDate <= :endDate
  AND status = :status