APPS.IPA_ASSET_MECH_APIS_PKG dependencies on FA_CATEGORY_BOOKS

Line 191: from fa_book_controls bc, fa_category_books cb, pa_implementations pi

187: where upper(segment1||segment2||segment3||segment4||segment5||segment6||segment7) = upper(v_asset_location);
188:
189: cursor get_book_type IS
190: select bc.book_type_code
191: from fa_book_controls bc, fa_category_books cb, pa_implementations pi
192: where cb.category_id = v_category_id
193: and cb.book_type_code = bc.book_type_code
194: and bc.book_class = 'CORPORATE'
195: and pi.set_of_books_id = bc.set_of_books_id;