DBA Data[Home] [Help]

APPS.AP_PAYMENT_UTIL_PKG dependencies on AP_INVOICES_ALL

Line 384: FROM ap_invoices_all ai

380: BEGIN
381:
382: SELECT SUM(NVL(amount_paid,0))
383: INTO l_interest_paid
384: FROM ap_invoices_all ai
385: WHERE invoice_id IN (
386: SELECT DISTINCT related_invoice_id
387: FROM ap_invoice_relationships air
388: WHERE original_invoice_id = p_invoice_id );

Line 411: l_interest_inv AP_INVOICES_ALL.invoice_num%TYPE;

407: p_payment_num IN NUMBER
408: )
409: RETURN VARCHAR2 IS
410:
411: l_interest_inv AP_INVOICES_ALL.invoice_num%TYPE;
412:
413:
414: BEGIN
415: