APPS.OKL_AM_ASSET_RELOCATION_PVT dependencies on FA_BOOK_CONTROLS

Line 221: FROM fa_book_controls

217:
218: -- This cursor is used to get all the tax books for an asset
219: CURSOR l_taxbooks_csr(p_source VARCHAR2) IS
220: SELECT book_type_code
221: FROM fa_book_controls
222: WHERE distribution_source_book = p_source
223: AND book_class = 'TAX'
224: AND date_ineffective IS NULL;
225:

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