HRMS LOOKUP Query in Oracle Apps

SELECT   papf.Last_Name,
         papf.First_Name,
         papf.Title,
         hl_sex.meaning,
         pptt.user_person_type,
         papf.national_identifier SSN,
         papf.date_of_birth,
         hl_nat.meaning Nationality,
         TRUNC (MONTHS_BETWEEN (SYSDATE, papf.date_of_birth) / 12) Age,
         hl_mar.meaning Marital_Status,
         papf.Effective_Start_Date,
         papf.Effective_End_Date,
         hl_eth.meaning Ethnic_Origin,
         papf.Email_address,
         papf.original_date_of_hire Date_First_Hired
  FROM   per_all_people_f papf,
         hr_lookups hl_sex,
         per_person_types_tl pptt,
         hr_lookups hl_nat,
         hr_lookups hl_mar,
         hr_lookups hl_eth
 WHERE       1 = 1
         AND hl_sex.lookup_code(+) = papf.sex
         AND hl_sex.lookup_type(+) = 'SEX'
         AND hl_nat.lookup_code(+) = papf.nationality
         AND hl_nat.lookup_type(+) = 'NATIONALITY'
         AND hl_mar.lookup_code(+) = papf.marital_status
         AND hl_mar.lookup_type(+) = 'MAR_STATUS'
         AND hl_eth.lookup_code(+) = papf.per_information1
         AND hl_eth.lookup_type(+) = 'US_ETHNIC_GROUP'
         AND papf.person_type_id = pptt.person_type_id
         AND papf.effective_end_date > SYSDATE
         AND papf.person_id = &Person_ID;