[Home] [Help]
1153: if (X_life is not null and X_life <> 0) then
1154:
1155: SELECT *
1156: INTO fazccmt_record
1157: FROM fa_methods
1158: WHERE method_code = X_method
1159: AND life_in_months = X_life;
1160:
1161: else
1161: else
1162:
1163: SELECT *
1164: INTO fazccmt_record
1165: FROM fa_methods
1166: WHERE method_code = X_method
1167: AND (life_in_months is null OR
1168: life_in_months = 0);
1169:
1216: exception
1217: when no_data_found then
1218:
1219: -- For Japan Tax reform, when loading seed formula rates,
1220: -- the record in fa_methods will exist, but the one in
1221: -- fa_formulas will not exist.
1222: fazcfor_record.method_id := null;
1223: fazcfor_record.formula_actual := null;
1224: fazcfor_record.formula_displayed := null;