APPS.JL_BR_AP_PAY_SCHED_GDF_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 543: FROM ap_invoice_distributions_all aid,

539: IF (l_process_type = 'IMMEDIATE') THEN
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

Line 555: FROM ap_invoice_distributions_all aid,

551: AND iby.document_payable_id = P_Doc_Payable_ID;
552: ELSE
553: SELECT abs(sum(nvl(aid.amount,0)))
554: INTO abate
555: FROM ap_invoice_distributions_all aid,
556: ap_selected_invoices_all asi,
557: iby_docs_payable_all iby,
558: iby_pay_service_requests proc,
559: iby_payments_all paym