APPS.FA_TRANSFER_PUB dependencies on FA_BOOKS

Line 37: FROM fa_books bks,

33:
34: -- Bug 8252607/5475276 Cursor to get the book_type_code
35: CURSOR c_corp_book( p_asset_id number ) IS
36: SELECT bc.book_type_code
37: FROM fa_books bks,
38: fa_book_controls bc
39: WHERE bks.book_type_code = bc.distribution_source_book
40: AND bks.book_type_code = bc.book_type_code
41: AND bks.asset_id = p_asset_id

Line 429: FROM FA_BOOKS bk, FA_DEPRN_PERIODS dp

425: -- prior period tfr is not allowed after assets' normal life complete
426:
427: SELECT count(1)
428: INTO l_count
429: FROM FA_BOOKS bk, FA_DEPRN_PERIODS dp
430: WHERE bk.asset_id = p_asset_hdr_rec.asset_id
431: AND bk.book_type_code = p_asset_hdr_rec.book_type_code
432: AND nvl(period_counter_fully_reserved, 99) <>
433: nvl(period_counter_life_complete, 99)