APPS.IEU_ESCALATIONS_PVT dependencies on JTF_TASKS_B

Line 20: SELECT /*+ index(tasks_b jtf_tasks_b_n2) */

16: l_tk_list IEU_PUB.EnumeratorDataRecordList;
17: l_bind_list IEU_PUB.BindVariableRecordList;
18:
19: CURSOR c_ESC_nodes_1 IS
20: SELECT /*+ index(tasks_b jtf_tasks_b_n2) */
21: distinct lkups.meaning name, tasks_b.escalation_level
22: from jtf_tasks_b tasks_b ,
23: fnd_lookup_values_vl lkups
24: WHERE tasks_b.open_flag = 'Y'

Line 22: from jtf_tasks_b tasks_b ,

18:
19: CURSOR c_ESC_nodes_1 IS
20: SELECT /*+ index(tasks_b jtf_tasks_b_n2) */
21: distinct lkups.meaning name, tasks_b.escalation_level
22: from jtf_tasks_b tasks_b ,
23: fnd_lookup_values_vl lkups
24: WHERE tasks_b.open_flag = 'Y'
25: and nvl(tasks_b.deleted_flag,'N') = 'N'
26: and tasks_b.entity ='ESCALATION'

Line 139: SELECT /*+ index(tasks_b jtf_tasks_b_n2) */ count(*) into :l_count

135:
136: BEGIN
137: -- Get count 1
138: l_sql_count := 'begin
139: SELECT /*+ index(tasks_b jtf_tasks_b_n2) */ count(*) into :l_count
140: from jtf_tasks_b tasks_b ,
141: jtf_task_references_b refs_b
142: WHERE
143: nvl(tasks_b.deleted_flag ,'||''''||'N'||''''||') <> '||''''||'Y'||''''||'

Line 140: from jtf_tasks_b tasks_b ,

136: BEGIN
137: -- Get count 1
138: l_sql_count := 'begin
139: SELECT /*+ index(tasks_b jtf_tasks_b_n2) */ count(*) into :l_count
140: from jtf_tasks_b tasks_b ,
141: jtf_task_references_b refs_b
142: WHERE
143: nvl(tasks_b.deleted_flag ,'||''''||'N'||''''||') <> '||''''||'Y'||''''||'
144: and tasks_b.open_flag = '||''''||'Y'||''''||'