DBA Data[Home] [Help]

APPS.FA_REC_PVT_PKG1 dependencies on FA_CATEGORY_BOOKS

Line 206: FROM FA_CATEGORY_BOOKS cb, FA_BOOKS bk, fa_book_controls bc

202:
203: -- Make sure the new category is defined in all the books the asset belongs to.
204: -- Get the number of books in which the new category is defined for the asset.
205: SELECT count(*) INTO l_check_count1
206: FROM FA_CATEGORY_BOOKS cb, FA_BOOKS bk, fa_book_controls bc
207: WHERE bk.asset_id = p_asset_id
208: AND bk.date_ineffective IS NULL
209: AND bk.book_type_code = cb.book_type_code
210: AND cb.category_id = p_new_category_id