Query to get Employee Dependent Date Of Birth(Contact Information) in Oracle APPS

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

SELECT papf.person_id ,papf.employee_number ,papf.full_name employee_name ,papf_cont.full_name contact_name ,TO_CHAR(papf_cont.date_of_birth, 'DD-MON-RRRR') contact_date_of_birth ,hl.meaning contact_type FROM per_contact_relationships pcr ,per_all_people_f papf ,hr_lookups hl ,per_all_people_f papf_cont WHERE 1 = 1 AND papf.person_id = pcr.person_id AND pcr.contact_person_id = papf_cont.person_id AND NVL (TRUNC (papf.effective_end_date), SYSDATE) >= TRUNC (SYSDATE) AND NVL (TRUNC (papf_cont.effective_end_date), SYSDATE) >= TRUNC (SYSDATE) AND hl.lookup_type(+) = 'CONTACT' AND hl.lookup_code(+) = pcr.contact_type AND papf.person_id = :p_person_id