Operation Details
Description: Reads the Nominee's Name and the Case Reference number.
Sterotype: ns
SQL 
SELECT
  ConcernRole.concernRoleName,
  CaseHeader.caseReference
INTO
  :concernRoleName,
  :caseReference 
FROM
  ConcernRole,
  CaseNominee,
  CaseParticipantRole,
  CaseHeader 
WHERE CaseNominee.caseNomineeID = :caseNomineeID 
  AND CaseParticipantRole.caseParticipantRoleID = CaseNominee.caseParticipantRoleID 
  AND ConcernRole.concernRoleID = CaseParticipantRole.participantRoleID 
  AND CaseHeader.caseID = :caseID