Operation Details
Description: Reads CaseNominee and related Participant details.
Sterotype: ns
SQL 
SELECT
  CaseNominee.caseNomineeID,
  CaseNominee.caseParticipantRoleID,
  CaseNominee.nomineeRelationship,
  CaseNominee.currencyType,
  CaseNominee.versionNo,
  CaseNominee.nomineeStatus,
  ConcernRole.concernRoleID,
  ConcernRole.concernRoleName,
  ConcernRole.concernRoleType,
  ConcernRole.primaryAlternateID,
  CaseNominee.defaultNomInd,
  CaseParticipantRole.caseID
INTO
  :caseNomineeID,
  :caseParticipantRoleID,
  :nomineeRelationship,
  :currencyType,
  :versionNo,
  :nomineeStatus,
  :concernRoleID,
  :concernRoleName,
  :concernRoleType,
  :alternateID,
  :defaultNomInd,
  :caseID 
FROM
  ConcernRole,
  CaseNominee,
  CaseParticipantRole 
WHERE CaseNominee.caseNomineeID = :caseNomineeID 
  AND CaseParticipantRole.caseParticipantRoleID = CaseNominee.caseParticipantRoleID 
  AND ConcernRole.concernRoleID = CaseParticipantRole.participantRoleID