APPS.FA_WHATIF_DEPRN_PKG dependencies on FA_ADDITIONS

Line 280: fa_additions_b ad

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

Line 371: fa_additions_b ad

367: FROM fa_ceiling_types ceilt,
368: fa_methods mt,
369: fa_category_books cb,
370: fa_mc_books bk,
371: fa_additions_b ad
372: WHERE cb.book_type_code = X_book
373: AND ad.asset_category_id = cb.category_id
374: AND ceilt.ceiling_name(+) = bk.ceiling_name
375: AND mt.method_code = bk.deprn_method_code

Line 848: FROM FA_ADDITIONS_B FAD

844: , CBD.SPECIAL_DEPRN_LIMIT_AMOUNT
845: INTO h_use_deprn_limits_flag
846: , h_allowed_deprn_limit
847: , h_allowed_deprn_limit_amt
848: FROM FA_ADDITIONS_B FAD
849: , FA_CATEGORY_BOOK_DEFAULTS CBD
850: WHERE FAD.ASSET_ID = fin_info.asset_id
851: AND CBD.CATEGORY_ID = FAD.ASSET_CATEGORY_ID
852: AND CBD.BOOK_TYPE_CODE = fin_info.book

Line 1747: from fa_additions

1743: select description, tag_number, serial_number, asset_number,
1744: asset_key_ccid, current_units, asset_category_id
1745: into h_description, h_tag_number, h_serial_number, h_asset_number,
1746: h_asset_key_id, h_total_units, h_category_id
1747: from fa_additions
1748: where asset_id = X_asset_id;
1749:
1750: -- SELECT CURRENT (BEFORE ADJUSTMENT) BOOK-LEVEL INFO
1751: