DBA Data[Home] [Help]

APPS.FA_WHATIF_DEPRN_PKG dependencies on FA_CATEGORY_BOOK_DEFAULTS

Line 385: FROM FA_CATEGORY_BOOK_DEFAULTS cbd

381: h_prorate_conv,
382: dpr_in.adj_rate,
383: dpr_in.bonus_rule,
384: dpr_in.ceil_name
385: FROM FA_CATEGORY_BOOK_DEFAULTS cbd
386: WHERE cbd.book_type_code = X_book
387: AND cbd.category_id = X_category_id
388: AND X_dpis BETWEEN CBD.START_DPIS AND
389: NVL(CBD.END_DPIS,TO_DATE('31-12-4712','DD-MM-YYYY'));

Line 818: , FA_CATEGORY_BOOK_DEFAULTS CBD

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
822: AND fin_info.date_placed_in_svc