APPS.CS_SERVICEREQUEST_UTIL dependencies on CS_INCIDENT_URGENCIES_VL

Line 613: FROM cs_incident_urgencies_vl

609: x_return_status := FND_API.G_RET_STS_SUCCESS;
610:
611: -- Fetch ID from database.
612: SELECT incident_urgency_id INTO p_urgency_id
613: FROM cs_incident_urgencies_vl
614: WHERE UPPER(name) = UPPER(p_urgency_name)
615: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(start_date_active, SYSDATE))
616: AND TRUNC(NVL(end_date_active, SYSDATE))
617: AND rownum<2;

Line 625: p_table_name => 'CS_INCIDENT_URGENCIES_VL',

621: x_return_status := FND_API.G_RET_STS_ERROR;
622: Add_Invalid_Argument_Msg( p_token_an => l_api_name_full,
623: p_token_v => p_urgency_name,
624: p_token_p => p_parameter_name,
625: p_table_name => 'CS_INCIDENT_URGENCIES_VL',
626: p_column_name => 'NAME');
627: WHEN OTHERS THEN
628: fnd_message.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
629: fnd_message.set_token ('P_TEXT',l_api_name_full||'-'||SQLERRM);