DBA Data[Home] [Help]

APPS.AP_ETAX_SERVICES_PKG dependencies on ZX_DETAIL_TAX_LINES_GT

Line 11878: FROM zx_detail_tax_lines_gt zdl

11874: l_api_name CONSTANT VARCHAR2(200) := 'Calculate_Quote';
11875:
11876: CURSOR c_tax_amount IS
11877: SELECT SUM(NVL(zdl.tax_amt,0))
11878: FROM zx_detail_tax_lines_gt zdl
11879: WHERE zdl.application_id = 200
11880: AND zdl.entity_code = 'AP_INVOICES'
11881: AND zdl.trx_id = P_Invoice_Lines_Rec.invoice_id
11882: AND NVL(zdl.self_assessed_flag, 'N') = 'N'

Line 12242: FROM zx_detail_tax_lines_gt zdl

12238: -----------------------------------------------------------------
12239:
12240: SELECT distinct zdl.tax_amt_included_flag
12241: INTO P_Tax_Amt_Included
12242: FROM zx_detail_tax_lines_gt zdl
12243: WHERE zdl.application_id = 200
12244: AND zdl.entity_code = 'AP_INVOICES'
12245: AND zdl.trx_id = P_Invoice_Lines_Rec.invoice_id
12246: AND NVL(zdl.self_assessed_flag, 'N') = 'N'