APPS.CS_ERES_INT_PKG dependencies on CS_INCIDENT_SEVERITIES_TL

Line 681: , cs_incident_severities_tl severity

677: , fnd_user fnd1
678: , cs_incidents_all_b relSR
679: , cs_incidents_all_tl tlSR
680: , cs_incident_statuses_tl status
681: , cs_incident_severities_tl severity
682: WHERE SrLnkEO.subject_id = x_incident_id
683: AND SrLnkEO.subject_type = 'SR'
684: AND SrLnkEO.object_type = 'SR'
685: AND SrLnkEO.link_type_id = ltype.link_type_id

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 1504: FROM cs_incident_severities_tl sev

1500: FROM cs_incident_statuses_tl status
1501: WHERE status.incident_status_id = sr.incident_status_id
1502: AND status.language = userenv(''LANG'') )Incident_Status
1503: ,(SELECT sev.name
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