DBA Data[Home] [Help]

APPS.CSF_TASKS_PUB dependencies on HR_LOOKUPS

Line 4927: , hr_lookups hrl

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'
4930: AND p.person_id = sr_cp.party_id
4931: AND pp.phone_id(+) = sr_cp.contact_point_id