Operation Details
Description: Returns list of cases for concern role where it has specified group code in the date range specified.
Sterotype: nsmulti
SQL 
SELECT
  CaseGroups.caseID
INTO
  :caseID 
FROM
  CaseGroups 
WHERE CaseGroups.concernRoleID = :concernRoleID 
  AND CaseGroups.groupCode = :groupCode 
  AND CaseGroups.startDate >= :startDate 
  AND 
  (
    CaseGroups.endDate <= :endDate 
    OR CaseGroups.endDate IS NULL 
  )