Operation Details
Description: Searches placements for a case.
Sterotype: nsmulti
SQL 
SELECT
  placementID,
  placeID,
  providerOfferingID,
  Placement.startDate,
  Placement.endDate,
  Placement.comments,
  Placement.caseParticipantRoleID,
  unitAmount,
  unitAmountFixedInd,
  totalCost,
  Placement.caseID,
  Placement.recordStatus
INTO
  :placementID,
  :placeID,
  :providerOfferingID,
  :startDate,
  :endDate,
  :comments,
  :caseParticipantRoleID,
  :unitAmount,
  :unitAmountFixedInd,
  :totalCost,
  :caseID,
  :recordStatus 
FROM
  Placement,
  CaseParticipantRole,
  CaseHeader 
WHERE CaseParticipantRole.caseParticipantRoleID = Placement.caseParticipantRoleID 
  AND CaseParticipantRole.caseID = CaseHeader.caseID 
  AND CaseHeader.caseReference = :caseReferenceNumber 
  AND Placement.recordStatus = :placementStatus