APPS.CSF_TASKS_PUB dependencies on HZ_CONTACT_POINTS

Line 4259: FROM hz_contact_points cp

4255: || DECODE(cp.phone_area_code, '', '', NULL, '', cp.phone_area_code || '-')
4256: || cp.phone_number phone
4257: , cp.phone_extension
4258: , cp.email_address
4259: FROM hz_contact_points cp
4260: , ar_lookups ar
4261: WHERE cp.contact_point_id = l_contact_point_id
4262: AND cp.contact_point_type IN ('EMAIL', 'PHONE')
4263: AND cp.phone_line_type = ar.lookup_code (+)