APPS.FA_ASSET_DESC_PUB dependencies on FA_BOOKS

Line 116: from fa_books bks

112: where bc.book_class = 'CORPORATE'
113: and exists
114: (
115: select 'X'
116: from fa_books bks
117: where bks.asset_id = px_asset_hdr_rec.asset_id
118: and bks.book_type_code = bc.book_type_code
119: );
120: end if;

Line 1392: FROM fa_books bks,

1388:
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