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_CONTACT dependencies on PER_ALL_PEOPLE_F

Line 132: per_all_people_f c

128: , c.uses_tobacco_flag
129: , c.previous_last_name
130: from
131: per_contact_relationships b,
132: per_all_people_f c
133: where
134: c.person_id = b.contact_person_id
135: and b.person_id = p_person_id
136: and p_effective_date between c.effective_start_date

Line 189: from per_all_people_f p

185: h.phone_number phone_home
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

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

197: and h.parent_id (+) = p.person_id
198: and w.parent_id (+) = p.person_id
199: and f.parent_id (+) = p.person_id
200: and m.parent_id (+) = p.person_id
201: and h.parent_table (+) = 'PER_ALL_PEOPLE_F'
202: and w.parent_table (+) = 'PER_ALL_PEOPLE_F'
203: and f.parent_table (+) = 'PER_ALL_PEOPLE_F'
204: and m.parent_table (+) = 'PER_ALL_PEOPLE_F'
205: and h.phone_type (+) = 'H1'

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

198: and w.parent_id (+) = p.person_id
199: and f.parent_id (+) = p.person_id
200: and m.parent_id (+) = p.person_id
201: and h.parent_table (+) = 'PER_ALL_PEOPLE_F'
202: and w.parent_table (+) = 'PER_ALL_PEOPLE_F'
203: and f.parent_table (+) = 'PER_ALL_PEOPLE_F'
204: and m.parent_table (+) = 'PER_ALL_PEOPLE_F'
205: and h.phone_type (+) = 'H1'
206: and w.phone_type (+) = 'W1'

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

199: and f.parent_id (+) = p.person_id
200: and m.parent_id (+) = p.person_id
201: and h.parent_table (+) = 'PER_ALL_PEOPLE_F'
202: and w.parent_table (+) = 'PER_ALL_PEOPLE_F'
203: and f.parent_table (+) = 'PER_ALL_PEOPLE_F'
204: and m.parent_table (+) = 'PER_ALL_PEOPLE_F'
205: and h.phone_type (+) = 'H1'
206: and w.phone_type (+) = 'W1'
207: and f.phone_type (+) = 'WF'

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

200: and m.parent_id (+) = p.person_id
201: and h.parent_table (+) = 'PER_ALL_PEOPLE_F'
202: and w.parent_table (+) = 'PER_ALL_PEOPLE_F'
203: and f.parent_table (+) = 'PER_ALL_PEOPLE_F'
204: and m.parent_table (+) = 'PER_ALL_PEOPLE_F'
205: and h.phone_type (+) = 'H1'
206: and w.phone_type (+) = 'W1'
207: and f.phone_type (+) = 'WF'
208: and m.phone_type (+) = 'M'