DBA Data[Home] [Help]

APPS.AP_ETAX_SERVICES_PKG dependencies on ZX_DETAIL_TAX_LINES_GT

Line 9290: FROM zx_detail_tax_lines_gt zdl

9286: l_api_name CONSTANT VARCHAR2(200) := 'Calculate_Quote';
9287:
9288: CURSOR c_tax_amount IS
9289: SELECT SUM(NVL(zdl.tax_amt,0))
9290: FROM zx_detail_tax_lines_gt zdl
9291: WHERE zdl.application_id = 200
9292: AND zdl.entity_code = 'AP_INVOICES'
9293: AND zdl.trx_id = P_Invoice_Lines_Rec.invoice_id
9294: AND NVL(zdl.self_assessed_flag, 'N') = 'N'

Line 9639: FROM zx_detail_tax_lines_gt zdl

9635: -----------------------------------------------------------------
9636:
9637: SELECT distinct zdl.tax_amt_included_flag
9638: INTO P_Tax_Amt_Included
9639: FROM zx_detail_tax_lines_gt zdl
9640: WHERE zdl.application_id = 200
9641: AND zdl.entity_code = 'AP_INVOICES'
9642: AND zdl.trx_id = P_Invoice_Lines_Rec.invoice_id
9643: AND NVL(zdl.self_assessed_flag, 'N') = 'N'