DBA Data[Home] [Help]

APPS.AP_UTILITIES_PKG dependencies on AP_INVOICES_UTILITY_PKG

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

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