DBA Data[Home] [Help]

APPS.FA_ADDITION_PVT dependencies on FA_FORMULAS

Line 2406: fa_formulas f

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
2410: and f.revised_rate = l_rate_in_use;

Line 2457: FROM FA_FORMULAS FF

2453: , FF.guarantee_rate
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