APPS.CSY_KPI_PKG dependencies on CS_INCIDENT_SEVERITIES_B

Line 1189: l_sev_id cs_incident_severities_b.incident_severity_id % type;

1185: ) as
1186: l_dt date;
1187: l_owner_id jtf_rs_resource_extns.resource_id % type;
1188: l_group_id jtf_rs_groups_b.group_id % type;
1189: l_sev_id cs_incident_severities_b.incident_severity_id % type;
1190: l_sr_in number;
1191: l_sr_out number;
1192: Type AssignmentCursorType is ref cursor;
1193: c_agent_assignment AssignmentCursorType;

Line 2241: from cs_incident_severities_b

2237: l_loop_counter number;
2238: --
2239: begin
2240: select min(importance_level) into l_min_lvl
2241: from cs_incident_severities_b
2242: where trunc(sysdate) between nvl(start_date_active,sysdate-1) and nvl(end_date_active,sysdate+1)
2243: and incident_subtype = 'INC';
2244: l_count := 0;
2245: open c_severities;