You can define aliases for the columns and expressions in a cursor using the standard object AS correlation_name syntax. You must qualify any aliased object with the for_loop_variable name if you reference it within the loop.
You cannot reference a non-aliased cursor expression within the loop.