[Home] [Help]
243: AND uba.cust_account_id = cas.cust_account_id
244: AND uba.acct_site_use_id = su.site_use_id
245: AND uba.payment_function = 'CUSTOMER_PAYMENT'
246: AND uba.instrument_type = 'CREDITCARD'
247: AND IBY_CC_SECURITY_PUB.get_segment_id(OE_Payment_Data_Migration_Util.Strip_Non_Numeric_Char(ooh.credit_card_number))
248: = seg.sec_segment_id --6757060
249: AND (seg.cc_number_hash1 = cc.cc_number_hash1
250: AND seg.cc_number_hash2 = cc.cc_number_hash2)
251: AND cc.instrid = uba.instrument_id
331: AND uba.payment_function = 'CUSTOMER_PAYMENT'
332: AND uba.instrument_type = 'CREDITCARD'
333: AND op.payment_type_code = 'CREDIT_CARD'
334: AND op.credit_card_number IS NOT NULL
335: AND IBY_CC_SECURITY_PUB.get_segment_id(OE_Payment_Data_Migration_Util.Strip_Non_Numeric_Char(op.credit_card_number))
336: = seg.sec_segment_id --6757060
337: AND (seg.cc_number_hash1 = cc.cc_number_hash1
338: AND seg.cc_number_hash2 = cc.cc_number_hash2)
339: AND cc.instrid = uba.instrument_id
455: ext_party_id_tab.delete ;
456: trxn_entity_id_tab.delete ;
457:
458: BEGIN --6757060
459: IF NOT iby_cc_security_pub.encryption_enabled() THEN
460: OPEN payments_cur1(l_start_rowid, l_end_rowid, l_cutoff_date) ;
461:
462: FETCH payments_cur1 BULK COLLECT INTO
463: header_id_tab,
690: instr_assignment_id_tab.delete ;
691: ext_party_id_tab.delete ;
692: trxn_entity_id_tab.delete ;
693:
694: IF NOT iby_cc_security_pub.encryption_enabled() THEN
695: OPEN payments_cur2(l_start_rowid, l_end_rowid, l_cutoff_date) ;
696:
697: FETCH payments_cur2 BULK COLLECT INTO
698: header_id_tab,