46: regime.tax_regime_code TAX_REGIME_CODE,
47: 'MIGRATED',
48: 1,
49: SYSDATE ,
50: fnd_global.user_id ,
51: SYSDATE ,
52: fnd_global.user_id ,
53: fnd_global.conc_login_id
54: FROM ZX_REGIMES_B regime,
48: 1,
49: SYSDATE ,
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
49: SYSDATE ,
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
98: 'N',
99: 'MIGRATED',
100: 'OWN_ONLY',
101: SYSDATE ,
102: fnd_global.user_id ,
103: SYSDATE ,
104: fnd_global.user_id ,
105: fnd_global.conc_login_id
106: FROM ZX_REGIMES_B regime,
100: 'OWN_ONLY',
101: SYSDATE ,
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
101: SYSDATE ,
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'
138: opt.effective_from,
139: opt.effective_to,
140: 'MIGRATED',
141: SYSDATE ,
142: fnd_global.user_id ,
143: SYSDATE ,
144: fnd_global.user_id ,
145: fnd_global.conc_login_id
146: FROM ZX_REGIMES_USAGES ru,
140: 'MIGRATED',
141: SYSDATE ,
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
141: SYSDATE ,
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'
182: zrb.effective_from,
183: zrb.effective_to,
184: 'MIGRATED',
185: SYSDATE ,
186: fnd_global.user_id ,
187: SYSDATE ,
188: fnd_global.user_id ,
189: fnd_global.conc_login_id
190: FROM ZX_REGIMES_B zrb
184: 'MIGRATED',
185: SYSDATE ,
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'
185: SYSDATE ,
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
269: opt.effective_from,
270: opt.effective_to,
271: 'MIGRATED',
272: SYSDATE ,
273: fnd_global.user_id ,
274: SYSDATE ,
275: fnd_global.user_id ,
276: fnd_global.conc_login_id
277: FROM ZX_REGIMES_USAGES ru,
271: 'MIGRATED',
272: SYSDATE ,
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
272: SYSDATE ,
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'