Operation Details
Description: Returns a list of distinct caseID's for any active deductions for a particular thirdPartyConcernRoleID. An active deduction is any deduction whose endDate is null or whose endDate is sometime in the future (and has a status of active).
Sterotype: nsmulti
SQL 
SELECT
  DISTINCT caseID
INTO
  :caseID 
FROM
  CaseDeductionItem 
WHERE thirdPartyConcernRoleID = :thirdPartyConcernRoleID 
  AND statusCode = :statusCode 
  AND 
  (
    endDate is NULL 
    OR endDate > :currentDate 
  )