APPS.JTF_TASK_SYNC_UPGRADE_PKG dependencies on JTF_TASK_ALL_ASSIGNMENTS

Line 647: FROM jtf_task_all_assignments a

643: CURSOR c_appt_with_mixed_status IS
644: SELECT DISTINCT
645: t.task_id
646: , a.task_assignment_id
647: FROM jtf_task_all_assignments a
648: , jtf_tasks_b t
649: , (SELECT /*+ parallel(jtb) */ jtb.recurrence_rule_id
650: , jtaa.resource_id
651: , SUM(decode(jtaa.assignment_status_id, 3, 1, 0)) num_of_accept

Line 654: FROM jtf_task_all_assignments jtaa

650: , jtaa.resource_id
651: , SUM(decode(jtaa.assignment_status_id, 3, 1, 0)) num_of_accept
652: , SUM(decode(jtaa.assignment_status_id, 4, 1, 0)) num_of_reject
653: , SUM(decode(jtaa.assignment_status_id, 18, 1, 0)) num_of_invitee
654: FROM jtf_task_all_assignments jtaa
655: , jtf_tasks_b jtb
656: WHERE jtb.recurrence_rule_id IS NOT NULL
657: AND jtb.source_object_type_code = 'APPOINTMENT'
658: AND jtaa.task_id = jtb.task_id

Line 688: UPDATE jtf_task_all_assignments

684: FOR rec_appt_with_mixed_status IN c_appt_with_mixed_status
685: LOOP
686: l_num := l_num + 1;
687:
688: UPDATE jtf_task_all_assignments
689: SET assignment_status_id = 18
690: , last_updated_by = fnd_global.user_id
691: WHERE task_assignment_id = rec_appt_with_mixed_status.task_assignment_id;
692:

Line 723: FROM jtf_task_all_assignments a

719: ,b_valid_count NUMBER) IS
720: SELECT a.resource_id
721: , a.resource_type_code
722: , count(a.task_assignment_id)
723: FROM jtf_task_all_assignments a
724: , jtf_tasks_b t
725: WHERE t.recurrence_rule_id = b_recurrence_rule_id
726: AND t.source_object_type_code = 'APPOINTMENT'
727: AND (t.object_changed_date = to_date('01/02/1970','MM/DD/YYYY') OR