DBA Data[Home] [Help]

APPS.JTF_TASK_RECURRENCES_PVT dependencies on JTF_TASK_ALL_ASSIGNMENTS

Line 2306: from jtf_task_all_assignments

2302: actual_effort,
2303: actual_effort_uom,
2304: resource_type_code,
2305: resource_id
2306: from jtf_task_all_assignments
2307: where task_id = p_task_id;
2308:
2309: l_booking_start_date Date;
2310: l_booking_end_date Date;

Line 3105: UPDATE jtf_task_all_assignments

3101: x_booking_start_date => l_booking_start_date,
3102: x_booking_end_date => l_booking_end_date
3103: );
3104:
3105: UPDATE jtf_task_all_assignments
3106: SET booking_start_date = l_booking_start_date,
3107: booking_end_date = l_booking_end_date
3108: WHERE task_assignment_id = i.task_assignment_id;
3109:

Line 3405: UPDATE jtf_task_all_assignments

3401: ---------------------------------------------
3402: -- Change the status of all assignees to 18
3403: -- for the copied
3404: ---------------------------------------------
3405: UPDATE jtf_task_all_assignments
3406: SET assignment_status_id = 18
3407: , last_update_date = SYSDATE
3408: , last_updated_by = fnd_global.user_id
3409: WHERE task_id = l_new_task_id