APPS.CS_SERVICEREQUEST_UTIL dependencies on AR_LOOKUPS

Line 3029: FROM ar_lookups

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

Line 5148: FROM AR_LOOKUPS

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