APPS.OE_PAYMENT_DATA_MIGRATION_UTIL dependencies on IBY_CREDITCARD

Line 188: iby_creditcard cc

184: hz_cust_acct_sites_all cas,
185: iby_trans_all_v ita,
186: iby_upg_instruments uba,
187: iby_security_segments seg,
188: iby_creditcard cc
189: WHERE ooh.open_flag = 'N'
190: AND ooh.payment_type_code = 'CREDIT_CARD'
191: AND ooh.ordered_date >= l_cutoff_date
192: AND NOT EXISTS ( SELECT 'Y'

Line 276: iby_creditcard cc

272: iby_trans_all_v ita,
273: iby_upg_instruments uba,
274: oe_payments op,
275: iby_security_segments seg,
276: iby_creditcard cc
277: WHERE ooh.open_flag = 'N'
278: AND ooh.ordered_date >= l_cutoff_date
279: AND ooh.header_id = op.header_id
280: AND op.trxn_extension_id is null

Line 360: l_cutoff_date := NVL(fnd_profile.value('IBY_CREDITCARD_CUTOFF_DATE'), to_date('01/01/1000', 'DD/MM/YYYY')) ;

356: fnd_file.put_line(FND_FILE.OUTPUT, 'Concurrent Program Parameters');
357: fnd_file.put_line(FND_FILE.OUTPUT, 'Batch Size : '|| X_batch_size);
358: fnd_file.put_line(FND_FILE.OUTPUT, 'Number of Threads : '|| X_Num_Workers);
359:
360: l_cutoff_date := NVL(fnd_profile.value('IBY_CREDITCARD_CUTOFF_DATE'), to_date('01/01/1000', 'DD/MM/YYYY')) ;
361:
362: -- migrate data in oe_oe_order_headers_all and not exist in oe_payments
363: BEGIN
364: -----------------------------------------------------------