Operation Details
Description: Checks if an evidence type is being used on a live case.
Sterotype: nsmulti
SQL
SELECT
  caseID
INTO
  :caseID 
FROM
  EvidenceDescriptor 
WHERE evidenceType = :evidenceType 
  AND 
  (
    statusCode = :statusCode1 
    OR statusCode = :statusCode2 
  )