HRMS Relationship Query

SELECT rel.person_id person_id,

       rel.contact_person_id contact_person_id,

       per.full_name,

       per.date_of_birth,

       hr_general.decode_lookup ('SEX', per.sex) gender,

       (SELECT look_up.meaning

          FROM hr_lookups look_up

         WHERE look_up.lookup_type = 'CONTACT'

           AND look_up.enabled_flag = 'Y'

           AND look_up.lookup_code = rel.contact_type) relation

  FROM per_contact_relationships rel,

       per_people_f per

 WHERE rel.contact_person_id = per.person_id

   AND per.business_group_id = hr_general.get_business_group_id