FA Depreciation Rate Listing - draft

select 	methods.method_code		method_code,
	methods.name			name,
	methods.life_in_months 		life,
	methods.stl_method_flag		stl_flag,
	methods.depreciate_lastyear_flag	flag,
	rates.year				year,
	rates.period_placed_in_service	period_placed_in_service,
	rates.rate				rate, 
	FA_FAS911_XMLP_PKG.d_lifeformula(methods.life_in_months) D_LIFE
from
	fa_methods	methods,
	fa_rates		rates
where
	methods.method_id = rates.method_id	and
	methods.method_code = nvl(:p_method_code, methods.method_code)	and
	methods.life_in_months = nvl(:p_life_in_months, methods.life_in_months)
order by 
	methods.method_code,
	methods.life_in_months,
	rates.year,
	rates.period_placed_in_service

select methods.method_code method_code, methods.name name, methods.life_in_months life, methods.stl_method_flag stl_flag, methods.depreciate_lastyear_flag flag, rates.year year, rates.period_placed_in_service period_placed_in_service, rates.rate rate, FA_FAS911_XMLP_PKG.d_lifeformula(methods.life_in_months) D_LIFE from fa_methods methods, fa_rates rates where methods.method_id = rates.method_id and methods.method_code = nvl(:p_method_code, methods.method_code) and methods.life_in_months = nvl(:p_life_in_months, methods.life_in_months) order by methods.method_code, methods.life_in_months, rates.year, rates.period_placed_in_service