Operation Details
Description: Searches for all integrated cases of a specific type where the individual is of a specific type on the case. E.g. Case member or primary client.
Sterotype: nsmulti
SQL 
SELECT
  CaseHeader.caseID
INTO
  :caseID 
FROM
  CaseHeader,
  CaseParticipantRole 
WHERE CaseHeader.integratedCaseType = :integratedCaseType 
  AND CaseParticipantRole.participantRoleID = :concernRoleID 
  AND CaseHeader.caseID = CaseParticipantRole.caseID 
  AND CaseParticipantRole.typeCode = :typeCode