Database SQL Operation: SILICorrection.searchOverUnderPaymentsByRelatedReference
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 |
SELECT OVERUNDERPAYMENTBREAKDOWN.OVERUNDERPAYMENTBREAKDOWNID,
OVERUNDERPAYMENTBREAKDOWN.REASSESSMENTRESULTTYPE,
OVERUNDERPAYMENTBREAKDOWN.AMOUNT
INTO
:overUnderPaymentBreakdownID,
:reassessmentResultType,
:amount
FROM
OVERUNDERPAYMENTBREAKDOWN
WHERE OVERUNDERPAYMENTBREAKDOWN.RELATEDREFERENCE = :relatedReference
|