Operation Details
Description: Search for Provider Deductions whose associated Case Deduction Items have not been linked.
Sterotype: nsmulti
SQL 
SELECT 
  PD.PROVIDERDEDUCTIONID
INTO
  :providerDeductionID
FROM 
  PROVIDERDEDUCTION PD
WHERE 
(SELECT COUNT(*) 
 FROM CASEDEDUCTIONITEM CDI, PROVIDERDEDUCTION PDN
 WHERE CDI.CONCERNROLEID = PDN.PROVIDERCONCERNROLEID
 AND CDI.RELATEDCASEID = PDN.RELATEDCASEID
 AND CDI.PRIORITY = PDN.PRIORITY
 AND CDI.CASEDEDUCTIONITEMID NOT IN (SELECT DISTINCT(CASEDEDUCTIONITEMID) FROM PROVIDERDEDUCTIONCDILINK)) > 0