DBA Data[Home] [Help]

APPS.JL_BR_AP_PAY_SCHED_GDF_PKG dependencies on AP_CHECKS_ALL

Line 545: ap_checks_all ac,

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
549: AND ac.check_id = aip.check_id