Operation Details
Description: Retrieves the list of integrated case identifiers a specified evidence type is being used on.
Sterotype: nsmulti
SQL 
SELECT
  DISTINCT(AdminICEvidenceLink.adminIntegratedCaseID)
INTO
  :adminIntegratedCaseID 
FROM
  EvidenceMetadata,
  AdminICEvidenceLink 
WHERE EvidenceMetadata.evidenceType = :evidenceType 
  AND AdminICEvidenceLink.evidenceMetadataID = EvidenceMetadata.evidenceMetadataID