APPS.OE_PAYMENT_DATA_MIGRATION_UTIL dependencies on IBY_CREDITCARD

Line 227: iby_creditcard cc

223: hz_cust_acct_sites_all cas,
224: iby_trans_all_v ita,
225: iby_upg_instruments uba,
226: iby_security_segments seg,
227: iby_creditcard cc
228: WHERE ooh.open_flag = 'N'
229: AND ooh.payment_type_code = 'CREDIT_CARD'
230: AND ooh.ordered_date >= l_cutoff_date
231: AND NOT EXISTS ( SELECT 'Y'

Line 315: iby_creditcard cc

311: iby_trans_all_v ita,
312: iby_upg_instruments uba,
313: oe_payments op,
314: iby_security_segments seg,
315: iby_creditcard cc
316: WHERE ooh.open_flag = 'N'
317: AND ooh.ordered_date >= l_cutoff_date
318: AND ooh.header_id = op.header_id
319: AND op.trxn_extension_id is null

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

395: fnd_file.put_line(FND_FILE.OUTPUT, 'Concurrent Program Parameters');
396: fnd_file.put_line(FND_FILE.OUTPUT, 'Batch Size : '|| X_batch_size);
397: fnd_file.put_line(FND_FILE.OUTPUT, 'Number of Threads : '|| X_Num_Workers);
398:
399: l_cutoff_date := NVL(fnd_profile.value('IBY_CREDITCARD_CUTOFF_DATE'), to_date('01/01/1000', 'DD/MM/YYYY')) ;
400:
401: -- migrate data in oe_oe_order_headers_all and not exist in oe_payments
402: BEGIN
403: -----------------------------------------------------------