APPS.AP_MASS_ADDITIONS_CREATE_PKG dependencies on AP_INVOICE_PAYMENTS_ALL

Line 341: UPDATE ap_invoice_payments_all APIP

337: /* Bug#11868928 - End */
338:
339:
340: /* Bug#14712606 - Start */
341: UPDATE ap_invoice_payments_all APIP
342: SET APIP.assets_addition_flag = 'N'
343: WHERE APIP.assets_addition_flag = 'U'
344: AND APIP.posted_flag = 'Y'
345: AND APIP.accounting_date <= P_acctg_date

Line 1786: ap_invoice_payments_all APIP,

1782: 'NEW',
1783: APIP.invoice_payment_id
1784: FROM ap_invoice_distributions_all APID,
1785: ap_invoice_lines_all APIL,
1786: ap_invoice_payments_all APIP,
1787: ap_payment_hist_dists APHD,
1788: ap_invoices_all API,
1789: ap_batches_all APB,
1790: po_distributions_all POD,

Line 2424: UPDATE ap_invoice_payments_all APIP

2420: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2421: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,l_debug_info);
2422: END IF;
2423: --
2424: UPDATE ap_invoice_payments_all APIP
2425: SET APIP.assets_addition_flag = 'Y'
2426: WHERE APIP.assets_addition_flag = 'U'
2427: AND APIP.posted_flag = 'Y'
2428: AND APIP.set_of_books_id = l_ledger_id

Line 2452: UPDATE ap_invoice_payments_all APIP

2448: ||'after successfully transferred to Asset: '
2449: ||TO_CHAR(l_count));
2450: END IF;
2451: --
2452: UPDATE ap_invoice_payments_all APIP
2453: SET APIP.assets_addition_flag = 'N'
2454: WHERE APIP.assets_addition_flag = 'U'
2455: AND APIP.posted_flag = 'Y'
2456: AND APIP.set_of_books_id = l_ledger_id