eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_EXT_BNF dependencies on PER_ALL_PEOPLE_F

Line 123: per_all_people_f c

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

Line 192: from per_all_people_f p

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

Line 204: and h.parent_table (+) = 'PER_ALL_PEOPLE_F'

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'

Line 205: and w.parent_table (+) = 'PER_ALL_PEOPLE_F'

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'

Line 206: and f.parent_table (+) = 'PER_ALL_PEOPLE_F'

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'

Line 207: and m.parent_table (+) = 'PER_ALL_PEOPLE_F'

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'

Line 228: from per_all_people_f p

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

Line 243: and h.parent_table (+) = 'PER_ALL_PEOPLE_F'

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'

Line 244: and w.parent_table (+) = 'PER_ALL_PEOPLE_F'

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'

Line 245: and f.parent_table (+) = 'PER_ALL_PEOPLE_F'

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'

Line 246: and m.parent_table (+) = 'PER_ALL_PEOPLE_F'

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'