DBA Data[Home] [Help]

APPS.IEX_WF_DEL_STATUS_PUB dependencies on IEX_REPOSSESSIONS

Line 187: update IEX_REPOSSESSIONS

183: set SUGGESTION_APPROVED_FLAG = 'Y',
184: WRITEOFF_DATE = sysdate
185: where WRITEOFF_ID = to_number(substr(itemkey, 2));
186: ELSIF to_number(substr(itemkey, 0, 2)) = 'REP' THEN
187: update IEX_REPOSSESSIONS
188: set SUGGESTION_APPROVED_FLAG = 'Y',
189: REPOSSESSION_DATE = sysdate
190: where REPOSSESSION_ID = to_number(substr(itemkey, 2));
191: ELSIF to_number(substr(itemkey, 0, 2)) = 'LIT' THEN

Line 240: update IEX_REPOSSESSIONS

236: set SUGGESTION_APPROVED_FLAG = 'N',
237: WRITEOFF_DATE = sysdate
238: where WRITEOFF_ID = to_number(substr(itemkey, 2));
239: ELSIF to_number(substr(itemkey, 0, 2)) = 'REP' THEN
240: update IEX_REPOSSESSIONS
241: set SUGGESTION_APPROVED_FLAG = 'N',
242: REPOSSESSION_DATE = sysdate
243: where REPOSSESSION_ID = to_number(substr(itemkey, 2));
244: ELSIF to_number(substr(itemkey, 0, 2)) = 'LIT' THEN