Operation Details
Description: Retrieves list of case header details by concern role ID and ignores case headers with specified status code
Sterotype: nsmulti
SQL 
SELECT
  distinct CaseHeader.caseID
INTO
  :caseID 
FROM
  CaseParticipantRole,
  CaseHeader 
WHERE CaseParticipantRole.participantRoleID = :concernRoleID 
  AND CaseHeader.caseID = CaseParticipantRole.caseID 
  AND CaseHeader.statusCode <> :statusCode