APPS.IEX_WF_DEL_REQ_CREDIT_PUB dependencies on IEX_DELINQUENCIES_ALL

Line 112: where party_id = (select party_id from iex_delinquencies_all where 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);
116: exception

Line 115: where cust_account_id = (select cust_account_id from iex_delinquencies_all where delinquency_id = p_delinquency_id);

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

Line 525: update IEX_DELINQUENCIES_ALL

521:
522: iex_debug_pub.logmessage ('IEX_WF_DEL_REQ_CREDIT_PUB: l_del_type ......= '||l_del_type);
523:
524: IF l_del_type = 'Delinquency' THEN
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

Line 669: update IEX_DELINQUENCIES_ALL

665: itemkey => itemkey,
666: aname => 'BANKRUPTCY_ID');
667:
668: IF l_del_type = 'Delinquency' THEN
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