DBA Data[Home] [Help]

APPS.FA_IMPAIRMENT_POST_PVT dependencies on FA_MC_ITF_IMPAIRMENTS

Line 222: from FA_MC_ITF_IMPAIRMENTS ITF

218: , ITF.SPLIT3_PERCENT
219: , ITF.SPLIT3_LOSS_ACCT -- End of Bug 6666666
220: , nvl(ITF.ALLOWED_DEPRN_LIMIT_AMOUNT,0)
221: , ITF.REVAL_LOSS_BALANCE
222: from FA_MC_ITF_IMPAIRMENTS ITF
223: , FA_MC_IMPAIRMENTS IMP
224: where ITF.WORKER_ID = p_worker_id
225: and ITF.BOOK_TYPE_CODE = p_book_type_code
226: and ITF.SET_OF_BOOKS_ID = p_set_of_books_id

Line 439: UPDATE FA_MC_ITF_IMPAIRMENTS

435: l_asset_hdr_rec.set_of_books_id := p_set_of_books_id;
436:
437: /*Bug#9182681 - to update request_id,for asset impairment report */
438: if (p_mrc_sob_type_code = 'R') then
439: UPDATE FA_MC_ITF_IMPAIRMENTS
440: set REQUEST_ID = p_request_id
441: WHERE WORKER_ID = p_worker_id
442: AND BOOK_TYPE_CODE = p_book_type_code
443: AND SET_OF_BOOKS_ID = p_set_of_books_id