1794: FUNCTION GET_TASK_ESC_LEVEL( p_task_id IN NUMBER) RETURN VARCHAR2
1795: IS
1796: CURSOR l_esc_csr (b_task_id NUMBER) IS
1797: SELECT esc.escalation_level
1798: FROM jtf_tasks_b tasks,
1799: jtf_task_references_vl ref,
1800: jtf_tasks_b esc
1801: WHERE ref.object_id = tasks.task_id
1802: and ref.object_type_code = 'TASK'
1796: CURSOR l_esc_csr (b_task_id NUMBER) IS
1797: SELECT esc.escalation_level
1798: FROM jtf_tasks_b tasks,
1799: jtf_task_references_vl ref,
1800: jtf_tasks_b esc
1801: WHERE ref.object_id = tasks.task_id
1802: and ref.object_type_code = 'TASK'
1803: and ref.reference_code = 'ESC'
1804: and ref.task_id = esc.task_id