APPS.CSF_TASKS_PUB dependencies on CS_HZ_SR_CONTACT_POINTS

Line 4915: -- We require joining again with cs_hz_sr_contact_points so that the OUTER

4911: AND cp.phone_line_type = ar.lookup_code (+)
4912: AND ar.lookup_type(+) = 'PHONE_LINE_TYPE';
4913:
4914: -- Cursor to fetch information regarding HRMS Employees
4915: -- We require joining again with cs_hz_sr_contact_points so that the OUTER
4916: -- Join on Phone ID works properly. If its a constant, it expects a NOT NULL
4917: -- Value.
4918: CURSOR c_emp_info IS
4919: SELECT p.last_name

Line 4924: FROM cs_hz_sr_contact_points sr_cp

4920: , p.first_name
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