DBA Data[Home] [Help]

APPS.CS_SERVICEREQUEST_PVT dependencies on CS_INCIDENT_SEVERITIES_B

Line 20755: FROM cs_incident_severities_b

20751: FUNCTION Get_Importance_Level(P_Severity_Id IN NUMBER)
20752: RETURN NUMBER IS
20753: CURSOR c_imp_csr IS
20754: SELECT importance_level
20755: FROM cs_incident_severities_b
20756: WHERE incident_severity_id = p_severity_id;
20757: l_imp_level NUMBER;
20758: BEGIN
20759: OPEN c_imp_csr;

Line 20770: FROM cs_incident_severities_b

20766: FUNCTION Get_Old_Importance_level(p_incident_id IN NUMBER)
20767: RETURN NUMBER IS
20768: CURSOR c_imp_old_csr IS
20769: SELECT importance_level
20770: FROM cs_incident_severities_b
20771: WHERE incident_severity_id =( SELECT incident_severity_id
20772: FROM CS_INCIDENTS_ALL_B
20773: WHERE incident_id = p_incident_id);
20774: l_old_imp_level NUMBER;