DBA Data[Home] [Help]

APPS.CAC_SYNC_TASK_CURSORS dependencies on CAC_VIEW_UTIL_PUB

Line 75: CAC_VIEW_UTIL_PUB.get_locations(t.task_id) locations,

71: rc.saturday,
72: rc.date_of_month,
73: rc.occurs_which,
74: greatest(t.object_changed_date, ta.last_update_date) new_timestamp,
75: CAC_VIEW_UTIL_PUB.get_locations(t.task_id) locations,
76: ta.free_busy_type free_busy_type,
77: t.entity
78: FROM jtf_task_recur_rules rc,
79: jtf_task_statuses_b ts,

Line 185: CAC_VIEW_UTIL_PUB.get_locations(t.task_id) locations,

181: rc.saturday,
182: rc.date_of_month,
183: rc.occurs_which,
184: greatest(t.object_changed_date, ta.last_update_date) new_timestamp,
185: CAC_VIEW_UTIL_PUB.get_locations(t.task_id) locations,
186: ta.free_busy_type free_busy_type,
187: t.entity
188: FROM jtf_task_recur_rules rc,
189: jta_sync_task_mapping tm,

Line 278: CAC_VIEW_UTIL_PUB.get_locations(tl.task_id) locations,

274: tb.owner_id,
275: tb.source_object_type_code,
276: jte.recurrence_rule_id,
277: greatest(tb.last_update_date ) new_timestamp,
278: CAC_VIEW_UTIL_PUB.get_locations(tl.task_id) locations,
279: ta.free_busy_type,
280: tb.entity,
281: case
282: when ((nvl(tb.deleted_flag,'N')='Y') and tb.recurrence_rule_id is null) then cac_sync_task_common.g_delete

Line 467: CAC_VIEW_UTIL_PUB.get_locations(t.task_id) locations,

463: t.source_object_type_code,
464: t.recurrence_rule_id,
465: ta.assignment_status_id,
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,

Line 551: CAC_VIEW_UTIL_PUB.get_locations(t.task_id) locations,

547: t.source_object_type_code,
548: t.recurrence_rule_id,
549: ta.assignment_status_id,
550: greatest(t.object_changed_date, ta.last_update_date) new_timestamp,
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,