APPS.BIV_DASH_BIN_PKG dependencies on JTF_TASKS_B

Line 175: jtf_tasks_b task ';

171: -- this will be used in get_esc_sr_backlog
172: -- Change for Bug 3386946
173: g_esc_frm_lst := ' from cs_incidents_b_sec sr,
174: jtf_task_references_b ref,
175: jtf_tasks_b task ';
176: biv_core_pkg.get_where_clause(g_esc_frm_lst,g_esc_whr_cls);
177: g_esc_whr_cls := g_esc_whr_cls || '
178: and sr.incident_id = ref.object_id
179: and ref.task_id = task.task_id

Line 320: l_table := l_table || ' jtf_tasks_b task ';

316: l_table := l_table || ' from cs_incidents_vl_sec sr, ';
317: l_table := l_table || ' cs_incident_statuses_b stat, ';
318: l_table := l_table || ' cs_incident_severities_vl c, ';
319: l_table := l_table || ' jtf_task_references_b r, ';
320: l_table := l_table || ' jtf_tasks_b task ';
321:
322: biv_core_pkg.get_where_clause(l_table,x_where_clause);
323:
324: l_where := x_where_clause || ' and sr.incident_status_id = stat.incident_status_id ';

Line 507: jtf_task_references_b r, jtf_tasks_b t

503: /*
504: select count(ina.incident_id) into x_val
505: FROM
506: cs_incidents_all_b ina,
507: jtf_task_references_b r, jtf_tasks_b t
508: WHERE ina.incident_id = r.object_id
509: and r.task_id = t.task_id
510: and r.object_type_code = 'SR'
511: and r.reference_code = 'ESC'

Line 542: from jtf_task_references_b r,jtf_tasks_b t

538: x_esc_flag VARCHAR2(1);
539: begin
540:
541: select decode(count(*),0,'N','Y') into x_esc_flag
542: from jtf_task_references_b r,jtf_tasks_b t
543: where r.OBJECT_ID = p_sr_id
544: and r.object_type_code = 'SR'
545: and r.reference_code = 'ESC'
546: and r.task_id = t.task_id