DBA Data[Home] [Help]

APPS.IBY_HASH_REGENERATOR dependencies on IBY_EXT_BANKACCT_PUB

Line 61: iby_ext_bankacct_pub.uncipher_bank_number

57:
58: CURSOR get_bank_accounts(p_sys_key iby_view_parameters_gt.value%TYPE) IS
59: SELECT
60: b.ext_bank_account_id ext_bank_account_id,
61: iby_ext_bankacct_pub.uncipher_bank_number
62: (
63: b.bank_account_num,
64: b.ba_num_sec_segment_id,
65: p_sys_key,

Line 73: iby_ext_bankacct_pub.Uncipher_Bank_Number

69: b.ba_mask_setting,
70: b.ba_unmask_length
71: ) bank_account_number,
72: b.bank_account_num bank_account_number2,
73: iby_ext_bankacct_pub.Uncipher_Bank_Number
74: (
75: b.iban,
76: b.iban_sec_segment_id,
77: p_sys_key,

Line 137: iby_ext_bankacct_pub.uncipher_bank_number (

133: AND tx.instrtype = 'BANKACCOUNT'
134: AND tx.instrnumber IS NOT NULL
135: UNION
136: SELECT tx.trxnmid trxnmid,
137: iby_ext_bankacct_pub.uncipher_bank_number (
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,