DBA Data[Home] [Help]

APPS.FA_WHATIF_DEPRN_PKG dependencies on FA_CATEGORY_BOOK_DEFAULTS

Line 409: FROM FA_CATEGORY_BOOK_DEFAULTS cbd

405: h_prorate_conv,
406: dpr_in.adj_rate,
407: dpr_in.bonus_rule,
408: dpr_in.ceil_name
409: FROM FA_CATEGORY_BOOK_DEFAULTS cbd
410: WHERE cbd.book_type_code = X_book
411: AND cbd.category_id = X_category_id
412: AND X_dpis BETWEEN CBD.START_DPIS AND
413: NVL(CBD.END_DPIS,TO_DATE('31-12-4712','DD-MM-YYYY'));

Line 849: , FA_CATEGORY_BOOK_DEFAULTS CBD

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