350:
351: /* Bug 6799655 : Get the party_id from cust_account_id supplied */
352: IF p_customer_id IS NOT NULL THEN
353: SELECT party_id INTO l_party_id
354: FROM hz_cust_accounts
355: WHERE cust_account_id = p_customer_id;
356: ELSE
357: l_party_id := NULL;
358: END IF;
729: AND branch_number = p_routing_number;
730:
731: IF(l_count = 0) THEN
732: SELECT party_id INTO l_party_id
733: FROM hz_cust_accounts
734: WHERE cust_account_id = p_customer_id;
735:
736: insert_acct_instr_assignment(
737: p_party_id => l_party_id,