APPS.ZX_TDS_APPLICABILITY_DETM_PKG dependencies on ZX_SCO_TAXES_B_V

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 8012: FROM ZX_SCO_TAXES_B_V tax

8008: -- case,w e should consider the tax rate if jurisdiction matches. i-- Jurisdiction match will be checked when place of supply is
8009: -- validated.
8010: -- AND rt.tax_jurisdiction_code is NULL
8011: AND EXISTS (SELECT 1
8012: FROM ZX_SCO_TAXES_B_V tax
8013: WHERE tax.tax_regime_code = rt.tax_regime_code
8014: AND tax.tax = rt.tax
8015: AND tax.live_for_processing_flag = 'Y'
8016: AND tax.live_for_applicability_flag = 'Y');

Line 8098: FROM ZX_SCO_TAXES_B_V

8094: zone_geography_type,
8095: override_geography_type,
8096: allow_rounding_override_flag,
8097: tax_account_source_tax
8098: FROM ZX_SCO_TAXES_B_V
8099: WHERE tax = c_tax
8100: AND tax_regime_code = c_tax_regime_code
8101: AND (effective_from <= c_tax_determine_date AND
8102: (effective_to >= c_tax_determine_date OR effective_to IS NULL))

Line 8454: FROM ZX_SCO_TAXES_B_V tax

8450: OR rt.effective_to IS NULL )
8451: AND rt.Active_Flag = 'Y'
8452: AND (rt.tax_class = l_tax_class or rt.tax_class IS NULL)
8453: AND EXISTS (SELECT 1
8454: FROM ZX_SCO_TAXES_B_V tax
8455: WHERE tax.tax_regime_code = rt.tax_regime_code
8456: AND tax.tax = rt.tax
8457: AND tax.live_for_processing_flag = 'Y'
8458: AND tax.live_for_applicability_flag = 'Y');