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.

APPS.IEX_WF_DEL_REQ_CREDIT_PUB dependencies on HZ_CUST_ACCOUNTS

Line 114: select account_number into l_account_number from hz_cust_accounts

110: begin
111: select party_id,party_name into l_party_id,l_party_name from hz_parties
112: where party_id = (select party_id from iex_delinquencies_all where delinquency_id = p_delinquency_id);
113:
114: select account_number into l_account_number from hz_cust_accounts
115: where cust_account_id = (select cust_account_id from iex_delinquencies_all where delinquency_id = p_delinquency_id);
116: exception
117: when others then null;
118: end;

Line 164: select account_number into l_account_number from hz_cust_accounts

160: begin
161: select party_id,party_name into l_party_id,l_party_name from hz_parties
162: where party_id = (select party_id from iex_repossessions where repossession_id = p_repossession_id);
163:
164: select account_number into l_account_number from hz_cust_accounts
165: where cust_account_id = (select cust_account_id from iex_repossessions where repossession_id = p_repossession_id);
166: exception
167: when others then null;
168: end;

Line 214: select account_number into l_account_number from hz_cust_accounts

210: begin
211: select party_id,party_name into l_party_id,l_party_name from hz_parties
212: where party_id = (select party_id from iex_litigations where litigation_id = p_litigation_id);
213:
214: select account_number into l_account_number from hz_cust_accounts
215: where cust_account_id = (select cust_account_id from iex_litigations where litigation_id = p_litigation_id);
216: exception
217: when others then null;
218: end;

Line 264: select account_number into l_account_number from hz_cust_accounts

260: begin
261: select party_id,party_name into l_party_id,l_party_name from hz_parties
262: where party_id = (select party_id from iex_writeoffs where writeoff_id = p_writeoff_id);
263:
264: select account_number into l_account_number from hz_cust_accounts
265: where cust_account_id = (select cust_account_id from iex_writeoffs where writeoff_id = p_writeoff_id);
266: exception
267: when others then null;
268: end;

Line 315: select account_number into l_account_number from hz_cust_accounts hc

311: begin
312: select party_id,party_name into l_party_id,l_party_name from hz_parties
313: where party_id = (select party_id from iex_bankruptcies where bankruptcy_id = p_bankruptcy_id);
314:
315: select account_number into l_account_number from hz_cust_accounts hc
316: where exists (select 1 from iex_bankruptcies bk where bankruptcy_id = p_bankruptcy_id
317: and attribute15 = 'ACCOUNT' and hc.cust_account_id = bk.cust_account_id);
318: exception
319: when others then null;

Line 462: from hz_cust_accounts hz

458:
459: -- Bug 6936225 by Ehuh
460: CURSOR c_get_acct (in_bankruptcy_id number) IS
461: select cust_account_id
462: from hz_cust_accounts hz
463: where party_id = (select party_id from iex_bankruptcies
464: where bankruptcy_id = in_bankruptcy_id)
465: and hz.cust_account_id = (select decode(bc.attribute15,'ACCOUNT',bc.cust_account_id,hz.cust_account_id) from iex_bankruptcies bc
466: where bankruptcy_id = in_bankruptcy_id) -- add by bug 15935812