DBA Data[Home] [Help]

APPS.FA_FIN_ADD_PKG dependencies on FA_CATEGORY_BOOKS

Line 166: from fa_category_books

162: -- get acct flex info
163:
164: select deprn_expense_acct
165: into X_EXPENSE_ACCT
166: from fa_category_books
167: where category_id = X_CATEGORY_ID
168: and book_type_code = X_BOOK_TYPE_CODE;
169: --
170:

Line 283: from fa_category_books

279: -- syoung: count(*) to count(1)
280: -- and inserted rownum condition.
281: select count(1)
282: into lv_count
283: from fa_category_books
284: where category_id = X_CATEGORY_ID
285: and book_type_code = X_BOOK_TYPE_CODE
286: and cip_cost_acct is not null
287: and cip_clearing_acct is not null

Line 305: from fa_category_books

301: -- for mass reclass before getting to this part.
302: -- Do this check only for single reclass.
303: select count(1)
304: into lv_count
305: from fa_category_books
306: where book_type_code = X_BOOK_TYPE_CODE and
307: category_id = X_CATEGORY_ID
308: and rownum < 2;
309: --