APPS.JTA_SYNC_TASK_UTL dependencies on JTF_TASKS_B

Line 30: FROM jtf_tasks_b

26: RETURN BOOLEAN
27: IS
28: CURSOR c_first_taskid (b_task_id NUMBER) IS
29: SELECT min(task_id) task_id
30: FROM jtf_tasks_b
31: WHERE NVL(deleted_flag,'N') = 'N'
32: AND recurrence_rule_id = (SELECT recurrence_rule_id
33: FROM jtf_tasks_b
34: WHERE task_id = b_task_id);

Line 33: FROM jtf_tasks_b

29: SELECT min(task_id) task_id
30: FROM jtf_tasks_b
31: WHERE NVL(deleted_flag,'N') = 'N'
32: AND recurrence_rule_id = (SELECT recurrence_rule_id
33: FROM jtf_tasks_b
34: WHERE task_id = b_task_id);
35:
36: rec_first_taskid c_first_taskid%ROWTYPE;
37: l_result BOOLEAN := FALSE;

Line 59: FROM jtf_tasks_b

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

Line 113: , jtf_tasks_b jtb

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