DBA Data[Home] [Help]

APPS.IEU_WR_PUB dependencies on JTF_TASK_ASSIGNMENTS

Line 12032: FROM IEU_UWQM_ITEMS_GTT GTT, JTF_TASK_ASSIGNMENTS ASG

12028: cursor c_task_asg(p_processing_set_id in number) is
12029: SELECT resource_id, WORKITEM_PK_ID, resource_type_code
12030: from (SELECT GTT.WORKITEM_PK_ID, asg.resource_id, asg.resource_type_code,
12031: max(asg.last_update_date) over (partition by asg.task_id) max_update_date, asg.last_update_date
12032: FROM IEU_UWQM_ITEMS_GTT GTT, JTF_TASK_ASSIGNMENTS ASG
12033: WHERE GTT.PROCESSING_SET_ID = P_PROCESSING_SET_ID
12034: AND GTT.WORKITEM_PK_ID = ASG.TASK_ID
12035: and GTT.OWNER_TYPE_ACTUAL = 'RS_GROUP'
12036: and asg.resource_type_code not in ('RS_GROUP', 'RS_TEAM')