DBA Data[Home] [Help]

APPS.FA_WHATIF_DEPRN_PKG dependencies on FA_ADDITIONS_B

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