[Home] [Help]
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
240: WHERE jte.recurrence_rule_id=t.recurrence_rule_id)) > b_syncanchor)
241: AND ts.task_status_id = t.task_status_id
242: AND NVL (t.deleted_flag, 'N') = 'N';
243:
290: FROM
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
505: AND ( ta.last_update_date > b_syncanchor
506: OR t.object_changed_date > b_syncanchor)
507: AND nvl(t.calendar_end_date,sysdate+1) > (sysdate - G_SYNC_DAYS_BEFORE )
508: AND NVL (t.deleted_flag, 'N') = 'N'
509: and NOT EXISTS (select 1 from jta_task_exclusions where task_id=t.task_id);
510:
511: -- (t.calendar_end_date > (sysdate - G_SYNC_DAYS_BEFORE ))
512: -- OR
513: -- ( (G_CAC_SYNC_TASK_NO_DATE = 'TRUE') AND (t.calendar_end_date IS NULL) );
588: AND decode(t.entity, 'APPOINTMENT','APPOINTMENT','TASK', 'TASK','BOOKING') = b_source_object_type
589: AND tl.language = USERENV ('LANG')
590: AND tb.task_priority_id (+) = t.task_priority_id
591: AND NVL (t.deleted_flag, 'N') = 'N'
592: and NOT EXISTS (select 1 from jta_task_exclusions where task_id=t.task_id);
593:
594:
595: CURSOR c_delete_unsubscribed (
596: b_resource_id NUMBER,