186: , w.phone_number phone_work
187: , f.phone_number phone_fax
188: , m.phone_number phone_mobile
189: from per_all_people_f p
190: , per_phones h
191: , per_phones w
192: , per_phones f
193: , per_phones m
194: where p.person_id = p_contact_person_id
187: , f.phone_number phone_fax
188: , m.phone_number phone_mobile
189: from per_all_people_f p
190: , per_phones h
191: , per_phones w
192: , per_phones f
193: , per_phones m
194: where p.person_id = p_contact_person_id
195: and p_effective_date between nvl(p.effective_start_date, p_effective_date)
188: , m.phone_number phone_mobile
189: from per_all_people_f p
190: , per_phones h
191: , per_phones w
192: , per_phones f
193: , per_phones m
194: where p.person_id = p_contact_person_id
195: and p_effective_date between nvl(p.effective_start_date, p_effective_date)
196: and nvl(p.effective_end_date, p_effective_date)
189: from per_all_people_f p
190: , per_phones h
191: , per_phones w
192: , per_phones f
193: , per_phones m
194: where p.person_id = p_contact_person_id
195: and p_effective_date between nvl(p.effective_start_date, p_effective_date)
196: and nvl(p.effective_end_date, p_effective_date)
197: and h.parent_id (+) = p.person_id