546: -- Delete resource list uses, details of resource list assignments
547: delete from pa_resource_list_uses
548: where resource_list_assignment_id in
549: (select resource_list_assignment_id
550: from pa_resource_list_assignments
551: where project_id = x_project_id );
552:
553: -- Delete resource list assignments
554: delete from pa_resource_list_assignments
550: from pa_resource_list_assignments
551: where project_id = x_project_id );
552:
553: -- Delete resource list assignments
554: delete from pa_resource_list_assignments
555: where project_id = x_project_id ;
556:
557: /* Bug#3480409 : FP.M Changes: Added code for deleting object exceptions, starts here */
558: BEGIN