DBA Data[Home] [Help]

APPS.CS_ERES_INT_PKG dependencies on CS_INCIDENT_SEVERITIES_B

Line 1150: FROM cs_incident_severities_tl sevt, cs_incident_severities_b sevb

1146: --:Incident_Severity
1147: --:Sev_Importance_Level
1148: CURSOR Get_Inc_Severity (v_incident_severity_id NUMBER) IS
1149: SELECT sevt.name, sevb.importance_level
1150: FROM cs_incident_severities_tl sevt, cs_incident_severities_b sevb
1151: WHERE sevb.incident_severity_id = v_incident_severity_id
1152: AND sevt.incident_severity_id = sevb.incident_severity_id
1153: AND sevt.language = userenv('LANG');
1154:

Line 1508: FROM cs_incident_severities_b sev

1504: FROM cs_incident_severities_tl sev
1505: WHERE sev.incident_severity_id = sr.incident_severity_id
1506: AND sev.language = userenv(''LANG''))Incident_Severity
1507: ,(SELECT sev.importance_level
1508: FROM cs_incident_severities_b sev
1509: WHERE sev.incident_severity_id = sr.incident_severity_id
1510: ) Sev_Importance_Level
1511: ,(SELECT urgency.name
1512: FROM cs_incident_urgencies_tl urgency