APPS.BIV_BIN_ESC_RSC_PKG dependencies on JTF_RS_RESOURCE_EXTNS

Line 199: from jtf_rs_resource_extns

195: /**************************************************************************
196: insert into biv_tmp_bin ( report_code, rowno, col1, col2, col4,session_id)
197: select 'BIV_BIN_RESOURCE', rownum, id, descr, total,l_session_id
198: from (select 'ALL' id, 'ALL' descr,count(*) total
199: from jtf_rs_resource_extns
200: where category = 'EMPLOYEE'
201: );
202: insert into biv_tmp_bin ( report_code, rowno, col1, col2, col4,session_id)
203: select 'BIV_BIN_RESOURCE', 2, id, descr, total,l_session_id

Line 244: jtf_rs_resource_extns rsc,

240: from jtf_task_references_b r,
241: cs_incidents_b_sec ina,
242: cs_incident_statuses_vl stat,
243: jtf_tasks_b task,
244: jtf_rs_resource_extns rsc,
245: hz_parties p';
246:
247: biv_core_pkg.get_report_parameters(p_param_str);
248: biv_core_pkg.get_where_clause(l_from_list, l_where_clause);

Line 313: jtf_rs_resource_extns rsc,

309: from jtf_task_references_b r,
310: cs_incidents_all_b ina,
311: cs_incident_statuses_vl stat,
312: jtf_tasks_b t,
313: jtf_rs_resource_extns rsc,
314: hz_parties p
315: where ina.incident_id = r.OBJECT_ID
316: and r.object_type_code = 'SR'
317: and r.reference_code = 'ESC'

Line 360: jtf_rs_resource_extns rsc

356: jtf_tasks_tl tskl,
357: jtf_task_priorities_vl pr,
358: jtf_task_statuses_vl stat,
359: jtf_task_types_vl typ,
360: jtf_rs_resource_extns rsc
361: where tsk.source_object_type_code = 'SR'
362: and tsk.source_object_id = to_number(l_sr_id)
363: and tsk.task_status_id = stat.task_status_id
364: and tsk.task_type_id = typ.task_type_id

Line 376: from jtf_rs_resource_extns rsc,

372: procedure get_resource_where_clause (p_from_list out nocopy varchar2,
373: p_where_clause out nocopy varchar2) is
374: begin
375: p_from_list := '
376: from jtf_rs_resource_extns rsc,
377: jtf_objects_vl o,
378: jtf_object_usages ou,
379: jtf_rs_res_availability ra ';
380: -- to_date removed because of GSCC fail