DBA Data[Home] [Help]

APPS.FA_IMPAIRMENT_POST_PVT dependencies on FA_ITF_IMPAIRMENTS

Line 139: from FA_ITF_IMPAIRMENTS ITF

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

Line 452: UPDATE FA_ITF_IMPAIRMENTS

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