223: , w.phone_number phone_work
224: , f.phone_number phone_fax
225: , m.phone_number phone_mobile
226: from per_all_people_f p
227: , per_phones h
228: , per_phones w
229: , per_phones f
230: , per_phones m
231: where p.person_id = p_dpnt_person_id
224: , f.phone_number phone_fax
225: , m.phone_number phone_mobile
226: from per_all_people_f p
227: , per_phones h
228: , per_phones w
229: , per_phones f
230: , per_phones m
231: where p.person_id = p_dpnt_person_id
232: and p_effective_date between nvl(p.effective_start_date, p_effective_date)
225: , m.phone_number phone_mobile
226: from per_all_people_f p
227: , per_phones h
228: , per_phones w
229: , per_phones f
230: , per_phones m
231: where p.person_id = p_dpnt_person_id
232: and p_effective_date between nvl(p.effective_start_date, p_effective_date)
233: and nvl(p.effective_end_date, p_effective_date)
226: from per_all_people_f p
227: , per_phones h
228: , per_phones w
229: , per_phones f
230: , per_phones m
231: where p.person_id = p_dpnt_person_id
232: and p_effective_date between nvl(p.effective_start_date, p_effective_date)
233: and nvl(p.effective_end_date, p_effective_date)
234: and h.parent_id (+) = p.person_id