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 479: FROM jtf_task_all_assignments jtaa

475: SELECT jtaa.task_assignment_id
476: , jtaa.object_version_number
477: , jtaa.task_id
478: , jtb.calendar_start_date
479: FROM jtf_task_all_assignments jtaa
480: , jtf_tasks_b jtb
481: WHERE jtb.recurrence_rule_id = b_recurrence_rule_id
482: AND ((b_delete_option = JTF_TASK_REPEAT_APPT_PVT.G_ALL) OR
483: (b_delete_option = JTF_TASK_REPEAT_APPT_PVT.G_ONE AND jtb.calendar_start_date = b_calendar_start_date) OR