DBA Data[Home] [Help]

APPS.FA_ADDITION_PVT dependencies on FA_METHODS

Line 76: fa_methods mth,

72: cbd.member_rollup_flag
73: FROM
74: fa_categories cat,
75: fa_category_book_defaults cbd,
76: fa_methods mth,
77: fa_deprn_periods dp,
78: fa_deprn_basis_rules dbr
79: WHERE
80: dp.book_type_code = c_book_type_code and

Line 2405: from fa_methods mt,

2401: -- Fix for Bug #6334489. Do not allow addition of asset with
2402: -- revised rate.
2403: select count(*)
2404: into l_revised_count
2405: from fa_methods mt,
2406: fa_formulas f
2407: where mt.method_code = p_asset_fin_rec.deprn_method_code
2408: and mt.life_in_months = p_asset_fin_rec.life_in_months
2409: and mt.method_id = f.method_id

Line 2458: , FA_METHODS FM

2454: INTO l_original_Rate
2455: , l_Revised_Rate
2456: , l_Guaranteed_Rate
2457: FROM FA_FORMULAS FF
2458: , FA_METHODS FM
2459: WHERE FF.METHOD_ID = FM.METHOD_ID
2460: AND FM.METHOD_CODE = p_asset_fin_rec.deprn_method_code;
2461: EXCEPTION
2462: WHEN OTHERS THEN