APPS.FA_MASSADD_PREP_ENERGY_PKG dependencies on FA_CATEGORY_BOOKS

Line 718: from fa_category_books cat

714: nvl(l_segment(30), '-1')
715: and chart_of_accounts_id = h_chart_of_accounts_id
716: and exists
717: (select 1
718: from fa_category_books cat
719: where cat.ASSET_CLEARING_ACCOUNT_CCID =
720: gl_ccid.code_combination_id
721: and cat.book_type_code = px_mass_add_rec.book_type_code);
722: l_debug_str := 'Get the Category for Capitalized Assets';

Line 731: from fa_category_books

727: p_log_level_rec => p_log_level_rec);
728: end if;
729: select category_id
730: into px_mass_add_rec.ASSET_CATEGORY_ID
731: from fa_category_books
732: where ASSET_CLEARING_ACCOUNT_CCID = l_clearing_acct_ccid
733: and book_type_code = px_mass_add_rec.book_type_code
734: and rownum = 1;
735: elsif (px_mass_add_rec.asset_type = 'CIP') then

Line 809: from fa_category_books cat

805: nvl(l_segment(30), '-1')
806: and chart_of_accounts_id = h_chart_of_accounts_id
807: and exists
808: (select 1
809: from fa_category_books cat
810: where cat.WIP_CLEARING_ACCOUNT_CCID =
811: gl_ccid.code_combination_id
812: and cat.book_type_code = px_mass_add_rec.book_type_code);
813: l_debug_str := 'Get the Clearing Account for CIP Assets';

Line 822: from fa_category_books

818: p_log_level_rec => p_log_level_rec);
819: end if;
820: select category_id
821: into px_mass_add_rec.ASSET_CATEGORY_ID
822: from fa_category_books
823: where WIP_CLEARING_ACCOUNT_CCID = l_clearing_acct_ccid
824: and book_type_code = px_mass_add_rec.book_type_code
825: and rownum = 1;
826: END IF;

Line 1219: FROM fa_category_books

1215: where book_type_code = px_mass_add_rec.book_type_code;
1216:
1217: SELECT deprn_expense_account_ccid, asset_cost_account_ccid
1218: INTO l_DEPRN_EXPENSE_ACCT_CCID, h_cost_acct_ccid
1219: FROM fa_category_books
1220: WHERE book_type_code = px_mass_add_rec.book_type_code
1221: AND category_id = px_mass_add_rec.asset_category_id;
1222:
1223: Select sob.chart_of_accounts_id