APPS.FA_RECLASS_UTIL_PVT dependencies on FA_CATEGORY_BOOKS

Line 23: from fa_category_books

19: BEGIN
20: if p_asset_type = 'CIP' then
21: select count(1)
22: into v_count
23: from fa_category_books
24: where category_id = p_category_id
25: and book_type_code = p_book_type_code
26: and cip_cost_acct is not null
27: and cip_clearing_acct is not null

Line 65: FROM FA_CATEGORY_BOOKS cb, FA_BOOKS bk, fa_book_controls bc

61:
62: -- Make sure the new category is defined in all the books the asset belongs to.
63: -- Get the number of books in which the new category is defined for the asset.
64: SELECT count(*) INTO l_count1
65: FROM FA_CATEGORY_BOOKS cb, FA_BOOKS bk, fa_book_controls bc
66: WHERE bk.asset_id = p_asset_id
67: AND bk.date_ineffective IS NULL
68: AND bk.book_type_code = cb.book_type_code
69: AND cb.category_id = p_new_category_id

Line 630: FROM fa_category_books

626: l_err_stage := 'Get the new category DEPRN_EXPENSE_ACCT';
627: -- dbms_output.put_line(l_err_stage);
628: SELECT deprn_expense_acct,asset_cost_account_ccid
629: INTO h_new_deprn_exp_acct,h_cost_acct_ccid
630: FROM fa_category_books
631: WHERE book_type_code = p_asset_hdr_rec.book_type_code
632: AND category_id = p_asset_cat_rec_new.category_id;
633:
634:

Line 781: from fa_category_books

777: and dh.asset_id = ad.asset_id;
778:
779: CURSOR cat_csr( p_book varchar2, p_cat_id number) IS
780: select deprn_expense_acct
781: from fa_category_books
782: where book_type_code = p_book
783: and category_id = p_cat_id;
784:
785: -- fix for bug 3255715

Line 799: l_new_deprn_exp_acct fa_category_books.deprn_expense_acct%type;

795: l_rowcount number;
796: l_dist_rec_old FA_API_TYPES.asset_dist_rec_type;
797: l_dist_rec_new FA_API_TYPES.asset_dist_rec_type;
798:
799: l_new_deprn_exp_acct fa_category_books.deprn_expense_acct%type;
800: l_old_deprn_exp_acct fa_category_books.deprn_expense_acct%type;
801: l_err_stage varchar2(250);
802: l_calling_fn varchar2(40) := 'fa_reclass_util_pvt.get_asset_dist';
803: l_trx_date_entered date; -- fix for bug 3255715

Line 800: l_old_deprn_exp_acct fa_category_books.deprn_expense_acct%type;

796: l_dist_rec_old FA_API_TYPES.asset_dist_rec_type;
797: l_dist_rec_new FA_API_TYPES.asset_dist_rec_type;
798:
799: l_new_deprn_exp_acct fa_category_books.deprn_expense_acct%type;
800: l_old_deprn_exp_acct fa_category_books.deprn_expense_acct%type;
801: l_err_stage varchar2(250);
802: l_calling_fn varchar2(40) := 'fa_reclass_util_pvt.get_asset_dist';
803: l_trx_date_entered date; -- fix for bug 3255715
804: