DBA Data[Home] [Help]

APPS.ARP_EXT_BANK_PKG dependencies on HZ_CUST_ACCOUNTS

Line 350: FROM hz_cust_accounts

346: arp_standard.debug('arp_ext_bank_pkg.insert_bank_account(+)');
347:
348: /* Bug 6799655 : Get the party_id from cust_account_id supplied */
349: SELECT party_id INTO l_party_id
350: FROM hz_cust_accounts
351: WHERE cust_account_id = p_customer_id;
352:
353: -- l_ext_bank_acct_rec.bank_account_id := NULL;
354: l_ext_bank_acct_rec.bank_account_name := p_bank_account_name;

Line 715: FROM hz_cust_accounts

711: AND branch_number = p_routing_number;
712:
713: IF(l_count = 0) THEN
714: SELECT party_id INTO l_party_id
715: FROM hz_cust_accounts
716: WHERE cust_account_id = p_customer_id;
717:
718: insert_acct_instr_assignment(
719: p_party_id => l_party_id,