DBA Data[Home] [Help]

APPS.AP_UTILITIES_PKG dependencies on AP_INVOICES_UTILITY_PKG

Line 2199: - nvl(AP_INVOICES_UTILITY_PKG.get_amount_withheld(p_invoice_id),0)

2195: AND AIL.prepay_invoice_id IS NOT NULL
2196: AND AIL.prepay_line_number IS NOT NULL));
2197:
2198: SELECT nvl(AI.invoice_amount,0)- l_prepay_amount
2199: - nvl(AP_INVOICES_UTILITY_PKG.get_amount_withheld(p_invoice_id),0)
2200: INTO l_net_inv_amount
2201: FROM ap_invoices_all AI
2202: WHERE AI.invoice_id = p_invoice_id;
2203: