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: