APPS.ZX_TRL_DETAIL_OVERRIDE_PKG dependencies on ZX_RATES_B

Line 384: FROM zx_rates_b

380:
381: IF nvl(l_offset_tax_flag,'N') <> 'Y' THEN
382: SELECT offset_tax_rate_code, 'N'
383: INTO l_offset_tax_rate_code, l_offset_flag
384: FROM zx_rates_b
385: WHERE tax_rate_id = p_tax_rate_id
386: AND p_tax_determine_date BETWEEN effective_from AND
387: nvl(effective_to,p_tax_determine_date);
388: ELSE

Line 397: FROM zx_rates_b

393: END;
394:
395: --Bug 13724999
396: SELECT rate_type_code INTO l_tax_rate_type
397: FROM zx_rates_b
398: WHERE tax_rate_id = p_tax_rate_id;
399: --Bug 13724999
400: END IF;
401:

Line 3044: FROM zx_rates_b

3040: THEN
3041: BEGIN
3042: SELECT allow_adhoc_tax_rate_flag, adj_for_adhoc_amt_code
3043: INTO l_allow_adhoc_tax_rate_flag, l_adj_for_adhoc_amt_code
3044: FROM zx_rates_b
3045: WHERE tax_rate_id = p_tax_rate_id;
3046: EXCEPTION
3047: WHEN OTHERS THEN
3048: NULL;