APPS.IEX_WF_BAN_STATUS_PUB dependencies on HZ_CUST_ACCOUNTS

Line 379: select account_number into l_account_number from hz_cust_accounts hc

375: */
376:
377: -- bug 15935804 begin...
378: begin
379: select account_number into l_account_number from hz_cust_accounts hc
380: where exists (select 1 from iex_bankruptcies bk where bankruptcy_id = p_bankruptcy_id
381: and attribute15 = 'ACCOUNT' and hc.cust_account_id = bk.cust_account_id);
382: exception
383: when others then null;