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'
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'