622: X_adj_ptr.account_type := 'CIP_COST_ACCT';
623:
624: select cip_cost_acct
625: into X_adj_ptr.account
626: from fa_category_books
627: where book_type_code = h_book
628: and category_id = h_category_id;
629:
630: elsif (X_asset_type = 'CAPITALIZED' OR
634: X_adj_ptr.account_type := 'ASSET_COST_ACCT';
635:
636: select asset_cost_acct
637: into X_adj_ptr.account
638: from fa_category_books
639: where book_type_code = h_book
640: and category_id = h_category_id;
641: end if;
642:
653:
654:
655: select deprn_reserve_acct
656: into X_adj_ptr.account
657: from fa_category_books
658: where book_type_code = h_book
659: and category_id = h_category_id;
660:
661: if (X_select_mode = fa_adjust_type_pkg.FA_AJ_CLEAR) then
671:
672:
673: select bonus_deprn_reserve_acct
674: into X_adj_ptr.account
675: from fa_category_books
676: where book_type_code = h_book
677: and category_id = h_category_id;
678:
679: if (X_select_mode = fa_adjust_type_pkg.FA_AJ_CLEAR) then
689:
690:
691: select impair_reserve_acct
692: into X_adj_ptr.account
693: from fa_category_books
694: where book_type_code = h_book
695: and category_id = h_category_id;
696:
697: if (X_select_mode = fa_adjust_type_pkg.FA_AJ_CLEAR) then
707: X_adj_ptr.account_type := 'CAPITAL_ADJ_ACCT';
708:
709: select capital_adj_acct
710: into X_adj_ptr.account
711: from fa_category_books
712: where book_type_code = h_book
713: and category_id = h_category_id;
714:
715: if (X_select_mode = fa_adjust_type_pkg.FA_AJ_CLEAR) then
725: X_adj_ptr.account_type := 'GENERAL_FUND_ACCT';
726:
727: select general_fund_acct
728: into X_adj_ptr.account
729: from fa_category_books
730: where book_type_code = h_book
731: and category_id = h_category_id;
732:
733: if (X_select_mode = fa_adjust_type_pkg.FA_AJ_CLEAR) then
742: X_adj_ptr.account_type := 'REVAL_RESERVE_ACCT';
743:
744: select reval_reserve_acct
745: into X_adj_ptr.account
746: from fa_category_books
747: where book_type_code = h_book
748: and category_id = h_category_id;
749:
750: if (X_select_mode = fa_adjust_type_pkg.FA_AJ_CLEAR) then
2069: IMPAIR_EXPENSE_ACCT
2070: into l_deprn_exp_acct,
2071: l_bonus_deprn_exp_acct,
2072: l_impairment_exp_acct
2073: from fa_category_books
2074: where book_type_code = X_book_type_code
2075: and category_id = X_to_category_id;
2076:
2077: exception