DBA Data[Home] [Help]

APPS.ZX_SBSCR_OPTIONS_MIGRATE_PKG dependencies on FND_GLOBAL

Line 50: fnd_global.user_id ,

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,

Line 52: fnd_global.user_id ,

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

Line 53: fnd_global.conc_login_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

Line 102: fnd_global.user_id ,

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,

Line 104: fnd_global.user_id ,

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

Line 105: fnd_global.conc_login_id

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'

Line 142: fnd_global.user_id ,

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,

Line 144: fnd_global.user_id ,

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

Line 145: fnd_global.conc_login_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'

Line 186: fnd_global.user_id ,

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

Line 188: fnd_global.user_id ,

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'

Line 189: fnd_global.conc_login_id

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

Line 273: fnd_global.user_id ,

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,

Line 275: fnd_global.user_id ,

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

Line 276: fnd_global.conc_login_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'