Operation Details
Description: Reads the performance measure against the clients served for placements for the all provider offerings associated with contract and placements 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: ns
SQL 

SELECT
  COUNT(DISTINCT(Placement.caseParticipantRoleID))
INTO
  :count 
FROM
  Placement,
  ProviderOffering,
  ServiceOffering,
  ContractVersion,
  ContractPOLink 
WHERE ContractVersion.ContractVersionID = :resourceID 
  AND ContractVersion.ContractVersionID = ContractPOLink.ContractVersionID
  AND Placement.providerOfferingID = ContractPOLink.providerOfferingID
  AND Placement.recordStatus = :recordStatus 
  AND Placement.providerOfferingID = ProviderOffering.providerOfferingID 
  AND ProviderOffering.serviceOfferingID = ServiceOffering.serviceOfferingID 
  AND ServiceOffering.PlacementPmtInd = :placementPmtInd