APPS.FA_CDE_PKG dependencies on FA_BOOKS

Line 260: ' rate FROM fa_books fabk, fa_deprn_periods fadp ' ||

256: to_char(X_Life_In_Months));
257:
258: -- Fix for Bug #2939771. Use bind variables.
259: h_formula := 'SELECT ' || h_formula_parsed ||
260: ' rate FROM fa_books fabk, fa_deprn_periods fadp ' ||
261: ' WHERE (fabk.asset_id = :v1) ' ||
262: ' AND (fabk.book_type_code = :v2' ||
263: ' ) AND (fabk.book_type_code = fadp.book_type_code) ' ||
264: ' AND (fabk.date_ineffective is null) ' ||

Line 330: fa_debug_pkg.add('FAXGFR','+++ Fetching current rate from fa_books', 'YES', p_log_level_rec);

326:
327: if fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag = 'YES' then
328: if X_calling_interface is null then
329: if (p_log_level_rec.statement_level) then
330: fa_debug_pkg.add('FAXGFR','+++ Fetching current rate from fa_books', 'YES', p_log_level_rec);
331: end if; -- p_log_level_rec.statement_level
332:
333: SELECT rate_in_use
334: INTO X_Rate

Line 335: FROM fa_books

331: end if; -- p_log_level_rec.statement_level
332:
333: SELECT rate_in_use
334: INTO X_Rate
335: FROM fa_books
336: WHERE book_type_code = X_Book_Type_Code
337: AND asset_id = X_Asset_Id
338: AND date_ineffective is null;
339: end if; -- X_calling_interface is null

Line 451: from fa_books bk,

447: X_curr_fy_end_date,
448: h_curr_fy,
449: h_dpis,
450: h_deprn_start_date
451: from fa_books bk,
452: fa_fiscal_year fy,
453: fa_book_controls bc,
454: fa_book_controls bc2
455: where bc.book_type_code = X_Book_Type_Code

Line 1087: raf rate_adj_factor rate_adjustment_factor in fa_books

1083:
1084: amo_reval_rsv_flag amo_reval_rsv_flag amortize_reval_reserve_flag in
1085: fa_book_controls
1086:
1087: raf rate_adj_factor rate_adjustment_factor in fa_books
1088:
1089: cur_fy cur_fy current fiscal year
1090:
1091: deprn_limit_flag use_deprn_limit_flag use depreciation limit flag

Line 1276: l_ind BINARY_INTEGER; -- For FA_BOOKS_SUMMARY

1272: cdb_bonus_deprn_rsv number;
1273:
1274: l_period_counter number(15); -- For Super Group
1275:
1276: l_ind BINARY_INTEGER; -- For FA_BOOKS_SUMMARY
1277: l_accum_rsv_adj number; -- Store reserve adjustment_amount.
1278: -- It will be accumulated if faxcde is called for
1279: -- multiple periods
1280: l_rsv_adj number; -- Store reserve adjustment amount from fa_amort_pvt

Line 2987: from fa_books

2983:
2984: --Bug 5689910
2985: select adjusted_cost
2986: into l_temp_adj_cost
2987: from fa_books
2988: where book_type_code = dpr.book
2989: and asset_id = dpr.asset_id
2990: and transaction_header_id_out is null;
2991:

Line 3154: -- If this is called for maintaining FA_BOOKS_SUMAMRY table,

3150: l_rsv_adj := 0;
3151: end if;
3152:
3153: --
3154: -- If this is called for maintaining FA_BOOKS_SUMAMRY table,
3155: -- consider reserve_adjustment_amount when calculating absolute
3156: -- value of reserve
3157: --
3158: if (l_ind <> 0) and

Line 4373: select bk.cost into report_cost from fa_books_mrc_v bk

4369: end if;
4370:
4371: else -- Depreciation Run
4372: if (h_reporting_flag = 'R') then
4373: select bk.cost into report_cost from fa_books_mrc_v bk
4374: where bk.book_type_code = book and
4375: bk.asset_id = h_asset_id and
4376: bk.transaction_header_id_out is null;
4377:

Line 4382: select bk.cost into primary_cost from fa_books bk

4378: if (p_log_level_rec.statement_level) then
4379: fa_debug_pkg.add('faodda', 'report_cost', report_cost,p_log_level_rec);
4380: end if;
4381:
4382: select bk.cost into primary_cost from fa_books bk
4383: where bk.book_type_code = book and
4384: bk.asset_id = h_asset_id and
4385: bk.transaction_header_id_out is null;
4386: