eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.ARP_EXT_BANK_PKG dependencies on IBY_SECURITY_PKG

Line 709: AND bank_acct_num_hash1 = iby_security_pkg.get_hash(p_account_number, 'F')

705: IF l_bank_account_id IS NOT NULL THEN
706: -- Check whether the assignment exists already
707: SELECT count(*) INTO l_count FROM iby_fndcpt_payer_assgn_instr_v
708: WHERE cust_account_id = p_customer_id
709: AND bank_acct_num_hash1 = iby_security_pkg.get_hash(p_account_number, 'F')
710: AND bank_acct_num_hash2 = iby_security_pkg.get_hash(p_account_number, 'T')
711: AND branch_number = p_routing_number;
712:
713: IF(l_count = 0) THEN

Line 710: AND bank_acct_num_hash2 = iby_security_pkg.get_hash(p_account_number, 'T')

706: -- Check whether the assignment exists already
707: SELECT count(*) INTO l_count FROM iby_fndcpt_payer_assgn_instr_v
708: WHERE cust_account_id = p_customer_id
709: AND bank_acct_num_hash1 = iby_security_pkg.get_hash(p_account_number, 'F')
710: AND bank_acct_num_hash2 = iby_security_pkg.get_hash(p_account_number, 'T')
711: AND branch_number = p_routing_number;
712:
713: IF(l_count = 0) THEN
714: SELECT party_id INTO l_party_id