SELECT FULL_NAME AS FULL_NAME , FLOOR(MONTHS_BETWEEN(F.EFFECTIVE_DATE , DATE_OF_BIRTH)/12) AS AGE , SEX AS SEX , HR_GENERAL.DECODE_LOOKUP('SEX' , SEX) AS SEX_MEANING , NATIONAL_IDENTIFIER AS NATIONAL_IDENTIFIER , A.ASSIGNMENT_ID AS ASSIGNMENT_ID , A.ASSIGNMENT_NUMBER AS ASSIGNMENT_NUMBER , HR_ES_UTILITY.GET_DISABILITY_DEGREE(P.PERSON_ID , F.EFFECTIVE_DATE) AS DISABILITY_DEGREE FROM PER_ALL_PEOPLE_F P , PER_ALL_ASSIGNMENTS_F A , FND_SESSIONS F WHERE A.PERSON_ID=P.PERSON_ID AND F.SESSION_ID = USERENV('SESSIONID') AND F.EFFECTIVE_DATE BETWEEN P.EFFECTIVE_START_DATE AND P.EFFECTIVE_END_DATE AND F.EFFECTIVE_DATE BETWEEN A.EFFECTIVE_START_DATE AND A.EFFECTIVE_END_DATE