DBA Data[Home] [Help]

APPS.FA_WHATIF_DEPRN_PKG dependencies on FA_BOOKS

Line 279: fa_books bk,

275: , h_prior_eofy_reserve --Bug#16045341
276: FROM fa_ceiling_types ceilt,
277: fa_methods mt,
278: fa_category_books cb,
279: fa_books bk,
280: fa_additions_b ad
281: WHERE cb.book_type_code = X_book
282: AND ad.asset_category_id = cb.category_id
283: AND ceilt.ceiling_name(+) = bk.ceiling_name

Line 1186: , fa_books fk

1182: , dpr_in.y_begin
1183: FROM fa_calendar_periods cp
1184: , fa_fiscal_year fy
1185: , fa_book_controls fb
1186: , fa_books fk
1187: WHERE cp.calendar_type = fb.deprn_calendar
1188: AND fb.book_type_code = X_book
1189: AND cp.start_date >= fy.start_date
1190: AND cp.end_date <= fy.end_date

Line 1199: From fa_books fk,

1195: AND (fy.fiscal_year * h_num_per_fy + cp.period_num) = fk.extended_depreciation_period;
1196: */
1197: Select cal.period_num , cal.fiscal_year
1198: into dpr_in.p_cl_begin , dpr_in.y_begin
1199: From fa_books fk,
1200: (
1201: Select cp.period_num period_num,
1202: fy.fiscal_year fiscal_year
1203: From fa_fiscal_year fy

Line 1763: from fa_books

1759: into h_current_cost, h_current_prorate_conv, h_current_method,
1760: h_current_life, h_current_basic_rate, h_current_adjusted_rate,
1761: h_current_salvage_value, h_current_bonus_rule,
1762: h_current_dpis
1763: from fa_books
1764: where asset_id = X_asset_id
1765: and book_type_code = X_book
1766: and transaction_header_id_out is null;
1767: