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.CSF_TASKS_PUB dependencies on PER_ALL_PEOPLE_F

Line 4277: , per_all_people_f p

4273: , p.title
4274: , pp.phone_number
4275: , p.email_address
4276: FROM cs_hz_sr_contact_points sr_cp
4277: , per_all_people_f p
4278: , per_phones pp
4279: , hr_lookups hrl
4280: WHERE sr_cp.incident_id = p_incident_id
4281: AND sr_cp.primary_flag = 'Y'

Line 4284: AND pp.parent_table(+) = 'PER_ALL_PEOPLE_F'

4280: WHERE sr_cp.incident_id = p_incident_id
4281: AND sr_cp.primary_flag = 'Y'
4282: AND p.person_id = sr_cp.party_id
4283: AND pp.phone_id(+) = sr_cp.contact_point_id
4284: AND pp.parent_table(+) = 'PER_ALL_PEOPLE_F'
4285: AND hrl.lookup_code(+) = pp.phone_type
4286: AND hrl.lookup_type(+) = 'PHONE_TYPE'
4287: ORDER BY p.effective_end_date desc;
4288: