APPS.JTF_TASK_REPEAT_ASSIGNMENT_PVT dependencies on JTF_TASK_ALL_ASSIGNMENTS

Line 80: FROM jtf_task_all_assignments jtaa

76: IS
77: SELECT jtb.task_id
78: , jtaa.task_assignment_id
79: , jtaa.object_version_number
80: FROM jtf_task_all_assignments jtaa
81: , jtf_tasks_b jtb
82: , jtf_task_all_assignments rs
83: WHERE jtb.recurrence_rule_id = b_recurrence_rule_id
84: AND rs.task_assignment_id = b_task_assignment_id

Line 82: , jtf_task_all_assignments rs

78: , jtaa.task_assignment_id
79: , jtaa.object_version_number
80: FROM jtf_task_all_assignments jtaa
81: , jtf_tasks_b jtb
82: , jtf_task_all_assignments rs
83: WHERE jtb.recurrence_rule_id = b_recurrence_rule_id
84: AND rs.task_assignment_id = b_task_assignment_id
85: AND jtaa.task_id = jtb.task_id
86: AND jtaa.resource_id = rs.resource_id;

Line 424: FROM jtf_task_all_assignments jtaa

420: SELECT jtaa.task_assignment_id
421: , jtaa.object_version_number
422: , jtaa.task_id
423: , jtb.calendar_start_date
424: FROM jtf_task_all_assignments jtaa
425: , jtf_tasks_b jtb
426: WHERE jtb.recurrence_rule_id = b_recurrence_rule_id
427: AND ((b_delete_option = JTF_TASK_REPEAT_APPT_PVT.G_ALL) OR
428: (b_delete_option = JTF_TASK_REPEAT_APPT_PVT.G_ONE AND jtb.calendar_start_date = b_calendar_start_date) OR