DBA Data[Home] [Help]

APPS.CS_SERVICEREQUEST_PVT dependencies on CS_INCIDENT_SEVERITIES_B

Line 19239: FROM cs_incident_severities_b

19235: FUNCTION Get_Importance_Level(P_Severity_Id IN NUMBER)
19236: RETURN NUMBER IS
19237: CURSOR c_imp_csr IS
19238: SELECT importance_level
19239: FROM cs_incident_severities_b
19240: WHERE incident_severity_id = p_severity_id;
19241: l_imp_level NUMBER;
19242: BEGIN
19243: OPEN c_imp_csr;

Line 19254: FROM cs_incident_severities_b

19250: FUNCTION Get_Old_Importance_level(p_incident_id IN NUMBER)
19251: RETURN NUMBER IS
19252: CURSOR c_imp_old_csr IS
19253: SELECT importance_level
19254: FROM cs_incident_severities_b
19255: WHERE incident_severity_id =( SELECT incident_severity_id
19256: FROM CS_INCIDENTS_ALL_B
19257: WHERE incident_id = p_incident_id);
19258: l_old_imp_level NUMBER;