DBA Data[Home] [Help]

APPS.FA_FIN_ADD_PKG dependencies on FA_CATEGORY_BOOKS

Line 161: from fa_category_books

157: -- get acct flex info
158:
159: select deprn_expense_acct
160: into X_EXPENSE_ACCT
161: from fa_category_books
162: where category_id = X_CATEGORY_ID
163: and book_type_code = X_BOOK_TYPE_CODE;
164: --
165:

Line 273: from fa_category_books

269: -- syoung: count(*) to count(1)
270: -- and inserted rownum condition.
271: select count(1)
272: into lv_count
273: from fa_category_books
274: where category_id = X_CATEGORY_ID
275: and book_type_code = X_BOOK_TYPE_CODE
276: and cip_cost_acct is not null
277: and cip_clearing_acct is not null

Line 295: from fa_category_books

291: -- for mass reclass before getting to this part.
292: -- Do this check only for single reclass.
293: select count(1)
294: into lv_count
295: from fa_category_books
296: where book_type_code = X_BOOK_TYPE_CODE and
297: category_id = X_CATEGORY_ID
298: and rownum < 2;
299: --