Operation Details
Description: This readmulti returns a list of all over/under payments that have occurred on a Case.
Sterotype: nsmulti
SQL 
SELECT
  OverUnderPaymentHeader.overUnderPaymentHeaderID,
  OverUnderPaymentHeader.reassessmentDate,
  NomineeOverUnderPayment.nomineeOverUnderPaymentID,
  NomineeOverUnderPayment.caseNomineeID,
  NomineeOverUnderPayment.coverPeriodFrom,
  NomineeOverUnderPayment.coverPeriodTo,
  NomineeOverUnderPayment.amountTypeCode,
  NomineeOverUnderPayment.totalAmount,
  ConcernRole.concernRoleName
INTO
  :overUnderPaymentHeaderID,
  :reassessmentDate,
  :nomineeOverUnderPaymentID,
  :caseNomineeID,
  :coverPeriodFrom,
  :coverPeriodTo,
  :amountTypeCode,
  :totalAmount,
  :nomineeName 
FROM
  OverUnderPaymentHeader,
  NomineeOverUnderPayment,
  CaseNominee,
  CaseParticipantRole,
  ConcernRole 
WHERE OverUnderPaymentHeader.caseID = :caseID 
  AND OverUnderPaymentHeader.overUnderPaymentHeaderID = NomineeOverUnderPayment.overUnderPaymentHeaderID 
  AND NomineeOverUnderPayment.caseNomineeID = CaseNominee.caseNomineeID 
  AND CaseNominee.caseParticipantRoleID = CaseParticipantRole.caseParticipantRoleID 
  AND ConcernRole.concernRoleID = CaseParticipantRole.participantRoleID 
ORDER BY OverUnderPaymentHeader.reassessmentDate DESC,
  NomineeOverUnderPayment.coverPeriodFrom DESC