Operation Details
Description: Returns the default nominee's CaseNominee details.
Sterotype: ns
SQL 
SELECT
  ConcernRole.concernRoleID,
  ConcernRole.concernRoleName,
  ConcernRole.concernRoleType,
  ConcernRole.primaryAlternateID,
  CaseNominee.caseNomineeID
INTO
  :concernRoleID,
  :concernRoleName,
  :concernRoleType,
  :primaryAlternateID,
  :caseNomineeID 
FROM
  ConcernRole,
  CaseNominee,
  CaseParticipantRole 
WHERE CaseParticipantRole.caseID = :caseID 
  AND CaseNominee.caseParticipantRoleID = CaseParticipantRole.caseParticipantRoleID 
  AND CaseNominee.defaultNomInd = :defaultNomInd 
  AND ConcernRole.concernRoleID = CaseParticipantRole.participantRoleID