APPS.CSY_KPI_PKG dependencies on CS_INCIDENT_SEVERITIES_VL

Line 2410: from cs_incident_severities_vl

2406: function sev_names (p_imp_lvl number) return varchar2 is
2407: l_imp_lvl_rnk number;
2408: cursor c_severities is
2409: select name
2410: from cs_incident_severities_vl
2411: where importance_level = p_imp_lvl
2412: and trunc(sysdate) between nvl(start_date_active,sysdate-1) and nvl(end_date_active,sysdate+1)
2413: and incident_subtype = 'INC';
2414: --

Line 2415: l_id cs_incident_severities_vl.incident_Severity_id % type;

2411: where importance_level = p_imp_lvl
2412: and trunc(sysdate) between nvl(start_date_active,sysdate-1) and nvl(end_date_active,sysdate+1)
2413: and incident_subtype = 'INC';
2414: --
2415: l_id cs_incident_severities_vl.incident_Severity_id % type;
2416: l_name cs_incident_severities_vl.name % type;
2417: l_imp_lvl cs_incident_severities_vl.importance_level % type;
2418: l_rnk number;
2419: l_all_sev varchar2(2000);

Line 2416: l_name cs_incident_severities_vl.name % type;

2412: and trunc(sysdate) between nvl(start_date_active,sysdate-1) and nvl(end_date_active,sysdate+1)
2413: and incident_subtype = 'INC';
2414: --
2415: l_id cs_incident_severities_vl.incident_Severity_id % type;
2416: l_name cs_incident_severities_vl.name % type;
2417: l_imp_lvl cs_incident_severities_vl.importance_level % type;
2418: l_rnk number;
2419: l_all_sev varchar2(2000);
2420: l_count number;

Line 2417: l_imp_lvl cs_incident_severities_vl.importance_level % type;

2413: and incident_subtype = 'INC';
2414: --
2415: l_id cs_incident_severities_vl.incident_Severity_id % type;
2416: l_name cs_incident_severities_vl.name % type;
2417: l_imp_lvl cs_incident_severities_vl.importance_level % type;
2418: l_rnk number;
2419: l_all_sev varchar2(2000);
2420: l_count number;
2421: l_min_lvl number;