APPS.CAC_SYNC_TASK_COMMON dependencies on JTF_TASKS_TL

Line 2265: jtf_tasks_tl tl,

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
2268: WHERE
2269: ta.task_id = t.task_id

Line 3275: select b.object_version_number,b.task_id from jtf_tasks_b b,jtf_tasks_tl t

3271: cursor doesBookingExists(b_task_name VARCHAR2,b_cal_start_date DATE,
3272: b_cal_end_date DATE,b_owner_type_code VARCHAR2,
3273: b_owner_id NUMBER)
3274: is
3275: select b.object_version_number,b.task_id from jtf_tasks_b b,jtf_tasks_tl t
3276: where b.entity in ('BOOKING','APPOINTMENT')
3277: and b.source_object_type_code='EXTERNAL APPOINTMENT'
3278: and t.task_id=b.task_id
3279: and t.language=userenv('LANG')

Line 3820: jtf_tasks_tl tl,

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
3823: WHERE
3824:

Line 4072: l_task_name jtf_tasks_tl.task_name%TYPE;

4068: WHERE recurrence_rule_id = b_recurrence_rule_id;
4069:
4070: l_changed_rule boolean ;
4071: l_status_id number;
4072: l_task_name jtf_tasks_tl.task_name%TYPE;
4073:
4074:
4075: cursor getTaskForRecurRule(b_task_id number) is
4076: select CAC.COLLAB_ID, CAC.MEETING_MODE,CAC.MEETING_ID,CAC.MEETING_URL,