DBA Data[Home] [Help]

APPS.FA_WHATIF_DEPRN_PKG dependencies on FA_ADDITIONS_B

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