APPS.CSZ_SERVICEREQUEST_UTIL_PVT dependencies on JTF_TASK_REFERENCES_B

Line 1138: jtf_task_references_b trf

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

Line 1600: jtf_task_references_b trf

1596: from jtf_escalation_task_v esc
1597: where esc.task_id = (
1598: select max(jtf.task_id)
1599: from jtf_escalation_task_v jtf,
1600: jtf_task_references_b trf
1601: where jtf.task_id = trf.task_id
1602: and trf.object_type_code = 'SR'
1603: and trf.object_id = param_incident_id);
1604: