Operation Details
Description: Reads the active alternate names for the active participant roles for specified case.
Sterotype: nsmulti
SQL 
SELECT
  AlternateName.concernRoleID,
  AlternateName.alternateNameID,
  AlternateName.firstForename,
  AlternateName.Surname,
  CaseParticipantRole.caseParticipantRoleID,
  CaseParticipantRole.caseID
INTO
  :concernRoleID,
  :alternateNameID,
  :firstName,
  :surname,
  :caseParticipantRoleID,
  :caseID
FROM
  CaseParticipantRole,
  AlternateName
WHERE CaseParticipantRole.caseID = :caseID
 AND CaseParticipantRole.recordStatus = :recordStatus
 AND CaseParticipantRole.participantRoleID = AlternateName.concernRoleID
 AND AlternateName.nameStatus = :recordStatus