APPS.ZX_SBSCR_OPTIONS_MIGRATE_PKG dependencies on ZX_SUBSCRIPTION_OPTIONS

Line 74: INSERT INTO ZX_SUBSCRIPTION_OPTIONS (

70: AND ru.tax_regime_id = regime.tax_regime_id)
71: );
72:
73:
74: INSERT INTO ZX_SUBSCRIPTION_OPTIONS (
75: SUBSCRIPTION_OPTION_ID,
76: REGIME_USAGE_ID,
77: SUBSCRIPTION_OPTION_CODE,
78: PARENT_FIRST_PTY_ORG_ID,

Line 91: SELECT ZX_SUBSCRIPTION_OPTIONS_S.nextval,

87: LAST_UPDATE_DATE,
88: LAST_UPDATED_BY,
89: LAST_UPDATE_LOGIN
90: )
91: SELECT ZX_SUBSCRIPTION_OPTIONS_S.nextval,
92: ru.regime_usage_id,
93: 'OWN_GCO',
94: NULL,
95: regime.effective_from,

Line 111: FROM ZX_SUBSCRIPTION_OPTIONS opt

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
112: WHERE opt.regime_usage_id = ru.regime_usage_id
113: ) ;
114:
115:

Line 147: ZX_SUBSCRIPTION_OPTIONS opt

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
151: FROM ZX_SUBSCRIPTION_DETAILS det

Line 235: ZX_SUBSCRIPTION_OPTIONS opt

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
239: WHERE det.first_pty_org_id = ru.first_pty_org_id

Line 278: ZX_SUBSCRIPTION_OPTIONS opt

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
282: FROM ZX_SUBSCRIPTION_DETAILS det