Database SQL Operation: PerformanceMeasureLink.readFlatRateContractCountForProvider
Description: | Reads the performance measure against all flat-rate contracts for the provider.
@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 |
SELECT
SUM(InstructionLineItem.amount)
INTO
:count
FROM
InstructionLineItem
WHERE InstructionLineItem.concernRoleID = :resourceID
AND InstructionLineItem.instructionLineItemType = :instructionLineItemType
AND InstructionLineItem.instructLineItemCategory = :instructLineItemCategory
AND InstructionLineItem.statusCode = :statusCode
|