APPS.CS_SERVICEREQUEST_UTIL dependencies on AR_LOOKUPS

Line 3031: FROM ar_lookups

3027: x_return_status := FND_API.G_RET_STS_SUCCESS;
3028:
3029: BEGIN
3030: SELECT DISTINCT lookup_code INTO l_dummy
3031: FROM ar_lookups
3032: WHERE lookup_type = 'COMMUNICATION_TYPE'
3033: AND lookup_code = p_comm_pref_code;
3034:
3035: EXCEPTION

Line 5150: FROM AR_LOOKUPS

5146: x_return_status := FND_API.G_RET_STS_SUCCESS;
5147:
5148: SELECT 'x'
5149: INTO l_test
5150: FROM AR_LOOKUPS
5151: WHERE lookup_code = UPPER(p_contact_point_type)
5152: AND (lookup_type = 'COMMUNICATION_TYPE' OR lookup_type = 'PHONE_LINE_TYPE')
5153: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(start_date_active, SYSDATE))
5154: AND TRUNC(NVL(end_date_active, SYSDATE))