Operation Details
Description: Returns the caseID and the case startDate for a specified case nominee.
Sterotype: ns
SQL 
SELECT
  CaseParticipantRole.caseID,
  CaseHeader.startDate
INTO
  :caseID,
  :startDate 
FROM
  CaseParticipantRole,
  CaseNominee,
  CaseHeader 
WHERE CaseNominee.caseNomineeID = :caseNomineeID 
  AND CaseParticipantRole.caseParticipantRoleID = CaseNominee.caseParticipantRoleID 
  AND CaseHeader.caseID = CaseParticipantRole.caseID