SELECT
    EvidenceTypeDef.evidenceTypeDefID,
    EvidenceTypeDef.evidenceTypeCode
  INTO
    :evidenceTypeDefID,
    :evidenceTypeCode 
  FROM
    EvidenceTypeDef 
  WHERE EvidenceTypeDef.recordStatus = :recordStatus 
    AND :adminIntegratedCaseID NOT IN 
    ( 
    SELECT
      AdminICEvidenceTypeDefLink.adminIntegratedCaseID 
    FROM
      AdminICEvidenceTypeDefLink 
    WHERE AdminICEvidenceTypeDefLink.evidenceTypeDefID = EvidenceTypeDef.evidenceTypeDefID 
    )