49:
50: CURSOR C_corp_book( p_asset_id number ) IS
51: SELECT bc.book_type_code
52: FROM fa_books bks,
53: fa_book_controls bc
54: WHERE bks.book_type_code = bc.distribution_source_book
55: AND bks.book_type_code = bc.book_type_code
56: AND bks.asset_id = p_asset_id
57: AND bks.date_ineffective is null;