Database SQL Operation: DeterminationDelivery.countDMCumulativeScoreByAssessment
Description: | |
Sterotype: | ns |
SELECT
COUNT(*)
INTO
:count
FROM
DecisionMatrixVersion,
DeterminationDelivery,
DPDecisionMatrixLink
WHERE DeterminationDelivery.assessmentCaseID = :assessmentCaseID
AND DPDecisionMatrixLink.determinationPackageVersionID = DeterminationDelivery.determinationPackageVersionID
AND DecisionMatrixVersion.decisionMatrixVersionID = DPDecisionMatrixLink.decisionMatrixVersionID
AND DecisionMatrixVersion.cumulativeScore = :cumulativeScore
|