APPS.BIV_RT_TASK_BLOG_PKG dependencies on JTF_RS_RESOURCE_EXTNS

Line 423: jtf_rs_resource_extns tsk_rsc ';

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);
425: l_where_clause := l_where_clause ||
426: ' and sr.incident_status_id = stat.incident_status_id
427: and nvl(stat.close_flag,''N'') != ''Y''

Line 553: set col4 = (select substr(source_name,1,50) from jtf_rs_resource_extns s

549:
550: l_pos := 'updating resource name';
551: begin
552: update biv_tmp_hs2 r
553: set col4 = (select substr(source_name,1,50) from jtf_rs_resource_extns s
554: where s.resource_id = r.col3)
555: where report_code = 'BIV_SERVICE_REQUEST'
556: and session_id = l_session_id;
557: exception