APPS.BIV_RT_TASK_BLOG_PKG dependencies on JTF_TASK_STATUSES_B

Line 248: ', jtf_task_statuses_b tstat, cs_incident_statuses_b stat';

244:
245: biv_core_pkg.get_report_parameters(p_param_str);
246: -- Change for Bug 3386946
247: l_from_list := ' from cs_incidents_b_sec sr, jtf_tasks_b task' ||
248: ', jtf_task_statuses_b tstat, cs_incident_statuses_b stat';
249: biv_core_pkg.get_where_clause(l_from_list,l_where_clause);
250: l_where_clause := l_where_clause ||
251: ' and sr.incident_status_id = stat.incident_status_id' ||
252: ' and nvl(stat.close_flag,''N'') != ''Y''' ||

Line 804: jtf_task_statuses_b tstat

800: service_requests(p_param_str);
801: update biv_tmp_hs2 rep
802: set col26 = (select count(*)
803: from jtf_tasks_b tsk,
804: jtf_task_statuses_b tstat
805: where source_object_type_code = 'SR'
806: and source_object_id = to_number(rep.col15)
807: and tsk.task_status_id = tstat.task_status_id
808: and nvl(tstat.closed_flag,'N') <> 'Y'