DBA Data[Home] [Help]

APPS.IEU_TASKS_ENUMS_PVT dependencies on JTF_TASK_ASSIGNMENTS

Line 143: FROM JTF_TASK_ASSIGNMENTS ASG,JTF_TASKS_B TASKS

139: SELECT TYPES.TASK_TYPE_ID TASK_TYPE_ID,TYPES.NAME TASK_TYPE
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

Line 170: FROM JTF_TASK_ASSIGNMENTS ASG,JTF_TASKS_B TASKS

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
173: FROM JTF_RS_GROUP_MEMBERS
174: WHERE RESOURCE_ID = p_resource_id

Line 195: FROM JTF_TASK_ASSIGNMENTS ASG,JTF_TASKS_B TASKS

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
198: FROM JTF_RS_TEAM_MEMBERS
199: WHERE TEAM_RESOURCE_ID = p_resource_id