APPS.BIV_DASH_BIN_PKG dependencies on CS_INCIDENT_STATUSES_VL

Line 60: l_table := ' FROM cs_incidents_b_sec sr, cs_incident_statuses_vl stat ';

56: l_select := l_select || l_url || g_p_sp || 'P_STS_ID' || g_v_sp;
57: l_select := l_select || '''||stat.incident_status_id||''' || g_p_sp || '''';
58: l_select := l_select || ',count(sr.incident_id) ';
59: -- Change for Bug 3386946
60: l_table := ' FROM cs_incidents_b_sec sr, cs_incident_statuses_vl stat ';
61: biv_core_pkg.get_where_clause(l_table,x_where_clause);
62: l_where := x_where_clause || '
63: and sr.incident_status_id = stat.incident_status_id
64: and stat.incident_subtype = ''INC''

Line 167: l_table := 'FROM cs_incident_statuses_vl stat, cs_incidents_vl_sec sr ';

163: l_select := l_select || 'stat.incident_status_id||'''||l_url_param||''', ';
164: l_select := l_select || 'biv_dash_bin_pkg.get_esc_sr_backlog(1,stat.incident_status_id) ,''INDV_ROW''';
165:
166:
167: l_table := 'FROM cs_incident_statuses_vl stat, cs_incidents_vl_sec sr ';
168:
169: biv_core_pkg.get_where_clause(l_table,x_where_clause);
170: -- table and where clause to get escalated SR count.
171: -- this will be used in get_esc_sr_backlog

Line 437: FROM cs_incident_statuses_vl

433: l_report_name := l_report_name || ' ' || l_tmp;
434:
435: -- get the last part
436: SELECT name INTO l_tmp
437: FROM cs_incident_statuses_vl
438: WHERE incident_status_id = to_number(l_status);
439:
440: l_report_name := l_report_name || ' : ' || l_tmp;
441:

Line 483: FROM cs_incident_statuses_vl

479: l_label := l_label || ' ' || l_tmp;
480:
481: -- get the fourth part
482: SELECT name INTO l_tmp
483: FROM cs_incident_statuses_vl
484: WHERE incident_status_id = to_number(l_status);
485:
486: l_label := l_label || ' ' || l_tmp;
487: