APPS.CSY_KPI_PKG dependencies on CS_INCIDENT_SEVERITIES_VL

Line 2225: from cs_incident_severities_vl

2221: function sev_names (p_imp_lvl number) return varchar2 is
2222: l_imp_lvl_rnk number;
2223: cursor c_severities is
2224: select name
2225: from cs_incident_severities_vl
2226: where importance_level = p_imp_lvl
2227: and trunc(sysdate) between nvl(start_date_active,sysdate-1) and nvl(end_date_active,sysdate+1)
2228: and incident_subtype = 'INC';
2229: --

Line 2230: l_id cs_incident_severities_vl.incident_Severity_id % type;

2226: where importance_level = p_imp_lvl
2227: and trunc(sysdate) between nvl(start_date_active,sysdate-1) and nvl(end_date_active,sysdate+1)
2228: and incident_subtype = 'INC';
2229: --
2230: l_id cs_incident_severities_vl.incident_Severity_id % type;
2231: l_name cs_incident_severities_vl.name % type;
2232: l_imp_lvl cs_incident_severities_vl.importance_level % type;
2233: l_rnk number;
2234: l_all_sev varchar2(2000);

Line 2231: l_name cs_incident_severities_vl.name % type;

2227: and trunc(sysdate) between nvl(start_date_active,sysdate-1) and nvl(end_date_active,sysdate+1)
2228: and incident_subtype = 'INC';
2229: --
2230: l_id cs_incident_severities_vl.incident_Severity_id % type;
2231: l_name cs_incident_severities_vl.name % type;
2232: l_imp_lvl cs_incident_severities_vl.importance_level % type;
2233: l_rnk number;
2234: l_all_sev varchar2(2000);
2235: l_count number;

Line 2232: l_imp_lvl cs_incident_severities_vl.importance_level % type;

2228: and incident_subtype = 'INC';
2229: --
2230: l_id cs_incident_severities_vl.incident_Severity_id % type;
2231: l_name cs_incident_severities_vl.name % type;
2232: l_imp_lvl cs_incident_severities_vl.importance_level % type;
2233: l_rnk number;
2234: l_all_sev varchar2(2000);
2235: l_count number;
2236: l_min_lvl number;