DBA Data[Home] [Help]

APPS.CSZ_SERVICEREQUEST_UTIL_PVT dependencies on JTF_TASK_REFERENCES_B

Line 1139: jtf_task_references_b trf

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')
1143: and nvl(tsk.open_flag, 'Y') = 'Y'