APPS.ARPT_SQL_FUNC_UTIL dependencies on HZ_CONTACT_POINTS

Line 2147: FROM hz_contact_points cont_point

2143: cont_point.telex_number, cont_point.phone_number),
2144: cont_point.phone_area_code,
2145: cont_point.phone_extension
2146: INTO l_ph_num, l_area_code, l_ext
2147: FROM hz_contact_points cont_point
2148: WHERE cont_point.contact_point_id = p_phone_id;
2149:
2150: pg_phone_rec(p_phone_id).extension := l_ext;
2151: pg_phone_rec(p_phone_id).area_code := l_area_code;