DBA Data[Home] [Help]

APPS.CSM_UTIL_PKG dependencies on JTF_TASKS_B

Line 1747: FROM jtf_tasks_b tasks,

1743: FUNCTION GET_TASK_ESC_LEVEL( p_task_id IN NUMBER) RETURN VARCHAR2
1744: IS
1745: CURSOR l_esc_csr (b_task_id NUMBER) IS
1746: SELECT esc.escalation_level
1747: FROM jtf_tasks_b tasks,
1748: jtf_task_references_vl ref,
1749: jtf_tasks_b esc
1750: WHERE ref.object_id = tasks.task_id
1751: and ref.object_type_code = 'TASK'

Line 1749: jtf_tasks_b esc

1745: CURSOR l_esc_csr (b_task_id NUMBER) IS
1746: SELECT esc.escalation_level
1747: FROM jtf_tasks_b tasks,
1748: jtf_task_references_vl ref,
1749: jtf_tasks_b esc
1750: WHERE ref.object_id = tasks.task_id
1751: and ref.object_type_code = 'TASK'
1752: and ref.reference_code = 'ESC'
1753: and ref.task_id = esc.task_id