[Home] [Help]
120: -- get_tax_rate_by_jur_gt
121: --
122: -- DESCRIPTION
123: -- This procedure find tax rate information match the passed in tax
124: -- information and the jurisdiction info in zx_jurisdictions_gt
125: ------------------------------------------------------------------------------
126: PROCEDURE get_tax_rate_by_jur_gt(
127: p_tax_class IN VARCHAR2,
128: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,
163: rate.taxable_basis_formula_code,
164: rate.adj_for_adhoc_amt_code,
165: rate.inclusive_tax_flag,
166: rate.tax_class
167: FROM ZX_SCO_RATES_B_V rate, ZX_JURISDICTIONS_GT jur
168: WHERE rate.tax_jurisdiction_code = jur.tax_jurisdiction_code
169: AND rate.tax = jur.tax
170: AND rate.tax_regime_code = jur.tax_regime_code
171: AND rate.effective_from <= p_tax_date
202: taxable_basis_formula_code,
203: adj_for_adhoc_amt_code,
204: inclusive_tax_flag,
205: tax_class
206: FROM ZX_SCO_RATES_B_V rate, ZX_JURISDICTIONS_GT jur
207: WHERE rate.tax_jurisdiction_code = jur.tax_jurisdiction_code
208: AND rate.tax = jur.tax
209: AND rate.tax_regime_code = jur.tax_regime_code
210: AND rate.effective_from <= p_tax_date
236: -- p_tax,
237: -- p_tax_status_code,
238: -- p_tax_rate_code,
239: -- p_tax_date
240: -- and jurisdiction info in zx_jurisdictions_gt to
241: -- get the tax rate information from zx_rates_b
242: --
243: OPEN get_tax_rate_csr;
244:
381: -- get_def_tax_rate_by_jur_gt
382: --
383: -- DESCRIPTION
384: -- This procedure find tax rate information match the passed in tax
385: -- information and the jurisdiction info in zx_jurisdictions_gt
386: ------------------------------------------------------------------------------
387: PROCEDURE get_def_tax_rate_by_jur_gt(
388: p_tax_class IN VARCHAR2,
389: p_tax_regime_code IN ZX_RATES_B.tax_regime_code%TYPE,
423: taxable_basis_formula_code,
424: adj_for_adhoc_amt_code,
425: inclusive_tax_flag,
426: tax_class
427: FROM ZX_SCO_RATES_B_V rate, ZX_JURISDICTIONS_GT jur
428: WHERE rate.tax_jurisdiction_code = jur.tax_jurisdiction_code
429: AND rate.tax = jur.tax
430: AND rate.tax_regime_code = jur.tax_regime_code
431: AND rate.tax_status_code = p_tax_status_code
463: taxable_basis_formula_code,
464: adj_for_adhoc_amt_code,
465: inclusive_tax_flag,
466: tax_class
467: FROM ZX_SCO_RATES_B_V rate, ZX_JURISDICTIONS_GT jur
468: WHERE rate.tax_jurisdiction_code = jur.tax_jurisdiction_code
469: AND rate.tax = jur.tax
470: AND rate.tax_regime_code = jur.tax_regime_code
471: AND rate.tax_status_code = p_tax_status_code
2237: END IF;
2238:
2239:
2240: -- for general create and update case
2241: -- the ZX_JURISDICTIONS_GT will be populated if multiple jurisdictions found
2242: -- for jurisdiction code overriden case
2243: -- the p_multiple_jurisdictions_flag will be set to 'N' from the UI
2244: -- for other override case. eg. status / rate code override.
2245: -- global jurisdiction table: ZX_JURISDICTIONS_GT is empty need to call tcm API
2241: -- the ZX_JURISDICTIONS_GT will be populated if multiple jurisdictions found
2242: -- for jurisdiction code overriden case
2243: -- the p_multiple_jurisdictions_flag will be set to 'N' from the UI
2244: -- for other override case. eg. status / rate code override.
2245: -- global jurisdiction table: ZX_JURISDICTIONS_GT is empty need to call tcm API
2246: -- to retrieve the jurisdiction info again
2247:
2248: IF p_multiple_jurisdictions_flag ='Y' THEN
2249: SELECT COUNT(*) into l_count_jur
2246: -- to retrieve the jurisdiction info again
2247:
2248: IF p_multiple_jurisdictions_flag ='Y' THEN
2249: SELECT COUNT(*) into l_count_jur
2250: FROM ZX_JURISDICTIONS_GT;
2251:
2252: IF l_count_jur = 0 THEN
2253: get_tax_rate_internal(
2254: p_event_class_rec => p_event_class_rec,