APPS.AP_GET_SUPPLIER_BALANCE_PKG dependencies on AP_INVOICE_PAYMENTS

Line 174: FROM ap_invoice_payments AIP, ap_invoices AI

170:
171: -- get payment amount along with the discount taken
172: SELECT NVL(SUM(NVL(AIP.amount, 0)), 0), NVL(SUM(NVL(AIP.discount_taken, 0)), 0)
173: INTO l_payment_amount, l_discount_taken
174: FROM ap_invoice_payments AIP, ap_invoices AI
175: WHERE AIP.invoice_id = AI.invoice_id
176: AND AI.invoice_id = inv_rec.invoice_id
177: AND trunc(AIP.accounting_date) <= trunc(p_as_of_date);
178: