APPS.ZX_TDS_APPLICABILITY_DETM_PKG dependencies on ZX_SCO_TAXES

Line 270: FROM ZX_SCO_TAXES_B_V t

266: WHERE country_code = p_country_code
267: AND (p_tax_determine_date >= effective_from AND
268: (p_tax_determine_date <= effective_to OR effective_to IS NULL))
269: AND EXISTS (SELECT /*+ no_unnest */ 1
270: FROM ZX_SCO_TAXES_B_V t
271: WHERE t.tax_regime_code = r.tax_regime_code
272: AND t.live_for_processing_flag = 'Y'
273: AND t.live_for_applicability_flag = 'Y'
274: AND (p_tax_determine_date >= t.effective_from AND

Line 299: FROM ZX_SCO_TAXES_B_V tax

295: AND (c_date <= relation.end_date OR relation.end_date IS NULL)
296: AND (c_date >= regime.effective_from AND
297: (c_date <= regime.effective_to OR regime.effective_to IS NULL))
298: AND EXISTS (SELECT /*+ no_unnest */ 1
299: FROM ZX_SCO_TAXES_B_V tax
300: WHERE tax.tax_regime_code = regime.tax_regime_code
301: AND tax.live_for_processing_flag = 'Y'
302: AND tax.live_for_applicability_flag = 'Y'
303: AND (c_date >= tax.effective_from AND

Line 2447: FROM ZX_SCO_TAXES zxt

2443: zone_geography_type,
2444: override_geography_type,
2445: allow_rounding_override_flag,
2446: tax_account_source_tax
2447: FROM ZX_SCO_TAXES zxt
2448: WHERE zxt.tax_regime_code = p_tax_regime_code
2449: AND live_for_processing_flag = 'Y'
2450: AND live_for_applicability_flag = 'Y'
2451: AND ( p_tax_determine_date >= effective_from AND

Line 6902: zx_sco_taxes zxt,

6898: zxt.override_geography_type,
6899: zxt.allow_rounding_override_flag,
6900: zxt.tax_account_source_tax
6901: FROM zx_sco_account_rates zxtr,
6902: zx_sco_taxes zxt,
6903: fnd_lookups lc
6904: WHERE zxtr.content_owner_id = p_event_class_rec.first_pty_org_id
6905: AND zxtr.ledger_id =
6906: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ledger_id(p_trx_line_index)

Line 8617: ZX_SCO_TAXES_B_V tax

8613: 1 query_num,
8614: tax.compounding_precedence
8615: FROM ZX_PROCESS_RESULTS pr,
8616: ZX_SCO_RULES_B_V rl,
8617: ZX_SCO_TAXES_B_V tax
8618: --ZX_SCO_RATES_B_V rt
8619: WHERE (pr.CONDITION_GROUP_CODE in (c_condition_group_code
8620: , decode(c_tax_class,'OUTPUT',substrb(c_tax_rate_code,1,45)||'-'||'XOP'
8621: ,'INPUT' ,substrb(c_tax_rate_code,1,45)||'-'||'XIP'

Line 8660: ZX_SCO_TAXES_B_V tax

8656: NULL result_id,
8657: 2 query_num,
8658: tax.compounding_precedence
8659: FROM ZX_SCO_RATES_B_V rt,
8660: ZX_SCO_TAXES_B_V tax
8661: WHERE rt.tax_rate_code = c_tax_rate_code
8662: AND rt.rate_type_code <> 'RECOVERY'
8663: AND rt.effective_from <= c_tax_determine_date
8664: AND (rt.effective_to >= c_tax_determine_date OR rt.effective_to IS NULL )

Line 8760: FROM ZX_SCO_TAXES_B_V

8756: zone_geography_type,
8757: override_geography_type,
8758: allow_rounding_override_flag,
8759: tax_account_source_tax
8760: FROM ZX_SCO_TAXES_B_V
8761: WHERE tax = c_tax
8762: AND tax_regime_code = c_tax_regime_code
8763: AND (effective_from <= c_tax_determine_date AND
8764: (effective_to >= c_tax_determine_date OR effective_to IS NULL))

Line 9118: FROM ZX_SCO_TAXES_B_V tax

9114: OR rt.effective_to IS NULL )
9115: AND rt.Active_Flag = 'Y'
9116: AND (rt.tax_class = l_tax_class or rt.tax_class IS NULL)
9117: AND EXISTS (SELECT 1
9118: FROM ZX_SCO_TAXES_B_V tax
9119: WHERE tax.tax_regime_code = rt.tax_regime_code
9120: AND tax.tax = rt.tax
9121: AND tax.live_for_processing_flag = 'Y'
9122: AND tax.live_for_applicability_flag = 'Y');