Operation Details
Description: Counts the number of live evidence records for an evidence type version. Live records are considered the evidence records with status ACTIVE, INEDIT, IDENTICALINEDIT or NONIDENTICALINEDIT
Sterotype: ns
SQL
SELECT
    count(*)
INTO
    :counter 
FROM
    AdminICEvidenceTypeDefLink
WHERE
    AdminICEvidenceTypeDefLink.evidenceTypeDefID = :evidenceTypeDefID
  AND AdminICEvidenceTypeDefLink.adminIntegratedCaseID = :adminIntegratedCaseID