APPS.IEX_WF_DEL_REQ_CREDIT_PUB dependencies on HZ_PARTIES

Line 111: select party_id,party_name into l_party_id,l_party_name from hz_parties

107: avalue => 'Delinquency Id: '||p_delinquency_id);
108:
109: -- bug 15935804 begin...
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);

Line 161: select party_id,party_name into l_party_id,l_party_name from hz_parties

157: avalue => 'Reposession Id: '||p_repossession_id);
158:
159: -- bug 15935804 begin...
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);

Line 211: select party_id,party_name into l_party_id,l_party_name from hz_parties

207: avalue => 'Litigation Id: '||p_litigation_id);
208:
209: -- bug 15935804 begin...
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);

Line 261: select party_id,party_name into l_party_id,l_party_name from hz_parties

257: avalue => 'Writeoff Id: '||p_writeoff_id);
258:
259: -- bug 15935804 begin...
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);

Line 312: select party_id,party_name into l_party_id,l_party_name from hz_parties

308: avalue => 'Bankruptcy Id: '||p_bankruptcy_id);
309:
310: -- bug 15935804 begin...
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