DBA Data[Home] [Help]

APPS.CS_ERES_INT_PKG dependencies on CS_INCIDENT_SEVERITIES_B

Line 1079: FROM cs_incident_severities_tl sevt, cs_incident_severities_b sevb

1075: --:Incident_Severity
1076: --:Sev_Importance_Level
1077: CURSOR Get_Inc_Severity (v_incident_severity_id NUMBER) IS
1078: SELECT sevt.name, sevb.importance_level
1079: FROM cs_incident_severities_tl sevt, cs_incident_severities_b sevb
1080: WHERE sevb.incident_severity_id = v_incident_severity_id
1081: AND sevt.incident_severity_id = sevb.incident_severity_id
1082: AND sevt.language = userenv('LANG');
1083:

Line 1432: FROM cs_incident_severities_b sev

1428: FROM cs_incident_severities_tl sev
1429: WHERE sev.incident_severity_id = sr.incident_severity_id
1430: AND sev.language = userenv(''LANG''))Incident_Severity
1431: ,(SELECT sev.importance_level
1432: FROM cs_incident_severities_b sev
1433: WHERE sev.incident_severity_id = sr.incident_severity_id
1434: ) Sev_Importance_Level
1435: ,(SELECT urgency.name
1436: FROM cs_incident_urgencies_tl urgency