APPS.FA_SORP_UPG_PKG dependencies on FA_CATEGORY_BOOKS

Line 602: FROM fa_category_books

598: SELECT book_type_code, category_id, reval_amortization_acct,
599: reval_amort_account_ccid, impair_expense_acct,
600: impair_expense_account_ccid, impair_reserve_acct,
601: impair_reserve_account_ccid
602: FROM fa_category_books
603: WHERE book_type_code = p_book
604: AND (capital_adj_acct IS NULL OR general_fund_acct IS NULL);
605:
606: --type v_category_cur is c_category_cur%rowtype;

Line 779: UPDATE fa_category_books

775: INTO v_final_cur;
776:
777: EXIT WHEN c_final_cur%NOTFOUND;
778:
779: UPDATE fa_category_books
780: SET capital_adj_acct = v_final_cur.capital_adj_acct,
781: capital_adj_account_ccid =
782: v_final_cur.capital_adj_account_ccid,
783: general_fund_acct = v_final_cur.general_fund_acct,