APPS.FA_FIN_ADD_PKG dependencies on FA_CATEGORY_BOOK_DEFAULTS

Line 104: FROM fa_category_book_defaults cbd, fa_books bks

100: -- requirement not to null out the default group asset for a category when
101: -- a group is disabled. However, we can't assign an asset to a disabled group. */
102: SELECT count(1)
103: INTO l_grp_count
104: FROM fa_category_book_defaults cbd, fa_books bks
105: WHERE cbd.category_id = X_Category_Id
106: AND cbd.book_type_code = X_BOOK_TYPE_CODE
107: AND cbd.book_type_code = bks.book_type_code
108: AND cbd.group_asset_id = bks.asset_id

Line 220: from fa_category_book_defaults

216: end if;
217: -- default prorate convention code
218: select prorate_convention_code
219: into X_PRORATE_CONVENTION_CODE
220: from fa_category_book_defaults
221: where book_type_code = X_BOOK_TYPE_CODE
222: and category_id = X_CATEGORY_ID
223: and X_DPIS between start_dpis and nvl(end_dpis, X_DPIS);
224: --