SELECT 
        AdviceItemCaseLink.adviceItemCaseLinkID, 
        AdviceItemCaseLink.adviceItemID,
        AdviceItemCaseLink.caseID,
        AdviceItemCaseLink.evidenceType,
        AdviceItemCaseLink.relatedID
      INTO
        :adviceItemCaseLinkID,
        :adviceItemID,
        :caseID,
        :evidenceType,
        :relatedID
      FROM
         AdviceItemCaseLink,
         AdviceItem
         
      WHERE AdviceItemCaseLink.caseID = :caseID
         AND AdviceItemCaseLink.evidenceType = :evidenceType
         AND AdviceItemCaseLink.adviceItemID = AdviceItem.adviceItemID 
         AND AdviceItem.categoryType = :categoryType