APPS.IEX_WF_DEL_REQ_CREDIT_PUB dependencies on IEX_REPOSSESSIONS

Line 162: where party_id = (select party_id from iex_repossessions where repossession_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);
166: exception

Line 165: where cust_account_id = (select cust_account_id from iex_repossessions where repossession_id = p_repossession_id);

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

Line 529: update IEX_REPOSSESSIONS

525: update IEX_DELINQUENCIES_ALL
526: set CREDIT_HOLD_APPROVED_FLAG = 'Y'
527: where delinquency_id = l_delinquency_id;
528: ELSIF l_del_type = 'Repossession' THEN
529: update IEX_REPOSSESSIONS
530: set CREDIT_HOLD_APPROVED_FLAG = 'Y'
531: where repossession_id = l_repossession_id;
532: ELSIF l_del_type = 'Litigation' THEN
533: update IEX_LITIGATIONS

Line 673: update IEX_REPOSSESSIONS

669: update IEX_DELINQUENCIES_ALL
670: set CREDIT_HOLD_APPROVED_FLAG = 'N'
671: where delinquency_id = l_delinquency_id;
672: ELSIF l_del_type = 'Repossession' THEN
673: update IEX_REPOSSESSIONS
674: set CREDIT_HOLD_APPROVED_FLAG = 'N'
675: where repossession_id = l_repossession_id;
676: ELSIF l_del_type = 'Litigation' THEN
677: update IEX_LITIGATIONS