Oracle Message PLS-00402 - alias required in SELECT list of cursor to avoid duplicate column names

ERRORalias required in SELECT list of cursor to avoid duplicate column names
CAUSEA cursor was declared with a SELECT statement that contains duplicate column names. Such references are ambiguous.
ACTIONReplace the duplicate column name in the select list with an alias.