DBA Data[Home] [Help]

APPS.ZX_TRL_DETAIL_OVERRIDE_PKG dependencies on ZX_RATES_B

Line 386: from zx_rates_b

382:
383: IF nvl(l_offset_tax_flag,'N') <> 'Y' THEN
384: select offset_tax_rate_code, 'N'
385: INTO l_offset_tax_rate_code, l_offset_flag
386: from zx_rates_b
387: where tax_rate_id = p_tax_rate_id
388: and p_tax_determine_date between effective_from and
389: nvl(effective_to,p_tax_determine_date);
390: ELSE

Line 3056: FROM zx_rates_b

3052: THEN
3053: BEGIN
3054: SELECT allow_adhoc_tax_rate_flag, adj_for_adhoc_amt_code
3055: INTO l_allow_adhoc_tax_rate_flag, l_adj_for_adhoc_amt_code
3056: FROM zx_rates_b
3057: WHERE tax_rate_id = p_tax_rate_id;
3058: EXCEPTION
3059: WHEN OTHERS THEN
3060: NULL;