SELECT PROFILE.PROFILE_ID , ELE.PROJECT_ROLE_ID , ROLE.MEANING , ELE.ROLE_WEIGHTING FROM PA_ROLE_PROFILES PROFILE , PA_ROLE_PROFILE_LINES ELE , PA_PROJECT_ROLE_TYPES ROLE WHERE PROFILE.PROFILE_ID = ELE.PROFILE_ID AND ELE.PROJECT_ROLE_ID = ROLE.PROJECT_ROLE_ID