DBA Data[Home] [Help]

APPS.FA_WHATIF_DEPRN_PKG dependencies on FA_BOOKS

Line 260: fa_books bk,

256: , dpr_in.asset_type
257: FROM fa_ceiling_types ceilt,
258: fa_methods mt,
259: fa_category_books cb,
260: fa_books bk,
261: fa_additions_b ad
262: WHERE cb.book_type_code = X_book
263: AND ad.asset_category_id = cb.category_id
264: AND ceilt.ceiling_name(+) = bk.ceiling_name

Line 347: fa_books_mrc_v bk,

343: , dpr_in.asset_type
344: FROM fa_ceiling_types ceilt,
345: fa_methods mt,
346: fa_category_books cb,
347: fa_books_mrc_v bk,
348: fa_additions_b ad
349: WHERE cb.book_type_code = X_book
350: AND ad.asset_category_id = cb.category_id
351: AND ceilt.ceiling_name(+) = bk.ceiling_name

Line 1507: from fa_books

1503: into h_current_cost, h_current_prorate_conv, h_current_method,
1504: h_current_life, h_current_basic_rate, h_current_adjusted_rate,
1505: h_current_salvage_value, h_current_bonus_rule,
1506: h_current_dpis
1507: from fa_books
1508: where asset_id = X_asset_id
1509: and book_type_code = X_book
1510: and transaction_header_id_out is null;
1511:

Line 1521: from fa_books_mrc_v

1517: into h_current_cost, h_current_prorate_conv, h_current_method,
1518: h_current_life, h_current_basic_rate, h_current_adjusted_rate,
1519: h_current_salvage_value, h_current_bonus_rule,
1520: h_current_dpis
1521: from fa_books_mrc_v
1522: where asset_id = X_asset_id
1523: and book_type_code = X_book
1524: and transaction_header_id_out is null;
1525: