PL/SQL & SQL CODING GUIDELINE 13 - Avoid initializing variables using functions in the declaration section 11-26
PL/SQL & SQL CODING GUIDELINE 10 - Try to use subtypes for constructs used often in your application 11-24