[Home] [Help]
204: AND uba.cust_account_id = cas.cust_account_id
205: AND uba.acct_site_use_id = su.site_use_id
206: AND uba.payment_function = 'CUSTOMER_PAYMENT'
207: AND uba.instrument_type = 'CREDITCARD'
208: AND IBY_CC_SECURITY_PUB.get_segment_id(OE_Payment_Data_Migration_Util.Strip_Non_Numeric_Char(ooh.credit_card_number))
209: = seg.sec_segment_id --6757060
210: AND (seg.cc_number_hash1 = cc.cc_number_hash1
211: AND seg.cc_number_hash2 = cc.cc_number_hash2)
212: AND cc.instrid = uba.instrument_id
292: AND uba.payment_function = 'CUSTOMER_PAYMENT'
293: AND uba.instrument_type = 'CREDITCARD'
294: AND op.payment_type_code = 'CREDIT_CARD'
295: AND op.credit_card_number IS NOT NULL
296: AND IBY_CC_SECURITY_PUB.get_segment_id(OE_Payment_Data_Migration_Util.Strip_Non_Numeric_Char(op.credit_card_number))
297: = seg.sec_segment_id --6757060
298: AND (seg.cc_number_hash1 = cc.cc_number_hash1
299: AND seg.cc_number_hash2 = cc.cc_number_hash2)
300: AND cc.instrid = uba.instrument_id
416: ext_party_id_tab.delete ;
417: trxn_entity_id_tab.delete ;
418:
419: BEGIN --6757060
420: IF NOT iby_cc_security_pub.encryption_enabled() THEN
421: OPEN payments_cur1(l_start_rowid, l_end_rowid, l_cutoff_date) ;
422:
423: FETCH payments_cur1 BULK COLLECT INTO
424: header_id_tab,
651: instr_assignment_id_tab.delete ;
652: ext_party_id_tab.delete ;
653: trxn_entity_id_tab.delete ;
654:
655: IF NOT iby_cc_security_pub.encryption_enabled() THEN
656: OPEN payments_cur2(l_start_rowid, l_end_rowid, l_cutoff_date) ;
657:
658: FETCH payments_cur2 BULK COLLECT INTO
659: header_id_tab,