APPS.ZX_MIGRATE_REP_ENTITIES_PKG dependencies on ZX_REGIMES_B

Line 7037: zx_regimes_b zx_regimes

7033: 1 --OBJECT_VERSION_NUMBER
7034: )
7035: SELECT min(zx_rates.effective_from) effective_from
7036: FROM zx_rates_b zx_rates,
7037: zx_regimes_b zx_regimes
7038: WHERE zx_rates.tax_regime_code = zx_regimes.tax_regime_code
7039: AND zx_regimes.country_code in ('BE','CH','CZ','DE','ES','FR','HU',
7040: 'IT','KP','KR','NO','PL','PT','SK', 'IL')
7041: AND zx_rates.record_type_code = 'MIGRATED';

Line 7370: ZX_REGIMES_B reg

7366: ZX_REPORTING_TYPES_B reporting_types,
7367: ZX_REPORTING_CODES_B report_codes,
7368: ZX_RATES_B rates,
7369: -- Bug 7620818
7370: ZX_REGIMES_B reg
7371: WHERE
7372: codes.tax_id = rates.tax_rate_id
7373: AND reporting_types.reporting_type_id = report_codes.reporting_type_id
7374: AND reporting_types.reporting_type_code ='EMEA_VAT_REPORTING_TYPE'

Line 7442: ZX_REGIMES_B reg

7438: ZX_REPORTING_TYPES_B reporting_types,
7439: ZX_REPORTING_CODES_B report_codes,
7440: ZX_RATES_B rates,
7441: -- Bug 7620818
7442: ZX_REGIMES_B reg
7443: WHERE
7444: codes.vat_tax_id = rates.tax_rate_id
7445: AND reporting_types.reporting_type_id = report_codes.reporting_type_id
7446: AND reporting_types.reporting_type_code ='EMEA_VAT_REPORTING_TYPE'