Operation Details
Description: reads the dead of death of a person based on there case nominee id
Sterotype: ns
SQL 
SELECT
  Person.dateOfDeath,
  Person.dateOfDeathVerInd
INTO
  :dateOfDeath,
  :dateOfDeathVerInd 
FROM
  Person,
  CaseParticipantRole,
  CaseNominee 
WHERE CaseNominee.caseNomineeID = :caseNomineeID 
  AND CaseParticipantRole.caseParticipantRoleID = CaseNominee.caseParticipantRoleID 
  AND Person.concernRoleID = CaseParticipantRole.participantRoleID