APPS.AP_PAYMENT_PUBLIC_PKG dependencies on AP_INVOICES_ALL

Line 697: ap_invoices_all ai,

693: * (PS.AMOUNT_REMAINING / DECODE(PS.GROSS_AMOUNT,
694: 0, 1,
695: PS.GROSS_AMOUNT))))
696: FROM ap_payment_schedules_all PS,
697: ap_invoices_all ai,
698: ap_supplier_sites_all asi
699: WHERE ai.invoice_id = ps.invoice_id
700: AND ai.vendor_id = asi.vendor_id
701: AND ai.vendor_site_id = asi.vendor_site_id

Line 762: l_inv_curr ap_invoices_all.invoice_currency_code%type;

758: RETURN NUMBER IS
759: l_amount_remaining ap_payment_schedules_all.amount_remaining%type;
760: l_discount_amount ap_payment_schedules_all.discount_amount_available%type;
761: l_discount_on_netted_amt ap_payment_schedules_all.discount_amount_available%type;
762: l_inv_curr ap_invoices_all.invoice_currency_code%type;
763: l_debug_info FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
764: DBG_Loc VARCHAR2(50) := 'Get_Discount_For_Netted_Amt';
765: Netting_Exception EXCEPTION;
766: BEGIN

Line 798: FROM ap_invoices_all

794: END IF;
795:
796: SELECT invoice_currency_code
797: INTO l_inv_curr
798: FROM ap_invoices_all
799: WHERE invoice_id = P_Invoice_Id;
800:
801: l_discount_on_netted_amt := AP_UTILITIES_PKG.Ap_Round_Currency(l_discount_on_netted_amt,l_inv_curr);
802: