Query to get Employee Dependent(Contact) Details in Oracle APPS

SELECT papf.person_id employee_id,

       papf.employee_number,

       papf.full_name employee_name,

       papf.effective_start_date employee_start_date,

       papf.effective_end_date employee_end_date,

       papf_cont.full_name contact_name,

       hl.meaning contact_type,

       pcr.date_start contact_start_date,

       pcr.date_end contact_end_date,

       pcr.primary_contact_flag,

       pcr.personal_flag,

       pcr.dependent_flag,

       pcr.beneficiary_flag

  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