Operation Details
Description: Searches for the placements for calculating the units delivered by the provider offering 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 = :serviceOfferingID
	AND ServiceOffering.placementPmtInd = :placementPmtInd