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
ANDper.business_group_id =hr_general.get_business_group_id
No comments:
Post a Comment