SELECT A.ASSIGNMENT_LEVEL , K.K_HEADER_ID , K.K_NUMBER_DISP , A.PERSON_ID , H.FULL_NAME , A.ROLE_ID , R.MEANING , A.START_DATE_ACTIVE , A.END_DATE_ACTIVE FROM OKE_K_ALL_ACCESS_BASIC_V A , OKE_K_HEADERS K , PA_PROJECT_ROLE_TYPES R , PER_ALL_PEOPLE_F H WHERE K.K_HEADER_ID = A.K_HEADER_ID AND R.PROJECT_ROLE_ID = A.ROLE_ID AND H.PERSON_ID = A.PERSON_ID AND TRUNC(A.CREATION_DATE) BETWEEN TRUNC(H.EFFECTIVE_START_DATE) AND TRUNC(H.EFFECTIVE_END_DATE)