APPS.FA_IMPAIRMENT_POST_PVT dependencies on FA_MC_IMPAIRMENTS

Line 223: , FA_MC_IMPAIRMENTS IMP

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
227: and IMP.REQUEST_ID = p_request_id

Line 446: FROM FA_MC_IMPAIRMENTS IMP

442: AND BOOK_TYPE_CODE = p_book_type_code
443: AND SET_OF_BOOKS_ID = p_set_of_books_id
444: AND IMPAIRMENT_ID in
445: (SELECT IMPAIRMENT_ID
446: FROM FA_MC_IMPAIRMENTS IMP
447: WHERE IMP.BOOK_TYPE_CODE = p_book_type_code
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));