DBA Data[Home] [Help]

APPS.AP_VOID_PKG dependencies on AP_INVOICES_ALL

Line 210: ap_invoices_all ai_prepay,

206: CURSOR Prepay_Appl IS
207: SELECT DISTINCT aid.invoice_id
208: FROM ap_invoice_payments_all aip,
209: ap_invoice_distributions_all aid_prepay,
210: ap_invoices_all ai_prepay,
211: ap_invoice_distributions_all aid
212: WHERE aip.check_id = P_Check_ID
213: AND aip.invoice_id = aid_prepay.invoice_id
214: AND aid_prepay.invoice_id = ai_prepay.invoice_id

Line 548: UPDATE ap_invoices_all AI

544: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
545: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
546: END IF;
547:
548: UPDATE ap_invoices_all AI
549: SET AI.description = 'VOID '||AI.description,
550: AI.invoice_amount = 0,
551: AI.amount_paid = 0,
552: AI.invoice_distribution_total = 0,