DBA Data[Home] [Help]

APPS.JL_BR_AP_PAY_SCHED_GDF_PKG dependencies on AP_INVOICE_PAYMENTS_ALL

Line 544: ap_invoice_payments_all aip,

540:
541: SELECT abs(sum(nvl(aid.amount,0)))
542: INTO abate
543: FROM ap_invoice_distributions_all aid,
544: ap_invoice_payments_all aip,
545: ap_checks_all ac,
546: iby_docs_payable_all iby
547: WHERE aid.invoice_id = aip.invoice_id
548: AND ac.check_number = iby.payment_id -- :check_number