SELECT PROJECT_ROLE_ID PROJECT_ROLE_ID , MEANING MEANING , DESCRIPTION DESCRIPTION , 'PROJECT_ROLE' FROM PA_PROJECT_ROLE_TYPES_TL WHERE LANGUAGE=USERENV('LANG') UNION SELECT TO_NUMBER(ATTRIBUTE1) , MEANING , DESCRIPTION , LOOKUP_CODE FROM PA_LOOKUPS WHERE LOOKUP_TYPE = 'PA_NOTIFICATION_ROLE'