Operation Details
Description: Retrieves all Admin Integrated Case records linked to evidence by the record status code specified. The details retrieved include admin integrated case ID and type.
Sterotype: nsmulti
SQL 
SELECT
  DISTINCT AdminIntegratedCase.adminIntegratedCaseID,
  AdminIntegratedCase.integratedCaseType
INTO
  :adminIntegratedCaseID,
  :integratedCaseType 
FROM
  AdminIntegratedCase,
  AdminICEvidenceLink 
WHERE AdminIntegratedCase.adminIntegratedCaseID =AdminICEvidenceLink.adminIntegratedCaseID 
  AND AdminIntegratedCase.statusCode = :statusCode