Operation Details
Description: Method to count any occurrence of the evidence type for a particular Evidence Tree ID.
Sterotype: ns
SQL
SELECT
  COUNT(*)
INTO
  :recordCount 
FROM
  ISPEvidenceTypeStatus 
WHERE ISPEvidenceTypeStatus.caseEvidenceTreeID = :caseEvidenceTreeID 
  AND ISPEvidenceTypeStatus.caseEvidenceTypeCode = :caseEvidenceTypeCode