APPS.AP_ETAX_UTILITY_PKG dependencies on ZX_DETAIL_TAX_LINES_GT

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

5142: l_curr_calling_sequence := 'AP_ETAX_UTILITY_PKG.Return_Tax_Quote<-'||
5143: P_calling_sequence;
5144:
5145: -------------------------------------------------------------------
5146: l_debug_info := 'Step 1: Get data from zx_detail_tax_lines_gt and '||
5147: 'update amount and base_amount for line(s)';
5148: -------------------------------------------------------------------
5149: BEGIN
5150: UPDATE ap_invoice_lines_all ail

Line 5154: FROM zx_detail_tax_lines_gt zdl

5150: UPDATE ap_invoice_lines_all ail
5151: SET (ail.amount, ail.base_amount) =
5152: (SELECT NVL(ail.amount, 0) - SUM(NVL(zdl.tax_amt,0)),
5153: NVL(ail.base_amount,0) - SUM(NVL(zdl.tax_amt_funcl_curr,0))
5154: FROM zx_detail_tax_lines_gt zdl
5155: WHERE zdl.application_id = 200
5156: AND zdl.entity_code = 'AP_INVOICES'
5157: AND zdl.event_class_code IN ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')
5158: AND zdl.trx_id = ail.invoice_id