APPS.FA_FIN_ADD_PKG dependencies on FA_CATEGORY_BOOK_DEFAULTS

Line 99: FROM fa_category_book_defaults cbd, fa_books bks

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

Line 212: from fa_category_book_defaults

208: end if;
209: -- default prorate convention code
210: select prorate_convention_code
211: into X_PRORATE_CONVENTION_CODE
212: from fa_category_book_defaults
213: where book_type_code = X_BOOK_TYPE_CODE
214: and category_id = X_CATEGORY_ID
215: and X_DPIS between start_dpis and nvl(end_dpis, X_DPIS);
216: --