Monday, February 25, 2013

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

No comments:

Post a Comment

Best Blogger TipsGet Flower Effect