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