DBA Data[Home] [Help]

APPS.AP_ETAX_UTILITY_PKG dependencies on ZX_DETAIL_TAX_LINES_GT

Line 6318: l_debug_info := 'Step 1: Get data from zx_detail_tax_lines_gt and '||

6314: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
6315: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_curr_calling_sequence);
6316: END IF;
6317: -------------------------------------------------------------------
6318: l_debug_info := 'Step 1: Get data from zx_detail_tax_lines_gt and '||
6319: 'update amount and base_amount for line(s)';
6320: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
6321: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
6322: END IF;

Line 6329: FROM zx_detail_tax_lines_gt zdl

6325: UPDATE ap_invoice_lines_all ail
6326: SET (ail.amount, ail.base_amount) =
6327: (SELECT NVL(ail.amount, 0) - SUM(NVL(zdl.tax_amt,0)),
6328: NVL(ail.base_amount,0) - SUM(NVL(zdl.tax_amt_funcl_curr,0))
6329: FROM zx_detail_tax_lines_gt zdl
6330: WHERE zdl.application_id = 200
6331: AND zdl.entity_code = 'AP_INVOICES'
6332: AND zdl.event_class_code IN ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')
6333: AND zdl.trx_id = ail.invoice_id