Query to get Employee Contract Duration in Oracle Apps

Nav: Global HRMS Manager--> People-->Enter and Maintain--> Query Employee--> Click on Others Button-->Select Contract from List

select papf.person_id ,papf.employee_number ,papf.full_name ,pcf.duration ,hl.meaning Units from per_all_people_f papf ,per_contracts_f pcf ,hr_lookups hl where papf.person_id = pcf.person_id AND papf.person_id = :p_person_id AND NVL (TRUNC (papf.effective_end_date), SYSDATE) >= TRUNC (SYSDATE) AND NVL (TRUNC (pcf.effective_end_date), SYSDATE) >= TRUNC (SYSDATE) AND pcf.duration_units = hl.lookup_code AND hl.lookup_type(+) = 'QUALIFYING_UNITS'