APPS.IEU_TASKS_WR_MIG_PVT dependencies on JTF_TASK_STATUSES_B

Line 96: from jtf_task_statuses_b sts

92: and a.RESOURCE_ID = asg.resource_id
93: AND NVL(DELETE_FLAG,'N') <> 'Y' )
94: and exists
95: (select 1
96: from jtf_task_statuses_b sts
97: where sts.task_status_id = asg.assignment_status_id
98: and (nvl(sts.closed_flag, 'N') = 'N'
99: and nvl(sts.completed_flag, 'N') = 'N'
100: and nvl(sts.cancelled_flag, 'N') = 'N'

Line 137: from jtf_task_statuses_b sts

133: and RESOURCE_ID = asg.resource_id
134: AND NVL(DELETE_FLAG,'N') <> 'Y' )
135: and exists
136: (select 1
137: from jtf_task_statuses_b sts
138: where sts.task_status_id = asg.assignment_status_id
139: and (nvl(sts.closed_flag, 'N') = 'N'
140: and nvl(sts.completed_flag, 'N') = 'N'
141: and nvl(sts.cancelled_flag, 'N') = 'N'

Line 288: , jtf_task_statuses_b sts_b

284: from jtf_tasks_b tb
285: , jtf_tasks_tl tt
286: , jtf_task_priorities_b tp
287: , ieu_uwqm_priorities_b ip
288: , jtf_task_statuses_b sts_b
289: where tb.entity = '||''''||'TASK'||''''||'
290: and nvl(tb.deleted_flag, '||''''||'N'||''''||') = '||''''||'N'||''''||'
291: and tb.task_id = tt.task_id
292: and tt.language = userenv('||''''||'LANG'||''''||')