APPS.IEX_WF_DEL_REQ_SERVICE_PUB dependencies on IEX_BANKRUPTCIES

Line 402: update IEX_BANKRUPTCIES

398: update IEX_WRITEOFFS
399: set SERVICE_HOLD_APPROVED_FLAG = 'Y'
400: where writeoff_id = l_writeoff_id;
401: ELSIF l_del_type = 'Bankruptcy' THEN
402: update IEX_BANKRUPTCIES
403: set SERVICE_HOLD_APPROVED_FLAG = 'Y'
404: where bankruptcy_id = l_bankruptcy_id;
405: ELSE
406: null;

Line 501: update IEX_BANKRUPTCIES

497: itemtype => itemtype,
498: itemkey => itemkey,
499: aname => 'BANKRUPTCY_ID');
500:
501: update IEX_BANKRUPTCIES
502: set SERVICE_HOLD_APPROVED_FLAG = 'Y'
503: where bankruptcy_id = l_bankruptcy_id;
504: ELSE
505: null;

Line 558: update IEX_BANKRUPTCIES

554: update IEX_WRITEOFFS
555: set SERVICE_HOLD_APPROVED_FLAG = 'N'
556: where writeoff_id = TO_NUMBER(substr(itemkey, 3));
557: ELSIF l_del_type = 'Bankruptcy' THEN
558: update IEX_BANKRUPTCIES
559: set SERVICE_HOLD_APPROVED_FLAG = 'Y'
560: where bankruptcy_id = TO_NUMBER(substr(itemkey, 4));
561: ELSE
562: null;