Watch out for always using an IF statement, consider using a CASE expression, in SQL as well as PL/SQL, and then look for opportunities to use CASE statements as well.