APPS.BIV_RT_TASK_BLOG_PKG dependencies on JTF_TASKS_B

Line 247: l_from_list := ' from cs_incidents_b_sec sr, jtf_tasks_b task' ||

243: biv_core_pkg.clean_dcf_table('biv_tmp_rt2');
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' ||

Line 420: jtf_tasks_b task,

416: biv_core_pkg.get_report_parameters(p_param_str);
417: -- Change for Bug 3386946
418: l_from_list := ' cs_incidents_b_sec sr,
419: cs_incident_statuses_b stat,
420: jtf_tasks_b task,
421: jtf_task_statuses_vl tstat,
422: /*jtf_rs_resource_ext ns rsc, */
423: jtf_rs_resource_extns tsk_rsc ';
424: biv_core_pkg.get_where_clause(l_from_list,l_where_clause);

Line 713: from jtf_tasks_b task,

709: l_pos := 'updating escalation level';
710: begin
711: update biv_tmp_hs2 r
712: set col21= (select task.escalation_level
713: from jtf_tasks_b task,
714: jtf_task_references_b ref
715: where ref.object_type_code = 'SR'
716: and ref.object_id = r.col1
717: and ref.reference_code = 'ESC'

Line 803: from jtf_tasks_b tsk,

799: begin
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