Operation Details
Description: Searches for the placements for calculating the units delivered by the provider.
Sterotype: nsmulti
SQL 
SELECT
  Placement.placementID,
  Placement.placeID,
  Placement.providerOfferingID,
  Placement.startDate,
  Placement.endDate,
  Placement.comments,
  Placement.caseParticipantRoleID,
  Placement.unitAmount,
  Placement.unitAmountFixedInd,
  Placement.totalCost,
  Placement.caseID,
  Placement.recordStatus
INTO
  :placementID,
  :placeID,
  :providerOfferingID,
  :startDate,
  :endDate,
  :comments,
  :caseParticipantRoleID,
  :unitAmount,
  :unitAmountFixedInd,
  :totalCost,
  :caseID,
  :recordStatus 
FROM
  Placement,
  ProviderOffering,
  ServiceOffering 
WHERE Placement.recordStatus = :recordStatus 
  AND Placement.providerOfferingID = ProviderOffering.providerOfferingID 
  AND ProviderOffering.providerConcernRoleID = :resourceID 
  AND ProviderOffering.serviceOfferingID = ServiceOffering.serviceOfferingID 
  AND ServiceOffering.placementPmtInd = :placementPmtInd 
  AND ServiceOffering.unitOfMeasure = :unitOfMeasure