APPS.JTA_SYNC_TASK_CURSORS dependencies on JTF_TASK_ALL_ASSIGNMENTS

Line 145: jtf_task_all_assignments ta,

141: FROM jtf_task_recur_rules rc,
142: jtf_task_statuses_b ts,
143: jtf_task_priorities_b tb,
144: jtf_tasks_tl tl,
145: jtf_task_all_assignments ta,
146: jtf_tasks_b t,
147: (SELECT jtb.recurrence_rule_id
148: , MIN (jtb.task_id) task_id
149: FROM jtf_tasks_b jtb

Line 150: , jtf_task_all_assignments jtaa

146: jtf_tasks_b t,
147: (SELECT jtb.recurrence_rule_id
148: , MIN (jtb.task_id) task_id
149: FROM jtf_tasks_b jtb
150: , jtf_task_all_assignments jtaa
151: WHERE jtaa.resource_id = b_resource_id
152: AND jtaa.resource_type_code = b_resource_type
153: AND jtb.task_id = jtaa.task_id
154: AND jtb.source_object_type_code = b_source_object_type

Line 238: jtf_task_all_assignments ta,

234: rc.occurs_which,
235: greatest(t.object_changed_date, ta.last_update_date) new_timestamp
236: FROM jtf_task_recur_rules rc,
237: jta_sync_task_mapping tm,
238: jtf_task_all_assignments ta,
239: jtf_task_statuses_b ts,
240: jtf_task_priorities_b tb,
241: jtf_tasks_tl tl,
242: jtf_tasks_b t

Line 308: , jtf_task_all_assignments ta

304: IS
305: SELECT tm.task_sync_id
306: FROM jtf_tasks_b t
307: , jta_sync_task_mapping tm
308: , jtf_task_all_assignments ta
309: WHERE tm.resource_id = jta_sync_task.g_login_resource_id
310: AND t.task_id = tm.task_id
311: AND t.owner_type_code = b_resource_type
312: AND b_resource_type = 'RS_EMPLOYEE'

Line 380: FROM jtf_task_all_assignments asgn

376: AND NVL (t.deleted_flag, 'N') = 'N'
377: AND decode(t.source_object_type_code,'APPOINTMENT','APPOINTMENT','TASK') = b_source_object_type
378: --this indicates that the resource is no longer on the task, however the task is not deleted
379: AND NOT EXISTS (SELECT 1
380: FROM jtf_task_all_assignments asgn
381: WHERE asgn.task_id = t.task_id
382: AND asgn.resource_id = b_resource_id/*and asgn.last_update_date >= b_syncanchor */
383: );
384:

Line 415: FROM jtf_task_all_assignments ta,

411: t.source_object_type_code,
412: t.recurrence_rule_id,
413: ta.assignment_status_id,
414: greatest(t.object_changed_date, ta.last_update_date) new_timestamp
415: FROM jtf_task_all_assignments ta,
416: jtf_task_priorities_b tb,
417: jtf_tasks_tl tl,
418: jtf_tasks_b t
419: WHERE ta.resource_id = b_resource_id

Line 483: jtf_task_all_assignments ta,

479: t.recurrence_rule_id,
480: ta.assignment_status_id,
481: greatest(t.object_changed_date, ta.last_update_date) new_timestamp
482: FROM jta_sync_task_mapping tm,
483: jtf_task_all_assignments ta,
484: jtf_task_priorities_b tb,
485: jtf_tasks_tl tl,
486: jtf_tasks_b t
487: WHERE tm.resource_id = jta_sync_task.g_login_resource_id