Operation Details
Description: Returns all cases of the particular type for the specified concern role that are part of an Integrated Case or Screening Case specified.
Sterotype: nsmulti
SQL 
SELECT
  DISTINCT(CaseHeader.caseID)
INTO
  :caseID 
FROM
  CaseHeader,
  CaseParticipantRole CPR 
WHERE CaseHeader.integratedCaseID = :caseID 
  AND CPR.caseID = CaseHeader.caseID 
  AND CPR.participantRoleID = :concernRoleID