APPS.ZX_SBSCR_OPTIONS_MIGRATE_PKG dependencies on ZX_REGIMES_USAGES

Line 29: INSERT INTO ZX_REGIMES_USAGES (

25: END IF;
26:
27: x_return_status := FND_API.G_RET_STS_SUCCESS;
28:
29: INSERT INTO ZX_REGIMES_USAGES (
30: REGIME_USAGE_ID,
31: FIRST_PTY_ORG_ID,
32: TAX_REGIME_ID,
33: TAX_REGIME_CODE,

Line 43: ZX_REGIMES_USAGES_S.NEXTVAL,

39: LAST_UPDATED_BY,
40: LAST_UPDATE_LOGIN
41: )
42: SELECT
43: ZX_REGIMES_USAGES_S.NEXTVAL,
44: ptp.party_tax_profile_id CONTENT_OWNER_ID,
45: regime.tax_regime_id TAX_REGIME_ID,
46: regime.tax_regime_code TAX_REGIME_CODE,
47: 'MIGRATED',

Line 66: FROM zx_regimes_usages ru

62: AND ptp.party_type_code = 'OU'
63: AND regime.record_type_code = 'MIGRATED'
64: AND ptp.record_type_code = 'MIGRATED'
65: AND NOT EXISTS ( SELECT 1
66: FROM zx_regimes_usages ru
67: WHERE (ru.FIRST_PTY_ORG_ID = ptp.party_tax_profile_id
68: AND ru.tax_regime_code = regime.tax_regime_code)
69: OR (ru.FIRST_PTY_ORG_ID = ptp.party_tax_profile_id
70: AND ru.tax_regime_id = regime.tax_regime_id)

Line 107: ZX_REGIMES_USAGES ru

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
111: FROM ZX_SUBSCRIPTION_OPTIONS opt

Line 146: FROM ZX_REGIMES_USAGES ru,

142: fnd_global.user_id ,
143: SYSDATE ,
144: fnd_global.user_id ,
145: fnd_global.conc_login_id
146: FROM ZX_REGIMES_USAGES ru,
147: ZX_SUBSCRIPTION_OPTIONS opt
148: WHERE ru.regime_usage_id = opt.regime_usage_id
149: AND opt.record_type_code = 'MIGRATED'
150: AND NOT EXISTS (SELECT 1

Line 234: FROM ZX_REGIMES_USAGES ru,

230: ru.created_by,
231: ru.last_update_date,
232: ru.last_updated_by,
233: ru.last_update_login
234: FROM ZX_REGIMES_USAGES ru,
235: ZX_SUBSCRIPTION_OPTIONS opt
236: WHERE ru.regime_usage_id = opt.regime_usage_id
237: AND NOT EXISTS (SELECT 1
238: FROM ZX_SUBSCRIPTION_DETAILS det

Line 277: FROM ZX_REGIMES_USAGES ru,

273: fnd_global.user_id ,
274: SYSDATE ,
275: fnd_global.user_id ,
276: fnd_global.conc_login_id
277: FROM ZX_REGIMES_USAGES ru,
278: ZX_SUBSCRIPTION_OPTIONS opt
279: WHERE ru.regime_usage_id = opt.regime_usage_id
280: AND opt.record_type_code = 'MIGRATED'
281: AND NOT EXISTS (SELECT 1

Line 298: FROM ZX_REGIMES_USAGES RU,

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,
300: AR_SYSTEM_PARAMETERS_ALL ARSYS
301: WHERE PTP.PARTY_TAX_PROFILE_ID = RU.FIRST_PTY_ORG_ID
302: AND PTP.PARTY_TYPE_CODE = 'OU'

Line 311: FROM ZX_REGIMES_USAGES RU,

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,
313: AR_SYSTEM_PARAMETERS_ALL ARSYS
314: WHERE PTP.PARTY_TAX_PROFILE_ID = RU.FIRST_PTY_ORG_ID
315: AND PTP.PARTY_TYPE_CODE = 'OU'