SELECT 
    CASEDEDUCTIONITEMID
 INTO 
    :caseDeductionItemID
 FROM CASEDEDUCTIONITEM
 WHERE CONCERNROLEID = :providerConcernRoleID
 AND RELATEDCASEID = :relatedCaseID
 AND PRIORITY = :priority
 AND CASEDEDUCTIONITEMID NOT IN 
 (SELECT DISTINCT(CASEDEDUCTIONITEMID) 
  FROM PROVIDERDEDUCTIONCDILINK)