APPS.CSZ_SERVICEREQUEST_UTIL_PVT dependencies on JTF_TASK_STATUSES_VL

Line 371: from jtf_tasks_b a, jtf_task_statuses_vl b

367: l_task_template_group_tbl cs_autogen_task_pvt.task_template_group_tbl_type;
368: --
369: cursor c_task_template_id is
370: select a.template_group_id
371: from jtf_tasks_b a, jtf_task_statuses_vl b
372: where a.task_status_id = b.task_status_id and
373: (nvl(b.closed_flag,'N') = 'N') and (nvl(b.completed_flag,'N') = 'N') and
374: a.source_object_type_code = 'SR' and
375: a.source_object_id = p_incident_id;