DBA Data[Home] [Help]

APPS.OKL_AM_ASSET_RELOCATION_PVT dependencies on FA_DEPRN_SUMMARY

Line 229: FROM fa_deprn_summary ds, fa_book_controls bc

225:
226: -- This cursor is used to check if the depreciation has alraedy been run for an asset in any of the books
227: CURSOR l_deprnbookcnt_csr(p_book_type_code VARCHAR2,p_asset_id NUMBER) IS
228: SELECT count(*)
229: FROM fa_deprn_summary ds, fa_book_controls bc
230: WHERE bc.book_type_code = p_book_type_code
231: AND ds.book_type_code = bc.book_type_code
232: AND ds.period_counter = bc.last_period_counter + 1
233: AND ds.asset_id = p_asset_id