APPS.IBY_HASH_REGENERATOR dependencies on IBY_SYS_SECURITY_SUBKEYS

Line 88: iby_sys_security_subkeys bak,

84: b.iban iban2
85: FROM
86: iby_ext_bank_accounts b,
87: iby_security_segments bas,
88: iby_sys_security_subkeys bak,
89: iby_security_segments ibs,
90: iby_sys_security_subkeys ibk
91: WHERE
92: (b.ba_num_sec_segment_id = bas.sec_segment_id(+))

Line 90: iby_sys_security_subkeys ibk

86: iby_ext_bank_accounts b,
87: iby_security_segments bas,
88: iby_sys_security_subkeys bak,
89: iby_security_segments ibs,
90: iby_sys_security_subkeys ibk
91: WHERE
92: (b.ba_num_sec_segment_id = bas.sec_segment_id(+))
93: AND (bas.sec_subkey_id = bak.sec_subkey_id(+))
94: AND (b.iban_sec_segment_id = ibs.sec_segment_id(+))

Line 108: iby_sys_security_subkeys k,

104: i.digit_check_flag) credit_card_number,
105: tx.instrnumber credit_card_number2
106: FROM iby_trxn_summaries_all tx,
107: iby_security_segments seg,
108: iby_sys_security_subkeys k,
109: iby_cc_issuer_ranges r,
110: iby_creditcard_issuers_b i
111: WHERE (NOT instrnum_sec_segment_id IS NULL)
112: AND (tx.instrnum_sec_segment_id = seg.sec_segment_id(+))

Line 143: iby_sys_security_subkeys bak

139: bas.segment_cipher_text, bas.encoding_scheme, NULL, NULL ) bank_account_number,
140: tx.instrnumber bank_account_number2
141: FROM iby_trxn_summaries_all tx,
142: iby_security_segments bas,
143: iby_sys_security_subkeys bak
144: WHERE (NOT instrnum_sec_segment_id IS NULL)
145: AND tx.instrnum_sec_segment_id = bas.sec_segment_id(+)
146: AND bas.sec_subkey_id = bak.sec_subkey_id(+)
147: AND tx.instrtype = 'BANKACCOUNT'