DBA Data[Home] [Help]

APPS.ZX_GL_TAX_OPTIONS_PKG dependencies on ZX_TAXES_B

Line 831: zx_taxes_b taxes

827: IS
828: SELECT rates.tax_rate_id,
829: rates.tax_class
830: FROM zx_sco_rates rates,
831: zx_taxes_b taxes
832: WHERE rates.tax_rate_code = p_tax_rate_code
833: AND p_trx_date >= rates.effective_from
834: AND p_trx_date <= NVL(rates.effective_to, p_trx_date)
835: AND nvl(rates.active_flag,'Y') = 'Y'

Line 856: zx_taxes_b taxes

852: p_trx_date DATE)
853: IS
854: SELECT rates.tax_rate_id
855: FROM zx_sco_rates rates,
856: zx_taxes_b taxes
857: WHERE rates.tax_rate_code = p_tax_rate_code
858: AND p_trx_date >= rates.effective_from
859: AND p_trx_date <= NVL(rates.effective_to, p_trx_date)
860: AND nvl(rates.active_flag,'Y') = 'Y'