Operation Details
Description:  
Sterotype: ns
SQL 
SELECT
  DISTINCT(NomineeOverUnderPayment.caseNomineeID)
INTO
  :caseNomineeID
FROM
  PaymentCorrectionEvidence,
  OverUnderPaymentBreakdown,
  NomineeOverUnderPayment
WHERE PaymentCorrectionEvidence.caseID = :caseID
AND OverUnderPaymentBreakdown.overUnderPaymentBreakdownID = 
  (Select MIN(overUnderPaymentBreakdownID) from PaymentCorrectionEvidence
   Where PaymentCorrectionEvidence.caseID = :caseID)
AND NomineeOverUnderPayment.nomineeOverUnderPaymentID = OverUnderPaymentBreakdown.nomineeOverUnderPaymentID