APPS.FA_ASSET_DESC_PUB dependencies on FA_BOOK_CONTROLS

Line 111: from fa_book_controls bc

107: l_err_stage:= 'We need a calling book if it was not provided';
108: if (px_asset_hdr_rec.book_type_code is null) then
109: select bc.book_type_code
110: into px_asset_hdr_rec.book_type_code
111: from fa_book_controls bc
112: where bc.book_class = 'CORPORATE'
113: and exists
114: (
115: select 'X'

Line 1393: fa_book_controls bc

1389: -- Bug 8252607/5475276 Cursor to get the book_type_code
1390: CURSOR c_corp_book( p_asset_id number ) IS
1391: SELECT bc.book_type_code
1392: FROM fa_books bks,
1393: fa_book_controls bc
1394: WHERE bks.book_type_code = bc.distribution_source_book
1395: AND bks.book_type_code = bc.book_type_code
1396: AND bks.asset_id = p_asset_id
1397: AND bks.transaction_header_id_out is null;