APPS.CAC_SYNC_TASK_UTL dependencies on JTF_TASKS_B

Line 26: FROM jtf_tasks_b

22: RETURN BOOLEAN
23: IS
24: CURSOR c_first_taskid (b_task_id NUMBER) IS
25: SELECT min(task_id) task_id
26: FROM jtf_tasks_b
27: WHERE NVL(deleted_flag,'N') = 'N'
28: AND recurrence_rule_id = (SELECT recurrence_rule_id
29: FROM jtf_tasks_b
30: WHERE task_id = b_task_id);

Line 29: FROM jtf_tasks_b

25: SELECT min(task_id) task_id
26: FROM jtf_tasks_b
27: WHERE NVL(deleted_flag,'N') = 'N'
28: AND recurrence_rule_id = (SELECT recurrence_rule_id
29: FROM jtf_tasks_b
30: WHERE task_id = b_task_id);
31:
32: rec_first_taskid c_first_taskid%ROWTYPE;
33: l_result BOOLEAN := FALSE;

Line 55: FROM jtf_tasks_b

51: RETURN NUMBER
52: IS
53: CURSOR c_task (b_start_date DATE, b_recurrence_rule_id NUMBER) IS
54: SELECT task_id
55: FROM jtf_tasks_b
56: WHERE calendar_start_date > b_start_date
57: AND recurrence_rule_id = b_recurrence_rule_id
58: AND NVL(deleted_flag,'N') = 'N'
59: HAVING ROWNUM = 1

Line 110: , jtf_tasks_b jtb

106: SELECT jtaa.resource_id
107: , jtb.calendar_start_date
108: , jtb.recurrence_rule_id
109: FROM jtf_task_all_assignments jtaa
110: , jtf_tasks_b jtb
111: WHERE jtaa.task_id = b_task_id
112: AND jtb.task_id = jtaa.task_id;
113:
114: l_sync_id NUMBER;