DBA Data[Home] [Help]

APPS.CAC_SYNC_TASK_CURSORS dependencies on JTF_TASK_PRIORITIES_B

Line 80: jtf_task_priorities_b tb,

76: ta.free_busy_type free_busy_type,
77: t.entity
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

Line 192: jtf_task_priorities_b tb,

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
195: WHERE tm.resource_id = cac_sync_task.g_login_resource_id
196: AND tm.principal_id = b_principal_id

Line 291: jtf_task_priorities_b tp,

287:
288:
289: end as event
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

Line 471: jtf_task_priorities_b tb,

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

Line 556: jtf_task_priorities_b tb,

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
560: AND tm.principal_id = b_principal_id