1430: if (X_life is not null and X_life <> 0) then
1431:
1432: SELECT *
1433: INTO fazccmt_record 1434: FROM fa_methods 1435: WHERE method_code = X_method
1436: AND life_in_months = X_life;
1437:
1438: else
Line 1442: FROM fa_methods
1438: else
1439:
1440: SELECT *
1441: INTO fazccmt_record 1442: FROM fa_methods 1443: WHERE method_code = X_method
1444: AND (life_in_months is null OR
1445: life_in_months = 0);
1446: