APPS.IEU_WR_PUB dependencies on JTF_TASK_STATUSES_B

Line 11342: , jtf_task_statuses_b sts_b

11338: from jtf_tasks_b tb
11339: , jtf_tasks_tl tt
11340: , jtf_task_priorities_vl tp
11341: , ieu_uwqm_priorities_b ip
11342: , jtf_task_statuses_b sts_b
11343: where tb.entity = 'TASK'
11344: and nvl(tb.deleted_flag, 'N') = 'N'
11345: and tb.task_id = tt.task_id
11346: and tt.language = userenv('LANG')

Line 12046: from jtf_task_statuses_b sts

12042: and a.RESOURCE_ID = asg.resource_id
12043: AND NVL(DELETE_FLAG,'N') <> 'Y' )
12044: and exists
12045: (select 1
12046: from jtf_task_statuses_b sts
12047: where sts.task_status_id = asg.assignment_status_id
12048: and (nvl(sts.closed_flag, 'N') = 'N'
12049: and nvl(sts.completed_flag, 'N') = 'N'
12050: and nvl(sts.cancelled_flag, 'N') = 'N'