DBA Data[Home] [Help]

APPS.JTF_TASK_RECURRENCES_PVT dependencies on JTF_TASK_ALL_ASSIGNMENTS

Line 2303: from jtf_task_all_assignments

2299: actual_travel_duration,
2300: actual_travel_duration_uom,
2301: actual_effort,
2302: actual_effort_uom
2303: from jtf_task_all_assignments
2304: where task_id = p_task_id;
2305:
2306: l_booking_start_date Date;
2307: l_booking_end_date Date;

Line 3099: UPDATE jtf_task_all_assignments

3095: x_booking_start_date => l_booking_start_date,
3096: x_booking_end_date => l_booking_end_date
3097: );
3098:
3099: UPDATE jtf_task_all_assignments
3100: SET booking_start_date = l_booking_start_date,
3101: booking_end_date = l_booking_end_date
3102: WHERE task_assignment_id = i.task_assignment_id;
3103: END LOOP;

Line 3351: UPDATE jtf_task_all_assignments

3347: ---------------------------------------------
3348: -- Change the status of all assignees to 18
3349: -- for the copied
3350: ---------------------------------------------
3351: UPDATE jtf_task_all_assignments
3352: SET assignment_status_id = 18
3353: , last_update_date = SYSDATE
3354: , last_updated_by = fnd_global.user_id
3355: WHERE task_id = l_new_task_id