APPS.IEX_WF_DEL_REQ_CREDIT_PUB dependencies on IEX_WRITEOFFS

Line 262: where party_id = (select party_id from iex_writeoffs where 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);
266: exception

Line 265: where cust_account_id = (select cust_account_id from iex_writeoffs where writeoff_id = p_writeoff_id);

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;
269:

Line 537: update IEX_WRITEOFFS

533: update IEX_LITIGATIONS
534: set CREDIT_HOLD_APPROVED_FLAG = 'Y'
535: where litigation_id = l_litigation_id;
536: ELSIF l_del_type = 'Writeoff' THEN
537: update IEX_WRITEOFFS
538: set CREDIT_HOLD_APPROVED_FLAG = 'Y'
539: where writeoff_id = l_writeoff_id;
540: ELSIF l_del_type = 'Bankrupt' THEN
541: iex_debug_pub.logmessage ('IEX_WF_DEL_REQ_CREDIT_PUB: Bankrutpcy Start ......= ');

Line 681: update IEX_WRITEOFFS

677: update IEX_LITIGATIONS
678: set CREDIT_HOLD_APPROVED_FLAG = 'N'
679: where litigation_id = l_litigation_id;
680: ELSIF l_del_type = 'Writeoff' THEN
681: update IEX_WRITEOFFS
682: set CREDIT_HOLD_APPROVED_FLAG = 'N'
683: where writeoff_id = l_writeoff_id;
684: ELSIF l_del_type = 'Bankrupt' THEN
685: update IEX_BANKRUPTCIES