DBA Data[Home] [Help]

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'