APPS.ZX_SBSCR_OPTIONS_MIGRATE_PKG dependencies on ZX_SUBSCRIPTION_DETAILS

Line 116: INSERT INTO ZX_SUBSCRIPTION_DETAILS (

112: WHERE opt.regime_usage_id = ru.regime_usage_id
113: ) ;
114:
115:
116: INSERT INTO ZX_SUBSCRIPTION_DETAILS (
117: SUBSCRIPTION_DETAIL_ID,
118: SUBSCRIPTION_OPTION_ID,
119: FIRST_PTY_ORG_ID,
120: PARENT_FIRST_PTY_ORG_ID,

Line 132: SELECT ZX_SUBSCRIPTION_DETAILS_S.nextval,

128: LAST_UPDATE_DATE,
129: LAST_UPDATED_BY,
130: LAST_UPDATE_LOGIN
131: )
132: SELECT ZX_SUBSCRIPTION_DETAILS_S.nextval,
133: opt.subscription_option_id,
134: ru.first_pty_org_id,
135: ru.first_pty_org_id,
136: 'VFC',

Line 151: FROM ZX_SUBSCRIPTION_DETAILS det

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
152: WHERE det.first_pty_org_id = ru.first_pty_org_id
153: AND det.parent_first_pty_org_id = ru.first_pty_org_id
154: AND det.tax_regime_code = ru.tax_regime_code
155: AND det.view_options_code = 'VFC'

Line 160: INSERT INTO ZX_SUBSCRIPTION_DETAILS (

156: AND det.effective_from = opt.effective_from
157: );
158:
159: /* Insert a row for every regime */
160: INSERT INTO ZX_SUBSCRIPTION_DETAILS (
161: SUBSCRIPTION_DETAIL_ID,
162: SUBSCRIPTION_OPTION_ID,
163: FIRST_PTY_ORG_ID,
164: PARENT_FIRST_PTY_ORG_ID,

Line 176: SELECT ZX_SUBSCRIPTION_DETAILS_S.nextval,

172: LAST_UPDATE_DATE,
173: LAST_UPDATED_BY,
174: LAST_UPDATE_LOGIN
175: )
176: SELECT ZX_SUBSCRIPTION_DETAILS_S.nextval,
177: 0,
178: -99,
179: -99,
180: 'VFC',

Line 194: FROM ZX_SUBSCRIPTION_DETAILS det

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
195: WHERE det.first_pty_org_id = -99
196: AND det.parent_first_pty_org_id = -99
197: AND det.tax_regime_code = zrb.tax_regime_code
198: AND det.view_options_code = 'VFC'

Line 204: INSERT INTO ZX_SUBSCRIPTION_DETAILS (

200: );
201:
202: /** VFD row not insrted for OWN_GCO case now
203:
204: INSERT INTO ZX_SUBSCRIPTION_DETAILS (
205: SUBSCRIPTION_DETAIL_ID,
206: SUBSCRIPTION_OPTION_ID,
207: FIRST_PTY_ORG_ID,
208: PARENT_FIRST_PTY_ORG_ID,

Line 220: SELECT ZX_SUBSCRIPTION_DETAILS_S.nextval,

216: LAST_UPDATE_DATE,
217: LAST_UPDATED_BY,
218: LAST_UPDATE_LOGIN
219: )
220: SELECT ZX_SUBSCRIPTION_DETAILS_S.nextval,
221: opt.subscription_option_id,
222: ru.first_pty_org_id,
223: -99,
224: 'VFD',

Line 238: FROM ZX_SUBSCRIPTION_DETAILS det

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
240: AND det.parent_first_pty_org_id = -99
241: AND det.tax_regime_code = ru.tax_regime_code
242: AND det.view_options_code = 'VFD'

Line 247: INSERT INTO ZX_SUBSCRIPTION_DETAILS (

243: AND det.effective_from = opt.effective_from
244: );
245: **/
246:
247: INSERT INTO ZX_SUBSCRIPTION_DETAILS (
248: SUBSCRIPTION_DETAIL_ID,
249: SUBSCRIPTION_OPTION_ID,
250: FIRST_PTY_ORG_ID,
251: PARENT_FIRST_PTY_ORG_ID,

Line 263: SELECT ZX_SUBSCRIPTION_DETAILS_S.nextval,

259: LAST_UPDATE_DATE,
260: LAST_UPDATED_BY,
261: LAST_UPDATE_LOGIN
262: )
263: SELECT ZX_SUBSCRIPTION_DETAILS_S.nextval,
264: opt.subscription_option_id,
265: ru.first_pty_org_id,
266: -99,
267: 'VFR',

Line 282: FROM ZX_SUBSCRIPTION_DETAILS det

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
283: WHERE det.first_pty_org_id = ru.first_pty_org_id
284: AND det.parent_first_pty_org_id = -99
285: AND det.tax_regime_code = ru.tax_regime_code
286: AND det.view_options_code = 'VFR'