APPS.BEN_EXT_BNF dependencies on PER_PHONES

Line 193: , per_phones h

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
197: where p.person_id = c_person_id

Line 194: , per_phones w

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
197: where p.person_id = c_person_id
198: and p_effective_date between nvl(p.effective_start_date, p_effective_date)

Line 195: , per_phones f

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
197: where p.person_id = c_person_id
198: and p_effective_date between nvl(p.effective_start_date, p_effective_date)
199: and nvl(p.effective_end_date, p_effective_date)

Line 196: , per_phones m

192: from per_all_people_f p
193: , per_phones h
194: , per_phones w
195: , per_phones f
196: , per_phones m
197: where p.person_id = c_person_id
198: and p_effective_date between nvl(p.effective_start_date, p_effective_date)
199: and nvl(p.effective_end_date, p_effective_date)
200: and h.parent_id (+) = p.person_id

Line 229: , per_phones h

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
233: , per_contact_relationships r

Line 230: , per_phones w

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
233: , per_contact_relationships r
234: where r.contact_person_id = c_person_id

Line 231: , per_phones f

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
233: , per_contact_relationships r
234: where r.contact_person_id = c_person_id
235: and p.person_id = r.person_id

Line 232: , per_phones m

228: from per_all_people_f p
229: , per_phones h
230: , per_phones w
231: , per_phones f
232: , per_phones m
233: , per_contact_relationships r
234: where r.contact_person_id = c_person_id
235: and p.person_id = r.person_id
236: and r.rltd_per_rsds_w_dsgntr_flag = 'Y'