Operation Details
Description: Searches for the placements for calculating the units delivered by theall provider offerings associated with contract and overlapping with contract period. @deprecated since 7.0.0.0, This functionality forms part of a feature that is no longer relevant to the product strategy and will not be replaced.
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,
  ContractVersion,
 ContractPOLink  
WHERE ContractVersion.contractVersionID = :resourceID 
AND ContractVersion.contractVersionID = ContractPOLink.contractVersionID
AND ProviderOffering.providerOfferingID =ContractPOLink.providerOfferingID
 AND Placement.providerOfferingID = ProviderOffering.providerOfferingID 
  AND Placement.recordStatus = :recordStatus 
  AND ProviderOffering.serviceOfferingID = ServiceOffering.serviceOfferingID 
  AND ServiceOffering.placementPmtInd = :placementPmtInd