DBA Data[Home] [Help]

APPS.JL_BR_AP_PAY_SCHED_GDF_PKG dependencies on AP_SELECTED_INVOICES_ALL

Line 490: FROM ap_selected_invoices_all ap,

486:
487: IF (l_process_type <> 'IMMEDIATE' or P_Process_Type IS NULL) THEN
488: SELECT sum(nvl(invoice_amount,0))
489: INTO int_amt
490: FROM ap_selected_invoices_all ap,
491: iby_docs_payable_all iby
492: WHERE original_invoice_id = iby.calling_app_doc_unique_ref2 -- :invoice_id
493: AND original_payment_num = iby.calling_app_doc_unique_ref3 -- :payment_num
494: AND iby.document_payable_id = P_Doc_Payable_ID;

Line 556: ap_selected_invoices_all asi,

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
560: WHERE aid.invoice_id = asi.invoice_id