APPS.CAC_SYNC_TASK_CURSORS dependencies on JTF_TASK_ALL_ASSIGNMENTS

Line 82: jtf_task_all_assignments ta,

78: FROM jtf_task_recur_rules rc,
79: jtf_task_statuses_b ts,
80: jtf_task_priorities_b tb,
81: jtf_tasks_tl tl,
82: jtf_task_all_assignments ta,
83: jtf_tasks_b t,
84: (SELECT jtb.recurrence_rule_id
85: , MIN (jtb.task_id) task_id
86: FROM jtf_tasks_b jtb

Line 87: , jtf_task_all_assignments jtaa

83: jtf_tasks_b t,
84: (SELECT jtb.recurrence_rule_id
85: , MIN (jtb.task_id) task_id
86: FROM jtf_tasks_b jtb
87: , jtf_task_all_assignments jtaa
88: WHERE jtaa.resource_id = b_resource_id
89: AND jtaa.resource_type_code = b_resource_type
90: AND jtb.task_id = jtaa.task_id
91: AND jtb.entity='APPOINTMENT'

Line 190: jtf_task_all_assignments ta,

186: ta.free_busy_type free_busy_type,
187: t.entity
188: FROM jtf_task_recur_rules rc,
189: jta_sync_task_mapping tm,
190: jtf_task_all_assignments ta,
191: jtf_task_statuses_b ts,
192: jtf_task_priorities_b tb,
193: jtf_tasks_tl tl,
194: jtf_tasks_b t

Line 235: OR (SELECT MAX(last_update_date) FROM jtf_task_all_assignments

231: and rownum=1 )
232:
233: -- AND t.calendar_start_date > (sysdate - G_SYNC_DAYS_BEFORE )
234: AND ( rc.last_update_date > b_syncanchor
235: OR (SELECT MAX(last_update_date) FROM jtf_task_all_assignments
236: WHERE task_id = t.task_id) > b_syncanchor
237: OR t.object_changed_date > b_syncanchor
238: OR (SELECT MAX(m.object_changed_date) FROM jtf_tasks_b m WHERE m.task_id IN
239: (SELECT jte.task_id FROM jta_task_exclusions jte

Line 295: jtf_task_all_assignments ta

291: jtf_task_priorities_b tp,
292: jtf_tasks_tl tl,
293: jtf_tasks_b tb,
294: jta_task_exclusions jte,
295: jtf_task_all_assignments ta
296: WHERE jte.recurrence_rule_id = b_recurrence_rule_id
297: and tb.task_id=jte.task_id
298: and tl.task_id=tb.task_id
299: and tl.language=userenv('LANG')

Line 349: , jtf_task_all_assignments ta

345: IS
346: SELECT tm.task_sync_id
347: FROM jtf_tasks_b t
348: , jta_sync_task_mapping tm
349: , jtf_task_all_assignments ta
350: WHERE tm.resource_id = cac_sync_task.g_login_resource_id
351: AND tm.principal_id = b_principal_id
352: AND t.task_id = tm.task_id
353: AND t.owner_type_code = b_resource_type

Line 431: FROM jtf_task_all_assignments asgn

427: AND decode(t.source_object_type_code,'APPOINTMENT','APPOINTMENT','TASK') = b_source_object_type
428: AND decode(t.entity, 'APPOINTMENT','APPOINTMENT','TASK', 'TASK','BOOKING') = b_source_object_type
429: --this indicates that the resource is no longer on the task, however the task is not deleted
430: AND NOT EXISTS (SELECT 1
431: FROM jtf_task_all_assignments asgn
432: WHERE asgn.task_id = t.task_id
433: AND asgn.resource_id = b_resource_id/*and asgn.last_update_date >= b_syncanchor */
434: );
435:

Line 470: FROM jtf_task_all_assignments ta,

466: greatest(t.object_changed_date, ta.last_update_date) new_timestamp,
467: CAC_VIEW_UTIL_PUB.get_locations(t.task_id) locations,
468: ta.free_busy_type free_busy_type,
469: t.entity
470: FROM jtf_task_all_assignments ta,
471: jtf_task_priorities_b tb,
472: jtf_tasks_tl tl,
473: jtf_tasks_b t
474: WHERE ta.resource_id = b_resource_id

Line 555: jtf_task_all_assignments ta,

551: CAC_VIEW_UTIL_PUB.get_locations(t.task_id) locations,
552: ta.free_busy_type free_busy_type,
553: t.entity
554: FROM jta_sync_task_mapping tm,
555: jtf_task_all_assignments ta,
556: jtf_task_priorities_b tb,
557: jtf_tasks_tl tl,
558: jtf_tasks_b t
559: WHERE tm.resource_id = cac_sync_task.g_login_resource_id

Line 578: OR (SELECT MAX(last_update_date) FROM jtf_task_all_assignments

574: AND ta.resource_id = b_resource_id
575: AND t.recurrence_rule_id IS NULL
576: AND task_type_id <> 22
577: AND ( t.object_changed_date > b_syncanchor
578: OR (SELECT MAX(last_update_date) FROM jtf_task_all_assignments
579: WHERE task_id = t.task_id) > b_syncanchor)
580: --AND ( ta.last_update_date > (sysdate - G_SYNC_DAYS_BEFORE )
581: -- OR t.object_changed_date > (sysdate - G_SYNC_DAYS_BEFORE ))
582: AND nvl(t.calendar_end_date,sysdate+1) > (sysdate - G_SYNC_DAYS_BEFORE )