APPS.ZX_SBSCR_OPTIONS_MIGRATE_PKG dependencies on ZX_REGIMES_B

Line 54: FROM ZX_REGIMES_B regime,

50: fnd_global.user_id ,
51: SYSDATE ,
52: fnd_global.user_id ,
53: fnd_global.conc_login_id
54: FROM ZX_REGIMES_B regime,
55: ZX_PARTY_TAX_PROFILE ptp,
56: ( SELECT decode(l_multi_org_flag,'N',l_org_id,org_id) org_id
57: FROM ap_tax_codes_all
58: UNION

Line 106: FROM ZX_REGIMES_B regime,

102: fnd_global.user_id ,
103: SYSDATE ,
104: fnd_global.user_id ,
105: fnd_global.conc_login_id
106: FROM ZX_REGIMES_B regime,
107: ZX_REGIMES_USAGES ru
108: WHERE regime.tax_regime_code = ru.tax_regime_code
109: AND ru.record_type_code = 'MIGRATED'
110: AND NOT EXISTS (SELECT 1

Line 190: FROM ZX_REGIMES_B zrb

186: fnd_global.user_id ,
187: SYSDATE ,
188: fnd_global.user_id ,
189: fnd_global.conc_login_id
190: FROM ZX_REGIMES_B zrb
191: WHERE NVL(zrb.has_sub_regime_flag,'N') = 'N'
192: AND zrb.record_type_code = 'MIGRATED'
193: AND NOT EXISTS (SELECT 1
194: FROM ZX_SUBSCRIPTION_DETAILS det

Line 295: UPDATE ZX_REGIMES_B

291: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'()-');
292: END IF;
293:
294: /*Bug 5204559*/
295: UPDATE ZX_REGIMES_B
296: SET ALLOW_EXEMPTIONS_FLAG = 'Y'
297: WHERE TAX_REGIME_ID IN (SELECT distinct RU.TAX_REGIME_ID
298: FROM ZX_REGIMES_USAGES RU,
299: ZX_PARTY_TAX_PROFILE PTP,

Line 308: UPDATE ZX_REGIMES_B

304: AND nvl(ARSYS.TAX_USE_CUSTOMER_EXEMPT_FLAG,'N') = 'Y'
305: AND PTP.RECORD_TYPE_CODE = 'MIGRATED')
306: AND RECORD_TYPE_CODE = 'MIGRATED';
307:
308: UPDATE ZX_REGIMES_B
309: SET ALLOW_EXCEPTIONS_FLAG = 'Y'
310: WHERE TAX_REGIME_ID IN (SELECT TAX_REGIME_ID
311: FROM ZX_REGIMES_USAGES RU,
312: ZX_PARTY_TAX_PROFILE PTP,