Operation Details
Description: Returns the list of currently active clients for an Integrated case.
Sterotype: nsmulti
SQL 
SELECT
  CaseParticipantRole.caseID,
  CaseParticipantRole.caseParticipantRoleID,
  ConcernRole.concernRoleID,
  CaseParticipantRole.typeCode,
  ConcernRole.concernRoleName,
  Address.addressData
INTO
  :caseID,
  :caseParticipantRoleID,
  :participantRoleID,
  :typeCode,
  :name,
  :address 
FROM
  CaseParticipantRole,
  ConcernRole,
  Address 
WHERE CaseParticipantRole.caseID = :caseID 
  AND CaseParticipantRole.recordStatus = :recordStatus 
  AND 
  (
    CaseParticipantRole.toDate >= :fromDate 
    OR CaseParticipantRole.toDate IS NULL 
  ) 
  AND ConcernRole.concernRoleID = CaseParticipantRole.participantRoleID 
  AND 
  (
    ConcernRole.concernRoleType = :typeCode1 
    OR ConcernRole.concernRoleType = :typeCode2 
  ) 
  AND Address.addressID = ConcernRole.primaryAddressID