DBA Data[Home] [Help]

APPS.ZX_TDS_APPLICABILITY_DETM_PKG dependencies on ZX_REGIMES_B_V

Line 265: FROM ZX_REGIMES_B_V r

261: geography_type,
262: geography_id,
263: effective_from,
264: effective_to
265: FROM ZX_REGIMES_B_V r
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

Line 288: FROM ZX_REGIMES_B_V regime,

284: geography_type,
285: geography_id,
286: effective_from,
287: effective_to
288: FROM ZX_REGIMES_B_V regime,
289: hz_relationships relation
290: WHERE relation.object_id = c_geography_id
291: AND relation.object_type = 'COUNTRY'
292: AND relation.subject_id = regime.geography_id