APPS.CAC_SYNC_TASK_COMMON dependencies on JTF_TASK_RECUR_RULES

Line 41: FROM jtf_task_recur_rules jtrr, jtf_tasks_b jtb

37: --cursor to check if the task is recurring once every more than one year
38: cursor getTaskRecur(b_task_id IN NUMBER) is
39:
40: SELECT 1
41: FROM jtf_task_recur_rules jtrr, jtf_tasks_b jtb
42: WHERE ((jtrr.occurs_uom ='YER' AND
43: jtrr.occurs_every > 1)
44: OR
45: (jtrr.occurs_uom ='MON'

Line 2262: FROM jtf_task_recur_rules rc,

2258: CAC_VIEW_UTIL_PUB.get_locations(t.task_id) locations,
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,

Line 3817: FROM jtf_task_recur_rules rc,

3813: rc.occurs_which,
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,

Line 4935: FROM jtf_task_recur_rules jtrr, jtf_tasks_b jtb

4931: IS
4932: CURSOR c_task_recur (b_task_id NUMBER)
4933: IS
4934: SELECT jtrr.*
4935: FROM jtf_task_recur_rules jtrr, jtf_tasks_b jtb
4936: WHERE jtb.task_id = b_task_id
4937: AND jtb.recurrence_rule_id IS NOT NULL
4938: AND jtrr.recurrence_rule_id = jtb.recurrence_rule_id;
4939:

Line 5350: from jtf_task_recur_rules jtrr, jtf_tasks_b b

5346: OCCURS_MONTH,OCCURS_UOM,OCCURS_EVERY,
5347: OCCURS_NUMBER,START_DATE_ACTIVE,END_DATE_ACTIVE,
5348: SUNDAY,MONDAY,TUESDAY,WEDNESDAY,THURSDAY,FRIDAY,
5349: SATURDAY
5350: from jtf_task_recur_rules jtrr, jtf_tasks_b b
5351: where b.recurrence_rule_id=jtrr.recurrence_rule_id
5352: and b.task_id=b_task_id;
5353:
5354: l_get_recur_rule get_recur_rule%rowtype;