216: , w.phone_number phone_work
217: , f.phone_number phone_fax
218: , m.phone_number phone_mobile
219: from per_all_people_f p
220: , per_phones h
221: , per_phones w
222: , per_phones f
223: , per_phones m
224: where p.person_id = p_dpnt_person_id
217: , f.phone_number phone_fax
218: , m.phone_number phone_mobile
219: from per_all_people_f p
220: , per_phones h
221: , per_phones w
222: , per_phones f
223: , per_phones m
224: where p.person_id = p_dpnt_person_id
225: and p_effective_date between nvl(p.effective_start_date, p_effective_date)
218: , m.phone_number phone_mobile
219: from per_all_people_f p
220: , per_phones h
221: , per_phones w
222: , per_phones f
223: , per_phones m
224: where p.person_id = p_dpnt_person_id
225: and p_effective_date between nvl(p.effective_start_date, p_effective_date)
226: and nvl(p.effective_end_date, p_effective_date)
219: from per_all_people_f p
220: , per_phones h
221: , per_phones w
222: , per_phones f
223: , per_phones m
224: where p.person_id = p_dpnt_person_id
225: and p_effective_date between nvl(p.effective_start_date, p_effective_date)
226: and nvl(p.effective_end_date, p_effective_date)
227: and h.parent_id (+) = p.person_id