APPS.CSZ_SERVICEREQUEST_UTIL_PVT dependencies on HZ_CONTACT_POINTS

Line 856: FROM hz_contact_points

852:
853: if p_contact_point_id is not null then
854: SELECT timezone_id
855: INTO l_timezone_id
856: FROM hz_contact_points
857: WHERE contact_point_id = p_contact_point_id
858: AND status = 'A' ;
859: if l_timezone_id is not null then
860: SELECT name ,