APPS.CS_SERVICEREQUEST_UTIL dependencies on HZ_CONTACT_POINTS
Line 5063: FROM HZ_CONTACT_POINTS a
5059: -- Initialize the return status.
5060: x_return_status := FND_API.G_RET_STS_SUCCESS;
5061:
5062: SELECT a.contact_point_id INTO l_test 5063: FROM HZ_CONTACT_POINTS a 5064: WHERE a.contact_point_type = p_contact_point_type
5065: AND a.contact_point_id = p_contact_point_id
5066: AND a.OWNER_TABLE_ID = p_party_id
5067: AND a.OWNER_TABLE_NAME = 'HZ_PARTIES'