119: , a.pl_bnf_id pl_bnf_id
120: from ben_pl_bnf_f a,
121: ben_per_in_ler pil,
122: per_contact_relationships b,
123: per_all_people_f c
124: where
125: a.prtt_enrt_rslt_id = l_prtt_enrt_rslt_id
126: and a.bnf_person_id = b.contact_person_id
127: and b.person_id = p_person_id
188: h.phone_number phone_home
189: , w.phone_number phone_work
190: , f.phone_number phone_fax
191: , m.phone_number phone_mobile
192: from per_all_people_f p
193: , per_phones h
194: , per_phones w
195: , per_phones f
196: , per_phones m
200: and h.parent_id (+) = p.person_id
201: and w.parent_id (+) = p.person_id
202: and f.parent_id (+) = p.person_id
203: and m.parent_id (+) = p.person_id
204: and h.parent_table (+) = 'PER_ALL_PEOPLE_F'
205: and w.parent_table (+) = 'PER_ALL_PEOPLE_F'
206: and f.parent_table (+) = 'PER_ALL_PEOPLE_F'
207: and m.parent_table (+) = 'PER_ALL_PEOPLE_F'
208: and h.phone_type (+) = 'H1'
201: and w.parent_id (+) = p.person_id
202: and f.parent_id (+) = p.person_id
203: and m.parent_id (+) = p.person_id
204: and h.parent_table (+) = 'PER_ALL_PEOPLE_F'
205: and w.parent_table (+) = 'PER_ALL_PEOPLE_F'
206: and f.parent_table (+) = 'PER_ALL_PEOPLE_F'
207: and m.parent_table (+) = 'PER_ALL_PEOPLE_F'
208: and h.phone_type (+) = 'H1'
209: and w.phone_type (+) = 'W1'
202: and f.parent_id (+) = p.person_id
203: and m.parent_id (+) = p.person_id
204: and h.parent_table (+) = 'PER_ALL_PEOPLE_F'
205: and w.parent_table (+) = 'PER_ALL_PEOPLE_F'
206: and f.parent_table (+) = 'PER_ALL_PEOPLE_F'
207: and m.parent_table (+) = 'PER_ALL_PEOPLE_F'
208: and h.phone_type (+) = 'H1'
209: and w.phone_type (+) = 'W1'
210: and f.phone_type (+) = 'WF'
203: and m.parent_id (+) = p.person_id
204: and h.parent_table (+) = 'PER_ALL_PEOPLE_F'
205: and w.parent_table (+) = 'PER_ALL_PEOPLE_F'
206: and f.parent_table (+) = 'PER_ALL_PEOPLE_F'
207: and m.parent_table (+) = 'PER_ALL_PEOPLE_F'
208: and h.phone_type (+) = 'H1'
209: and w.phone_type (+) = 'W1'
210: and f.phone_type (+) = 'WF'
211: and m.phone_type (+) = 'M'
224: h.phone_number phone_home
225: , w.phone_number phone_work
226: , f.phone_number phone_fax
227: , m.phone_number phone_mobile
228: from per_all_people_f p
229: , per_phones h
230: , per_phones w
231: , per_phones f
232: , per_phones m
239: and h.parent_id (+) = p.person_id
240: and w.parent_id (+) = p.person_id
241: and f.parent_id (+) = p.person_id
242: and m.parent_id (+) = p.person_id
243: and h.parent_table (+) = 'PER_ALL_PEOPLE_F'
244: and w.parent_table (+) = 'PER_ALL_PEOPLE_F'
245: and f.parent_table (+) = 'PER_ALL_PEOPLE_F'
246: and m.parent_table (+) = 'PER_ALL_PEOPLE_F'
247: and h.phone_type (+) = 'H1'
240: and w.parent_id (+) = p.person_id
241: and f.parent_id (+) = p.person_id
242: and m.parent_id (+) = p.person_id
243: and h.parent_table (+) = 'PER_ALL_PEOPLE_F'
244: and w.parent_table (+) = 'PER_ALL_PEOPLE_F'
245: and f.parent_table (+) = 'PER_ALL_PEOPLE_F'
246: and m.parent_table (+) = 'PER_ALL_PEOPLE_F'
247: and h.phone_type (+) = 'H1'
248: and w.phone_type (+) = 'W1'
241: and f.parent_id (+) = p.person_id
242: and m.parent_id (+) = p.person_id
243: and h.parent_table (+) = 'PER_ALL_PEOPLE_F'
244: and w.parent_table (+) = 'PER_ALL_PEOPLE_F'
245: and f.parent_table (+) = 'PER_ALL_PEOPLE_F'
246: and m.parent_table (+) = 'PER_ALL_PEOPLE_F'
247: and h.phone_type (+) = 'H1'
248: and w.phone_type (+) = 'W1'
249: and f.phone_type (+) = 'WF'
242: and m.parent_id (+) = p.person_id
243: and h.parent_table (+) = 'PER_ALL_PEOPLE_F'
244: and w.parent_table (+) = 'PER_ALL_PEOPLE_F'
245: and f.parent_table (+) = 'PER_ALL_PEOPLE_F'
246: and m.parent_table (+) = 'PER_ALL_PEOPLE_F'
247: and h.phone_type (+) = 'H1'
248: and w.phone_type (+) = 'W1'
249: and f.phone_type (+) = 'WF'
250: and m.phone_type (+) = 'M'