102: and fy.end_date >= cp.end_date;
103:
104: CURSOR GET_RSR IS
105: select rate_source_rule
106: from fa_methods
107: where method_code = x_deprn_method;
108:
109: l_rsr varchar2(20);
110:
109: l_rsr varchar2(20);
110:
111: CURSOR CHECK_METHOD_EXISTS IS
112: select 'X'
113: from fa_methods
114: where method_code = x_deprn_method
115: and nvl(life_in_months,0) = x_life;
116:
117: l_dummy varchar2(1);
165: if l_rsr = 'TABLE' then
166: x_err_code := 'FA_REVAL_NO_METH_LIFE';
167: return;
168: else
169: FA_METHODS_PKG.Insert_Row(
170: X_Rowid => l_rowid,
171: X_Method_Id => l_method_id,
172: X_Method_Code => x_deprn_method,
173: X_Life_In_Months => x_life,