DBA Data[Home] [Help]

APPS.ZX_GL_TAX_OPTIONS_PKG dependencies on ZX_TAXES_B

Line 830: zx_taxes_b taxes

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

Line 855: zx_taxes_b taxes

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