DBA Data[Home] [Help]

APPS.FA_IMPAIRMENT_POST_PVT dependencies on FA_IMPAIRMENTS

Line 140: , FA_IMPAIRMENTS IMP

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
144: and IMP.BOOK_TYPE_CODE = p_book_type_code

Line 458: FROM FA_IMPAIRMENTS IMP

454: WHERE WORKER_ID = p_worker_id
455: AND BOOK_TYPE_CODE = p_book_type_code
456: AND IMPAIRMENT_ID in
457: (SELECT IMPAIRMENT_ID
458: FROM FA_IMPAIRMENTS IMP
459: WHERE IMP.BOOK_TYPE_CODE = p_book_type_code
460: AND IMP.STATUS = l_mode
461: AND (IMP.IMPAIRMENT_AMOUNT <> 0 AND IMP.NET_BOOK_VALUE <> 0));
462: end if;