APPS.IEU_TASKS_ENUMS_PVT dependencies on JTF_TASK_STATUSES_B

Line 144: ,JTF_TASK_STATUSES_B STB --Added the following code by rgandhi for Bug9920514

140: FROM JTF_TASK_TYPES_TL TYPES
141: WHERE TYPES.TASK_TYPE_ID IN
142: (SELECT /*+ use_nl(tasks asg) */ TASKS.TASK_TYPE_ID
143: FROM JTF_TASK_ASSIGNMENTS ASG,JTF_TASKS_B TASKS
144: ,JTF_TASK_STATUSES_B STB --Added the following code by rgandhi for Bug9920514
145: WHERE exists
146: (SELECT null
147: FROM JTF_OBJECT_USAGES
148: WHERE OBJECT_USER_CODE = 'RESOURCES'

Line 168: ,JTF_TASK_STATUSES_B STB --Added the following code by rgandhi for Bug9920514

164: CURSOR c_assign_grp_task_nodes_1 IS
165: SELECT TYPES.TASK_TYPE_ID TASK_TYPE_ID,TYPES.NAME TASK_TYPE
166: FROM
167: JTF_TASK_TYPES_TL TYPES
168: ,JTF_TASK_STATUSES_B STB --Added the following code by rgandhi for Bug9920514
169: WHERE TYPES.TASK_TYPE_ID IN (SELECT /*+ use_nl(tasks asg) */ TASKS.TASK_TYPE_ID
170: FROM JTF_TASK_ASSIGNMENTS ASG,JTF_TASKS_B TASKS
171: WHERE exists
172: (SELECT null

Line 193: ,JTF_TASK_STATUSES_B STB --Added the following code by rgandhi for Bug9920514

189: CURSOR c_assign_team_task_nodes_1 IS
190: SELECT TYPES.TASK_TYPE_ID TASK_TYPE_ID,TYPES.NAME TASK_TYPE
191: FROM
192: JTF_TASK_TYPES_TL TYPES
193: ,JTF_TASK_STATUSES_B STB --Added the following code by rgandhi for Bug9920514
194: WHERE TYPES.TASK_TYPE_ID IN (SELECT /*+ use_nl(tasks asg) */ TASKS.TASK_TYPE_ID
195: FROM JTF_TASK_ASSIGNMENTS ASG,JTF_TASKS_B TASKS
196: WHERE exists
197: (SELECT null