APPS.CSZ_SERVICEREQUEST_UTIL_PVT dependencies on JTF_TASKS_B

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;

Line 1138: from jtf_tasks_b tsk,

1134: RETURN VARCHAR2 IS
1135: l_object_id NUMBER;
1136: cursor c_escal_id(param_incident_id NUMBER) is
1137: select trf.object_id
1138: from jtf_tasks_b tsk,
1139: jtf_task_references_b trf
1140: where tsk.task_id = trf.task_id
1141: and tsk.task_type_id = 22
1142: and tsk.escalation_level not in ('DE', 'NE')