APPS.FA_ASSET_DESC_PUB dependencies on FA_BOOK_CONTROLS

Line 116: from fa_book_controls bc

112: l_err_stage:= 'We need a calling book if it was not provided';
113: if (px_asset_hdr_rec.book_type_code is null) then
114: select bc.book_type_code
115: into px_asset_hdr_rec.book_type_code
116: from fa_book_controls bc
117: where bc.book_class = 'CORPORATE'
118: and exists
119: (
120: select 'X'

Line 1432: fa_book_controls bc

1428: -- Bug 5475276 Cursor to get the book_type_code
1429: CURSOR c_corp_book( p_asset_id number ) IS
1430: SELECT bc.book_type_code
1431: FROM fa_books bks,
1432: fa_book_controls bc
1433: WHERE bks.book_type_code = bc.distribution_source_book
1434: AND bks.book_type_code = bc.book_type_code
1435: AND bks.asset_id = p_asset_id
1436: AND bks.transaction_header_id_out is null;