Operation Details
Description: Reads the performance measure against the clients served for placements for the provideroffering 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 ProviderOffering.serviceOfferingID = :serviceOfferingID
  AND Placement.recordStatus = :recordStatus 
  AND Placement.providerOfferingID = ProviderOffering.providerOfferingID 
  AND ProviderOffering.serviceOfferingID = ServiceOffering.serviceOfferingID 
  AND ServiceOffering.placementPmtInd = :placementPmtInd