DBA Data[Home] [Help]

APPS.CSZ_SERVICEREQUEST_UTIL_PVT dependencies on JTF_ESCALATION_TASK_V

Line 1596: from jtf_escalation_task_v esc

1592: ) RETURN VARCHAR2 as
1593: l_esc_level VARCHAR2(80) DEFAULT NULL;
1594: cursor c_escal_level(param_incident_id NUMBER) is
1595: select esc.esc_level_name
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

Line 1599: from jtf_escalation_task_v jtf,

1595: select esc.esc_level_name
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);