APPS.FA_TRANSFER_PUB dependencies on FA_BOOK_CONTROLS

Line 38: fa_book_controls bc

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
42: AND bks.transaction_header_id_out is null;

Line 454: FA_BOOK_CONTROLS bc

450: SELECT count(1)
451: INTO l_count
452: FROM FA_TRANSACTION_HEADERS th,
453: FA_DEPRN_PERIODS dp,
454: FA_BOOK_CONTROLS bc
455: WHERE th.asset_id = nvl(p_asset_hdr_rec.asset_id, -1)
456: AND th.book_type_code = nvl(p_asset_hdr_rec.book_type_code,'XX')
457: AND th.transaction_type_code||'' = 'TRANSFER'
458: AND th.transaction_date_entered < dp.calendar_period_open_date