Operation Details
Description: Searches all the reservations for a given status whose start date is between the date range. @deprecated Since Curam 6.0 SP1, replaced with {@link #searchByDateTimeRangeAndStatus(DateTime, DateTime, RESERVATIONSTATUSEntry)}. This method is comparing reservation start date time with date range instead of date time range. Hence this method is deprecated. The newly added method will compare reservation start date time with date time range. See release note:CR00260608.
Sterotype: nsmulti
SQL 
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