APPS.CAC_SYNC_TASK_COMMON dependencies on JTF_TASK_STATUSES_B

Line 2263: jtf_task_statuses_b ts,

2259: ta.free_busy_type free_busy_type,
2260: t.alarm_start alarm_start,
2261: t.alarm_on alarm_on
2262: FROM jtf_task_recur_rules rc,
2263: jtf_task_statuses_b ts,
2264: jtf_task_priorities_b tb,
2265: jtf_tasks_tl tl,
2266: jtf_task_all_assignments ta,
2267: jtf_tasks_b t

Line 3818: jtf_task_statuses_b ts,

3814: greatest(t.object_changed_date, ta.last_update_date) new_timestamp,
3815: CAC_VIEW_UTIL_PUB.get_locations(t.task_id) locations,
3816: ta.free_busy_type free_busy_type
3817: FROM jtf_task_recur_rules rc,
3818: jtf_task_statuses_b ts,
3819: jtf_task_priorities_b tb,
3820: jtf_tasks_tl tl,
3821: jtf_task_all_assignments ta,
3822: jtf_tasks_b t

Line 5023: FROM jtf_task_statuses_b

5019: SELECT closed_flag, completed_flag, cancelled_flag, rejected_flag,
5020: assigned_flag, working_flag, schedulable_flag, accepted_flag,
5021: on_hold_flag, approved_flag
5022:
5023: FROM jtf_task_statuses_b
5024: WHERE task_status_id = p_task_status_id;
5025: BEGIN
5026: IF (p_task_status_id = 8)
5027: OR (p_task_status_id = 4)