Operation Details
Description: Searches all the reservations with given provider offering which are starting within the given date range for a given status. @deprecated Since Curam 6.0 SP1, replaced with {@link #searchByProviderOfferingStartDateTimeRangeAndStatus(ProviderOffering, 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
  Reservation.reservationID,
  Reservation.placementID,
  Reservation.placeID,
  Reservation.providerOfferingID,
  Reservation.caseParticipantRoleID,
  Reservation.unitAmount,
  Reservation.unitAmountFixedIndicator,
  Reservation.fromDate,
  Reservation.toDate,
  Reservation.dateOfExpiry,
  Reservation.comments,
  Reservation.status,
  Reservation.versionNo
INTO
  :reservationID,
  :placementID,
  :placeID,
  :providerOfferingID,
  :caseParticipantRoleID,
  :unitAmount,
  :unitAmountFixedIndicator,
  :fromDate,
  :toDate,
  :dateOfExpiry,
  :comments,
  :status,
  :versionNo 
FROM
  Reservation 
WHERE
Reservation.providerOfferingID = :providerOfferingID
AND Reservation.fromDate >= :startDate
AND Reservation.fromDate <= :endDate
AND Reservation.status = :status