Operation Details
Description: Reads the performance measure against all flat-rate contracts for the provider offering. @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
  SUM(InstructionLineItem.amount)
INTO
  :count 
FROM
  CaseDecisionFinancialComp,
  CaseDecisionObjective,
  InstructionLineItem 
WHERE CaseDecisionFinancialComp.caseDecisionObjectiveID = CaseDecisionObjective.caseDecisionObjectiveID 
  AND InstructionLineItem.financialCompID = CaseDecisionFinancialComp.financialCompID 
  AND CaseDecisionObjective.overflowInd = :overflowInd 
  AND CaseDecisionObjective.relatedReference IN 
  ( 
  SELECT
    CAST(ContractVersion.contractVersionID AS CHAR(20)) 
  FROM
    ContractVersion,
    ContractPOLink,
    FlatRateContract 
  WHERE ContractPOLink.providerOfferingID = :resourceID 
    AND ContractPOLink.contractVersionID = ContractVersion.contractVersionID 
    AND ContractVersion.contractType = :contractType 
    AND ContractVersion.status = :contractStatus 
    AND FlatRateContract.contractVersionID = ContractVersion.contractVersionID 
  ) 
  AND InstructionLineItem.instructionLineItemType = :instructionLineItemType 
  AND InstructionLineItem.instructLineItemCategory = :instructLineItemCategory 
  AND InstructionLineItem.statusCode = :statusCode