DBA Data[Home] [Help]

APPS.FA_WHATIF_DEPRN_PKG dependencies on FA_ADDITIONS

Line 261: fa_additions_b ad

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
265: AND mt.method_code = bk.deprn_method_code

Line 348: fa_additions_b ad

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
352: AND mt.method_code = bk.deprn_method_code

Line 817: FROM FA_ADDITIONS_B FAD

813: , CBD.SPECIAL_DEPRN_LIMIT_AMOUNT
814: INTO h_use_deprn_limits_flag
815: , h_allowed_deprn_limit
816: , h_allowed_deprn_limit_amt
817: FROM FA_ADDITIONS_B FAD
818: , FA_CATEGORY_BOOK_DEFAULTS CBD
819: WHERE FAD.ASSET_ID = fin_info.asset_id
820: AND CBD.CATEGORY_ID = FAD.ASSET_CATEGORY_ID
821: AND CBD.BOOK_TYPE_CODE = fin_info.book

Line 1491: from fa_additions

1487: select description, tag_number, serial_number, asset_number,
1488: asset_key_ccid, current_units, asset_category_id
1489: into h_description, h_tag_number, h_serial_number, h_asset_number,
1490: h_asset_key_id, h_total_units, h_category_id
1491: from fa_additions
1492: where asset_id = X_asset_id;
1493:
1494: -- SELECT CURRENT (BEFORE ADJUSTMENT) BOOK-LEVEL INFO
1495: