Operation Details
Description: Reads caseEvidenceGroupID using the caseEvidenceTreeID and evidenceType.
Sterotype: ns
SQL 
SELECT
  DISTINCT(CaseEvidenceGroupLink.caseEvidenceGroupID)
INTO
  :caseEvidenceGroupID 
FROM
  CaseEvidenceGroup,
  CaseEvidenceGroupLink 
WHERE CaseEvidenceGroup.caseEvidenceTreeID = :caseEvidenceTreeID 
  AND CaseEvidenceGroupLink.caseEvidenceGroupID = CaseEvidenceGroup.caseEvidenceGroupID 
  AND CaseEvidenceGroupLink.evidenceType = :evidenceType