SELECT
  AdminICEvidenceLink.adminICEvidenceLinkID,
  AdminICEvidenceLink.shareableInd,
  EvidenceMetadata.evidenceType
INTO
  :adminICEvidenceLinkID,
  :shareableInd,
  :evidenceType 
FROM
  AdminICEvidenceLink,
  EvidenceMetadata 
WHERE AdminICEvidenceLink.adminIntegratedCaseID = :adminIntegratedCaseID 
  AND EvidenceMetadata.evidenceMetadataID = AdminICEvidenceLink.evidenceMetadataID 
  AND EvidenceMetadata.recordStatus = :recordStatus