APPS.IEU_UWQM_TASK_WL_MIG dependencies on JTF_TASKS_B

Line 11: from jtf_Tasks_b a, jtf_task_priorities_vl b

7: l_priority_list l_pty_list;
8:
9: cursor l_tasks_cur is
10: select b.importance_level, count(a.task_id) cnt
11: from jtf_Tasks_b a, jtf_task_priorities_vl b
12: where a.task_priority_id = b.task_priority_id
13: and nvl(a.deleted_flag , 'N') = 'N'
14: and a.entity = 'TASK'
15: and nvl(a.open_flag, 'N') = 'Y'

Line 44: from jtf_Tasks_b a

40: -- All Tasks with Null Priority Id will be included under importance level 4
41:
42: select count(a.task_id)
43: into l_null_pty_count
44: from jtf_Tasks_b a
45: where a.task_priority_id is null
46: and nvl(a.deleted_flag, 'N') = 'N'
47: and a.entity = 'TASK'
48: and nvl(a.open_flag, 'N') = 'Y';