DBA Data[Home] [Help]

APPS.CSM_UTIL_PKG dependencies on JTF_TASKS_B

Line 1798: FROM jtf_tasks_b tasks,

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'

Line 1800: jtf_tasks_b esc

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