703:
704: -- Bug 7346354 - Start
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;
761: PROCEDURE insert_acct_instr_assignment(
762: p_party_id IN NUMBER,
763: p_customer_id IN NUMBER,
764: p_instr_id IN NUMBER,
765: x_instr_assign_id OUT NOCOPY iby_fndcpt_payer_assgn_instr_v.INSTR_ASSIGNMENT_ID%TYPE,
766: x_return_status OUT NOCOPY VARCHAR2) IS
767:
768: l_payer_context_rec IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type;
769: l_pmtInstrAssignment_rec IBY_FNDCPT_SETUP_PUB.PmtInstrAssignment_rec_type;