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

Line 164: per_all_people_f c

160: , c.uses_tobacco_flag
161: , c.previous_last_name
162: from ben_elig_dpnt a,
163: per_contact_relationships b,
164: per_all_people_f c
165: where
166: a.elig_per_elctbl_chc_id = l_elig_per_elctbl_chc_id
167: and a.dpnt_inelig_flag = 'N'
168: and a.dpnt_person_id = b.contact_person_id

Line 226: from per_all_people_f p

222: h.phone_number phone_home
223: , w.phone_number phone_work
224: , f.phone_number phone_fax
225: , m.phone_number phone_mobile
226: from per_all_people_f p
227: , per_phones h
228: , per_phones w
229: , per_phones f
230: , per_phones m

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

234: and h.parent_id (+) = p.person_id
235: and w.parent_id (+) = p.person_id
236: and f.parent_id (+) = p.person_id
237: and m.parent_id (+) = p.person_id
238: and h.parent_table (+) = 'PER_ALL_PEOPLE_F'
239: and w.parent_table (+) = 'PER_ALL_PEOPLE_F'
240: and f.parent_table (+) = 'PER_ALL_PEOPLE_F'
241: and m.parent_table (+) = 'PER_ALL_PEOPLE_F'
242: and h.phone_type (+) = 'H1'

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

235: and w.parent_id (+) = p.person_id
236: and f.parent_id (+) = p.person_id
237: and m.parent_id (+) = p.person_id
238: and h.parent_table (+) = 'PER_ALL_PEOPLE_F'
239: and w.parent_table (+) = 'PER_ALL_PEOPLE_F'
240: and f.parent_table (+) = 'PER_ALL_PEOPLE_F'
241: and m.parent_table (+) = 'PER_ALL_PEOPLE_F'
242: and h.phone_type (+) = 'H1'
243: and w.phone_type (+) = 'W1'

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

236: and f.parent_id (+) = p.person_id
237: and m.parent_id (+) = p.person_id
238: and h.parent_table (+) = 'PER_ALL_PEOPLE_F'
239: and w.parent_table (+) = 'PER_ALL_PEOPLE_F'
240: and f.parent_table (+) = 'PER_ALL_PEOPLE_F'
241: and m.parent_table (+) = 'PER_ALL_PEOPLE_F'
242: and h.phone_type (+) = 'H1'
243: and w.phone_type (+) = 'W1'
244: and f.phone_type (+) = 'WF'

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

237: and m.parent_id (+) = p.person_id
238: and h.parent_table (+) = 'PER_ALL_PEOPLE_F'
239: and w.parent_table (+) = 'PER_ALL_PEOPLE_F'
240: and f.parent_table (+) = 'PER_ALL_PEOPLE_F'
241: and m.parent_table (+) = 'PER_ALL_PEOPLE_F'
242: and h.phone_type (+) = 'H1'
243: and w.phone_type (+) = 'W1'
244: and f.phone_type (+) = 'WF'
245: and m.phone_type (+) = 'M'