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

Line 128: per_all_people_f c

124: , c.uses_tobacco_flag
125: , c.previous_last_name
126: from ben_elig_cvrd_dpnt_f a,
127: per_contact_relationships b,
128: per_all_people_f c
129: where
130: a.prtt_enrt_rslt_id = l_prtt_enrt_rslt_id
131: and a.cvg_pndg_flag = 'N'
132: -- remarked for bug 1394604

Line 219: from per_all_people_f p

215: h.phone_number phone_home
216: , w.phone_number phone_work
217: , f.phone_number phone_fax
218: , m.phone_number phone_mobile
219: from per_all_people_f p
220: , per_phones h
221: , per_phones w
222: , per_phones f
223: , per_phones m

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

227: and h.parent_id (+) = p.person_id
228: and w.parent_id (+) = p.person_id
229: and f.parent_id (+) = p.person_id
230: and m.parent_id (+) = p.person_id
231: and h.parent_table (+) = 'PER_ALL_PEOPLE_F'
232: and w.parent_table (+) = 'PER_ALL_PEOPLE_F'
233: and f.parent_table (+) = 'PER_ALL_PEOPLE_F'
234: and m.parent_table (+) = 'PER_ALL_PEOPLE_F'
235: and h.phone_type (+) = 'H1'

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

228: and w.parent_id (+) = p.person_id
229: and f.parent_id (+) = p.person_id
230: and m.parent_id (+) = p.person_id
231: and h.parent_table (+) = 'PER_ALL_PEOPLE_F'
232: and w.parent_table (+) = 'PER_ALL_PEOPLE_F'
233: and f.parent_table (+) = 'PER_ALL_PEOPLE_F'
234: and m.parent_table (+) = 'PER_ALL_PEOPLE_F'
235: and h.phone_type (+) = 'H1'
236: and w.phone_type (+) = 'W1'

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

229: and f.parent_id (+) = p.person_id
230: and m.parent_id (+) = p.person_id
231: and h.parent_table (+) = 'PER_ALL_PEOPLE_F'
232: and w.parent_table (+) = 'PER_ALL_PEOPLE_F'
233: and f.parent_table (+) = 'PER_ALL_PEOPLE_F'
234: and m.parent_table (+) = 'PER_ALL_PEOPLE_F'
235: and h.phone_type (+) = 'H1'
236: and w.phone_type (+) = 'W1'
237: and f.phone_type (+) = 'WF'

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

230: and m.parent_id (+) = p.person_id
231: and h.parent_table (+) = 'PER_ALL_PEOPLE_F'
232: and w.parent_table (+) = 'PER_ALL_PEOPLE_F'
233: and f.parent_table (+) = 'PER_ALL_PEOPLE_F'
234: and m.parent_table (+) = 'PER_ALL_PEOPLE_F'
235: and h.phone_type (+) = 'H1'
236: and w.phone_type (+) = 'W1'
237: and f.phone_type (+) = 'WF'
238: and m.phone_type (+) = 'M'