DBA Data[Home] [Help]

APPS.AP_PAYMENT_UTIL_PKG dependencies on AP_INVOICES_ALL

Line 366: FROM ap_invoices_all ai

362: BEGIN
363:
364: SELECT SUM(NVL(amount_paid,0))
365: INTO l_interest_paid
366: FROM ap_invoices_all ai
367: WHERE invoice_id IN (
368: SELECT DISTINCT related_invoice_id
369: FROM ap_invoice_relationships air
370: WHERE original_invoice_id = p_invoice_id );

Line 393: l_interest_inv AP_INVOICES_ALL.invoice_num%TYPE;

389: p_payment_num IN NUMBER
390: )
391: RETURN VARCHAR2 IS
392:
393: l_interest_inv AP_INVOICES_ALL.invoice_num%TYPE;
394:
395:
396: BEGIN
397: