APPS.CSY_KPI_PKG dependencies on CS_INCIDENT_SEVERITIES_B

Line 1227: l_sev_id cs_incident_severities_b.incident_severity_id % type;

1223: ) as
1224: l_dt date;
1225: l_owner_id jtf_rs_resource_extns.resource_id % type;
1226: l_group_id jtf_rs_groups_b.group_id % type;
1227: l_sev_id cs_incident_severities_b.incident_severity_id % type;
1228: l_sr_in number;
1229: l_sr_out number;
1230: Type AssignmentCursorType is ref cursor;
1231: c_agent_assignment AssignmentCursorType;

Line 2426: from cs_incident_severities_b

2422: l_loop_counter number;
2423: --
2424: begin
2425: select min(importance_level) into l_min_lvl
2426: from cs_incident_severities_b
2427: where trunc(sysdate) between nvl(start_date_active,sysdate-1) and nvl(end_date_active,sysdate+1)
2428: and incident_subtype = 'INC';
2429: l_count := 0;
2430: open c_severities;