Operation Details
Description: Join across CaseHeader and ConcernRole. Returns details about all cases created for the particular case participant.
Sterotype: nsmulti
SQL 
SELECT
  CaseHeader.caseID,
  CaseHeader.caseTypeCode,
  CaseHeader.startDate,
  CaseHeader.statusCode,
  ConcernRole.concernRoleID,
  ConcernRole.concernRoleName,
  ConcernRole.concernRoleType
INTO
  :caseID,
  :caseTypeCode,
  :startDate,
  :statusCode,
  :concernRoleID,
  :concernRoleName,
  :concernRoleType 
FROM
  CaseHeader,
  ConcernRole 
WHERE CaseHeader.concernRoleID = :concernRoleID 
  AND ConcernRole.concernRoleID = :concernRoleID 
  AND CaseHeader.statusCode <> :statusCode