APPS.CSF_TASKS_PUB dependencies on CS_HZ_SR_CONTACT_POINTS

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

4263: AND cp.phone_line_type = ar.lookup_code (+)
4264: AND ar.lookup_type(+) = 'PHONE_LINE_TYPE';
4265:
4266: -- Cursor to fetch information regarding HRMS Employees
4267: -- We require joining again with cs_hz_sr_contact_points so that the OUTER
4268: -- Join on Phone ID works properly. If its a constant, it expects a NOT NULL
4269: -- Value.
4270: CURSOR c_emp_info IS
4271: SELECT p.last_name

Line 4276: FROM cs_hz_sr_contact_points sr_cp

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