DBA Data[Home] [Help]

APPS.FA_TRANSFER_PUB dependencies on FA_BOOKS

Line 32: FROM fa_books bks,

28:
29: -- Bug 5475276 Cursor to get the book_type_code
30: CURSOR c_corp_book( p_asset_id number ) IS
31: SELECT bc.book_type_code
32: FROM fa_books bks,
33: fa_book_controls bc
34: WHERE bks.book_type_code = bc.distribution_source_book
35: AND bks.book_type_code = bc.book_type_code
36: AND bks.asset_id = p_asset_id

Line 384: FROM FA_BOOKS bk, FA_DEPRN_PERIODS dp

380: -- prior period tfr is not allowed after assets' normal life complete
381:
382: SELECT count(1)
383: INTO l_count
384: FROM FA_BOOKS bk, FA_DEPRN_PERIODS dp
385: WHERE bk.asset_id = p_asset_hdr_rec.asset_id
386: AND bk.book_type_code = p_asset_hdr_rec.book_type_code
387: AND nvl(period_counter_fully_reserved, 99) <>
388: nvl(period_counter_life_complete, 99)