APPS.IBY_HASH_REGENERATOR dependencies on IBY_SECURITY_SEGMENTS

Line 87: iby_security_segments bas,

83: ) iban,
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

Line 89: iby_security_segments ibs,

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(+))
93: AND (bas.sec_subkey_id = bak.sec_subkey_id(+))

Line 107: iby_security_segments seg,

103: r.card_number_prefix, NVL(r.card_number_length,tx.instrnum_length),
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)

Line 142: iby_security_segments bas,

138: tx.instrnumber, tx.instrnum_sec_segment_id, p_sys_key, bak.subkey_cipher_text,
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(+)