Operation Details
Description:  
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