135: , ITF.SPLIT3_PERCENT
136: , ITF.SPLIT3_LOSS_ACCT -- End of Bug 6666666
137: , nvl(ITF.ALLOWED_DEPRN_LIMIT_AMOUNT,0)
138: , ITF.REVAL_LOSS_BALANCE
139: from FA_ITF_IMPAIRMENTS ITF
140: , FA_IMPAIRMENTS IMP
141: where ITF.WORKER_ID = p_worker_id
142: and ITF.BOOK_TYPE_CODE = p_book_type_code
143: and IMP.REQUEST_ID = p_request_id
448: AND IMP.STATUS = l_mode
449: AND IMP.SET_OF_BOOKS_ID = p_set_of_books_id
450: AND (IMP.IMPAIRMENT_AMOUNT <> 0 AND IMP.NET_BOOK_VALUE <> 0));
451: else
452: UPDATE FA_ITF_IMPAIRMENTS
453: set REQUEST_ID = p_request_id
454: WHERE WORKER_ID = p_worker_id
455: AND BOOK_TYPE_CODE = p_book_type_code
456: AND IMPAIRMENT_ID in