DBA Data[Home] [Help]

APPS.IEU_TASKS_ENUMS_PVT dependencies on JTF_OBJECT_USAGES

Line 146: FROM JTF_OBJECT_USAGES

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'
148: and object_code = ASG.RESOURCE_TYPE_CODE
149: AND OBJECT_CODE NOT IN ( 'RS_GROUP','RS_TEAM' ))
150: AND TASKS.TASK_ID = ASG.TASK_ID