Employee Details Query

SELECT PAPF.EMPLOYEE_NUMBER
, PAPF.FIRST_NAME
, PAPF.LAST_NAME
, PAPF.EMAIL_ADDRESS
, PAAF.SUPERVISOR_ID
, PAPF1.EMPLOYEE_NUMBER SUPV_EMPL_NUMBER
, PAPF1.FIRST_NAME SUPV_F_NAME
, PAPF1.LAST_NAME SUPV_L_NAME
, HLOC.LOCATION_CODE LOCATION
, HAOU.NAME ORG_NAME
, PP.NAME POSITION
, PG.NAME GRADE
, PJ.NAME MANAGERIAL_LEVEL
, PAPF.START_DATE
, PAPF.SEX GENDER
, PAPF.DATE_OF_BIRTH BIRTH_DATE
--, PAPF.COUNTRY_OF_BIRTH
, FT.TERRITORY_SHORT_NAME NATIONALITY
, HL.MEANING MARITAL_STATUS
FROM PER_ALL_PEOPLE_F PAPF
, PER_ALL_PEOPLE_F PAPF1
, PER_ALL_ASSIGNMENTS_F PAAF
, PER_POSITIONS PP
, PER_JOBS PJ
, PER_GRADES PG
, FND_TERRITORIES_TL FT
, HR_LOOKUPS HL
, HR_LOCATIONS HLOC
, HR_ALL_ORGANIZATION_UNITS HAOU
WHERE SYSDATE BETWEEN PAPF.EFFECTIVE_START_DATE AND PAPF.EFFECTIVE_END_DATE
AND SYSDATE BETWEEN PAAF.EFFECTIVE_START_DATE AND PAAF.EFFECTIVE_END_DATE
AND PAPF.PERSON_ID = PAAF.PERSON_ID
AND PAAF.PRIMARY_FLAG = 'Y'
AND PAPF.PERSON_TYPE_ID IN (1120, 1121)
AND PAAF.POSITION_ID = PP.POSITION_ID(+)
AND PAAF.JOB_ID = PJ.JOB_ID(+)
AND PAAF.GRADE_ID = PG.GRADE_ID(+)
AND PAPF.COUNTRY_OF_BIRTH = FT.TERRITORY_CODE(+)
AND HL.LOOKUP_TYPE(+) = 'MAR_STATUS'
AND PAPF.MARITAL_STATUS = HL.LOOKUP_CODE(+)
AND PAAF.SUPERVISOR_ID = PAPF1.PERSON_ID(+)
AND SYSDATE BETWEEN PAPF1.EFFECTIVE_START_DATE(+) AND PAPF1.EFFECTIVE_END_DATE(+)
AND PAAF.LOCATION_ID = HLOC.LOCATION_ID(+)
AND PAAF.ORGANIZATION_ID = HAOU.ORGANIZATION_ID
AND PAPF.EMPLOYEE_NUMBER <> '1'
AND PAPF.EMPLOYEE_NUMBER NOT LIKE 'EDR%'