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 4925: , per_all_people_f p

4921: , p.title
4922: , pp.phone_number
4923: , p.email_address
4924: FROM cs_hz_sr_contact_points sr_cp
4925: , per_all_people_f p
4926: , per_phones pp
4927: , hr_lookups hrl
4928: WHERE sr_cp.incident_id = p_incident_id
4929: AND sr_cp.primary_flag = 'Y'

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

4928: WHERE sr_cp.incident_id = p_incident_id
4929: AND sr_cp.primary_flag = 'Y'
4930: AND p.person_id = sr_cp.party_id
4931: AND pp.phone_id(+) = sr_cp.contact_point_id
4932: AND pp.parent_table(+) = 'PER_ALL_PEOPLE_F'
4933: AND hrl.lookup_code(+) = pp.phone_type
4934: AND hrl.lookup_type(+) = 'PHONE_TYPE'
4935: ORDER BY p.effective_end_date desc;
4936: