APPS.FA_RECLASS_UTIL_PVT dependencies on FA_CATEGORY_BOOKS

Line 20: from fa_category_books

16: BEGIN
17: if p_asset_type = 'CIP' then
18: select count(1)
19: into v_count
20: from fa_category_books
21: where category_id = p_category_id
22: and book_type_code = p_book_type_code
23: and cip_cost_acct is not null
24: 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 663: FROM fa_category_books

659: l_err_stage := 'Get the new category DEPRN_EXPENSE_ACCT';
660: -- dbms_output.put_line(l_err_stage);
661: SELECT deprn_expense_acct,asset_cost_account_ccid
662: INTO h_new_deprn_exp_acct,h_cost_acct_ccid
663: FROM fa_category_books
664: WHERE book_type_code = p_asset_hdr_rec.book_type_code
665: AND category_id = p_asset_cat_rec_new.category_id;
666:
667:

Line 817: from fa_category_books

813: and dh.asset_id = ad.asset_id;
814:
815: CURSOR cat_csr( p_book varchar2, p_cat_id number) IS
816: select deprn_expense_acct
817: from fa_category_books
818: where book_type_code = p_book
819: and category_id = p_cat_id;
820:
821: -- fix for bug 3255715

Line 835: l_new_deprn_exp_acct fa_category_books.deprn_expense_acct%type;

831: l_rowcount number;
832: l_dist_rec_old FA_API_TYPES.asset_dist_rec_type;
833: l_dist_rec_new FA_API_TYPES.asset_dist_rec_type;
834:
835: l_new_deprn_exp_acct fa_category_books.deprn_expense_acct%type;
836: l_old_deprn_exp_acct fa_category_books.deprn_expense_acct%type;
837: l_err_stage varchar2(250);
838: l_calling_fn varchar2(40) := 'fa_reclass_util_pvt.get_asset_dist';
839: l_trx_date_entered date; -- fix for bug 3255715

Line 836: l_old_deprn_exp_acct fa_category_books.deprn_expense_acct%type;

832: l_dist_rec_old FA_API_TYPES.asset_dist_rec_type;
833: l_dist_rec_new FA_API_TYPES.asset_dist_rec_type;
834:
835: l_new_deprn_exp_acct fa_category_books.deprn_expense_acct%type;
836: l_old_deprn_exp_acct fa_category_books.deprn_expense_acct%type;
837: l_err_stage varchar2(250);
838: l_calling_fn varchar2(40) := 'fa_reclass_util_pvt.get_asset_dist';
839: l_trx_date_entered date; -- fix for bug 3255715
840: