Operation Details
Description: Returns over and under payment details for the given related reference identifier. The related reference identifier could be a service invoice line item identifier or a provider roster line item identifier.
Sterotype: nsmulti
SQL
SELECT OVERUNDERPAYMENTBREAKDOWN.OVERUNDERPAYMENTBREAKDOWNID,
OVERUNDERPAYMENTBREAKDOWN.REASSESSMENTRESULTTYPE,
OVERUNDERPAYMENTBREAKDOWN.AMOUNT
INTO 
:overUnderPaymentBreakdownID, 
:reassessmentResultType,
:amount
FROM 
OVERUNDERPAYMENTBREAKDOWN
WHERE OVERUNDERPAYMENTBREAKDOWN.RELATEDREFERENCE = :relatedReference