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:
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
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: --