DBA Data[Home] [Help]

APPS.JTA_SYNC_TASK_CURSORS dependencies on JTF_TASK_PRIORITIES_B

Line 143: jtf_task_priorities_b tb,

139: rc.occurs_which,
140: greatest(t.object_changed_date, ta.last_update_date) new_timestamp
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

Line 240: jtf_task_priorities_b tb,

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
243: WHERE tm.resource_id = jta_sync_task.g_login_resource_id
244: AND t.task_id = tm.task_id

Line 416: jtf_task_priorities_b tb,

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
420: AND ta.resource_type_code = b_resource_type

Line 484: jtf_task_priorities_b tb,

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
488: AND t.task_id = tm.task_id