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: WHERE exists
145: (SELECT null
146: FROM JTF_OBJECT_USAGES
147: WHERE OBJECT_USER_CODE = 'RESOURCES'

Line 166: FROM JTF_TASK_ASSIGNMENTS ASG,JTF_TASKS_B TASKS

162: SELECT TYPES.TASK_TYPE_ID TASK_TYPE_ID,TYPES.NAME TASK_TYPE
163: FROM
164: JTF_TASK_TYPES_TL TYPES
165: WHERE TYPES.TASK_TYPE_ID IN (SELECT /*+ use_nl(tasks asg) */ TASKS.TASK_TYPE_ID
166: FROM JTF_TASK_ASSIGNMENTS ASG,JTF_TASKS_B TASKS
167: WHERE exists
168: (SELECT null
169: FROM JTF_RS_GROUP_MEMBERS
170: WHERE RESOURCE_ID = p_resource_id

Line 188: FROM JTF_TASK_ASSIGNMENTS ASG,JTF_TASKS_B TASKS

184: SELECT TYPES.TASK_TYPE_ID TASK_TYPE_ID,TYPES.NAME TASK_TYPE
185: FROM
186: JTF_TASK_TYPES_TL TYPES
187: WHERE TYPES.TASK_TYPE_ID IN (SELECT /*+ use_nl(tasks asg) */ TASKS.TASK_TYPE_ID
188: FROM JTF_TASK_ASSIGNMENTS ASG,JTF_TASKS_B TASKS
189: WHERE exists
190: (SELECT null
191: FROM JTF_RS_TEAM_MEMBERS
192: WHERE TEAM_RESOURCE_ID = p_resource_id