APPS.JTA_SYNC_TASK_CURSORS dependencies on JTF_TASKS_B

Line 20: | last_update_date in jtf_tasks_b table |

16: |Date Developer Change |
17: |----------- --------- ------------------------------------------- |
18: |04-02-02 SSALLAKA Created |
19: |04-19-2002 SSALLAKA Updated with Object_changted_date instead |
20: | last_update_date in jtf_tasks_b table |
21: |04-22-2002 CJANG Added t.owner_type_code = 'RS_EMPLOYEE' |
22: | in the cursor c_delete_assignment |
23: |04-23-2002 CJANG When a user change non-repeat to repeat |
24: | after sync, the cursor c_new_repeating_task|

Line 146: jtf_tasks_b t,

142: jtf_task_statuses_b ts,
143: jtf_task_priorities_b tb,
144: jtf_tasks_tl tl,
145: jtf_task_all_assignments ta,
146: jtf_tasks_b t,
147: (SELECT jtb.recurrence_rule_id
148: , MIN (jtb.task_id) task_id
149: FROM jtf_tasks_b jtb
150: , jtf_task_all_assignments jtaa

Line 149: FROM jtf_tasks_b jtb

145: jtf_task_all_assignments ta,
146: jtf_tasks_b t,
147: (SELECT jtb.recurrence_rule_id
148: , MIN (jtb.task_id) task_id
149: FROM jtf_tasks_b jtb
150: , jtf_task_all_assignments jtaa
151: WHERE jtaa.resource_id = b_resource_id
152: AND jtaa.resource_type_code = b_resource_type
153: AND jtb.task_id = jtaa.task_id

Line 242: jtf_tasks_b t

238: jtf_task_all_assignments ta,
239: jtf_task_statuses_b ts,
240: jtf_task_priorities_b tb,
241: jtf_tasks_tl tl,
242: jtf_tasks_b t
243: WHERE tm.resource_id = jta_sync_task.g_login_resource_id
244: AND t.task_id = tm.task_id
245: AND t.task_id = ta.task_id
246: AND tl.task_id = t.task_id

Line 280: FROM jtf_tasks_b t

276: b_resource_type VARCHAR2,
277: b_source_object_type VARCHAR2)
278: IS
279: SELECT tm.task_sync_id
280: FROM jtf_tasks_b t
281: , jta_sync_task_mapping tm
282: WHERE tm.resource_id = jta_sync_task.g_login_resource_id
283: AND t.task_id = tm.task_id
284: AND ( (b_resource_type = 'RS_GROUP' AND

Line 306: FROM jtf_tasks_b t

302: b_resource_type VARCHAR2,
303: b_source_object_type VARCHAR2)
304: IS
305: SELECT tm.task_sync_id
306: FROM jtf_tasks_b t
307: , jta_sync_task_mapping tm
308: , jtf_task_all_assignments ta
309: WHERE tm.resource_id = jta_sync_task.g_login_resource_id
310: AND t.task_id = tm.task_id

Line 330: FROM jtf_tasks_b t

326: b_resource_type VARCHAR2,
327: b_source_object_type VARCHAR2)
328: IS
329: SELECT tm.task_sync_id
330: FROM jtf_tasks_b t
331: , jta_sync_task_mapping tm
332: WHERE tm.resource_id = jta_sync_task.g_login_resource_id
333: AND t.task_id = tm.task_id
334: AND ( (b_resource_type = 'RS_GROUP' AND

Line 370: FROM jtf_tasks_b t

366: b_resource_type VARCHAR2,
367: b_source_object_type VARCHAR2)
368: IS
369: SELECT tm.task_sync_id
370: FROM jtf_tasks_b t
371: , jta_sync_task_mapping tm
372: WHERE tm.resource_id = jta_sync_task.g_login_resource_id
373: AND t.task_id = tm.task_id
374: AND t.owner_type_code = b_resource_type

Line 418: jtf_tasks_b t

414: greatest(t.object_changed_date, ta.last_update_date) new_timestamp
415: FROM jtf_task_all_assignments ta,
416: jtf_task_priorities_b tb,
417: jtf_tasks_tl tl,
418: jtf_tasks_b t
419: WHERE ta.resource_id = b_resource_id
420: AND ta.resource_type_code = b_resource_type
421: -- Commented by TSINGHAL to fix bug 4397779
422: /* AND ta.assignment_status_id IN (3, -- Accepted

Line 486: jtf_tasks_b t

482: FROM jta_sync_task_mapping tm,
483: jtf_task_all_assignments ta,
484: jtf_task_priorities_b tb,
485: jtf_tasks_tl tl,
486: jtf_tasks_b t
487: WHERE tm.resource_id = jta_sync_task.g_login_resource_id
488: AND t.task_id = tm.task_id
489: AND ( (b_resource_type = 'RS_GROUP' AND
490: t.owner_type_code = b_resource_type AND

Line 522: FROM jtf_tasks_b b, jta_sync_task_mapping m

518: b_source_object_type VARCHAR2
519: )
520: IS
521: SELECT m.task_sync_id
522: FROM jtf_tasks_b b, jta_sync_task_mapping m
523: WHERE b.task_id = m.task_id
524: AND m.resource_id = jta_sync_task.g_login_resource_id
525: AND NVL (b.deleted_flag, 'N') = 'N'
526: AND b.owner_type_code ='RS_GROUP'