DBA Data[Home] [Help]

APPS.CS_SERVICEREQUEST_UTIL dependencies on CS_INCIDENT_SEVERITIES_B

Line 1661: FROM cs_incident_severities_b

1657: x_return_status := FND_API.G_RET_STS_SUCCESS;
1658:
1659: BEGIN
1660: SELECT 'x' INTO l_dummy
1661: FROM cs_incident_severities_b
1662: WHERE incident_subtype = p_subtype
1663: AND incident_severity_id = p_severity_id
1664: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(start_date_active, SYSDATE))
1665: AND TRUNC(NVL(end_date_active, SYSDATE));