Operation Details
Description: Searches for integrated case types that use this evidence type.
Sterotype: nsmulti
SQL 
SELECT
  AdminIntegratedCase.integratedCaseType
INTO
  :integratedCaseType 
FROM
  EvidenceMetadata,
  AdminICEvidenceLink,
  AdminIntegratedCase 
WHERE EvidenceMetadata.evidenceType = :evidenceType 
  AND AdminICEvidenceLink.evidenceMetadataID = EvidenceMetadata.evidenceMetadataID 
  AND AdminICEvidenceLink.adminIntegratedCaseID = AdminIntegratedCase.adminIntegratedCaseID