Operation Details
Description: Reads the closest nominee objective record by the date entered.
Sterotype: ns
SQL 
SELECT
  CaseNomineeObjective.fromDate,
  CaseNomineeObjective.caseNomineeID
INTO
  :fromDate,
  :caseNomineeID 
FROM
  CaseNomineeObjective,
  ConcernRole,
  CaseParticipantRole,
  CaseNominee 
WHERE CaseNomineeObjective.rulesObjectiveID = :rulesObjectiveID 
  AND CaseNomineeObjective.statusCode = :statusCode 
  AND CaseNomineeObjective.fromDate = 
  ( 
  SELECT
    MIN(CaseNomineeObjective.fromDate) 
  FROM
    CaseNomineeObjective 
  WHERE CaseNomineeObjective.fromDate > :fromDate 
    AND CaseNomineeObjective.rulesObjectiveID = :rulesObjectiveID 
    AND CaseNomineeObjective.statusCode = :statusCode 
    AND CaseNominee.caseNomineeID = CaseNomineeObjective.caseNomineeID 
    AND CaseParticipantRole.caseParticipantRoleID = CaseNominee.caseParticipantRoleID 
    AND CaseParticipantRole.caseID = :caseID 
    AND ConcernRole.concernRoleID = CaseParticipantRole.participantRoleID 
  ) 
  AND CaseNominee.caseNomineeID = CaseNomineeObjective.caseNomineeID 
  AND CaseParticipantRole.caseParticipantRoleID = CaseNominee.caseParticipantRoleID 
  AND CaseParticipantRole.caseID = :caseID 
  AND ConcernRole.concernRoleID = CaseParticipantRole.participantRoleID