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
CaseParticipantRole,
Reservation
WHERE CaseParticipantRole.participantRoleID = :clientID
AND CaseParticipantRole.caseParticipantRoleID = Reservation.caseParticipantRoleID
AND Reservation.status = :status
|