APPS.BIV_RT_TASK_BLOG_PKG dependencies on CS_INCIDENT_STATUSES_VL

Line 695: set col25= (select substr(name,1,50) from cs_incident_statuses_vl s

691: end;
692: l_pos := 'updating status';
693: begin
694: update biv_tmp_hs2 r
695: set col25= (select substr(name,1,50) from cs_incident_statuses_vl s
696: where s.incident_status_id = r.col24)
697: where report_code = 'BIV_SERVICE_REQUEST'
698: and session_id = l_session_id;
699: exception

Line 777: from cs_incident_statuses_vl

773: l_bklg_meaning fnd_lookups.meaning%type;
774: begin
775: l_bklg_meaning := biv_core_pkg.get_lookup_meaning('BACKLOG');
776: select name into l_name
777: from cs_incident_statuses_vl
778: where incident_status_id = to_number(p_sts_id);
779: return(l_name || ' ' || l_bklg_meaning);
780:
781: exception