Operation Details
Description: Returns the number of cases for a specified concern role less those cases specified by status and type
Sterotype: ns
SQL 
SELECT
  COUNT(*)
INTO
  :value 
FROM
  CaseHeader 
WHERE concernRoleID = :concernRoleID 
  AND 
  (
    statusCode <> :statusCode 
    OR :statusCode IS NULL 
  ) 
  AND 
  (
    caseTypeCode <> :caseTypeCode 
    OR :caseTypeCode IS NULL 
  )