Код
declare
var_b_id number;
var_i_id number;
l_count number;
t_number number;
begin
t_number := :P34_Table;
l_count := APEX_COLLECTION.COLLECTION_MEMBER_COUNT( p_collection_name => 'my_booking');
for i in 1..l_count loop
var_b_id :=i;
insert into BOOKINGS (b_id,tables,Data,Ready)
values((SELECT C001 FROM apex_collections WHERE COLLECTION_NAME='MY_BOOKING' and seq_id=i),t_number,Sysdate(),0);
UPDATE ingtes (Всё что выше работает)
set i_count=i_count-(select count
from ingres_for_blud where ingres_for_blud.b_id
=
(SELECT C001
FROM apex_collections
WHERE COLLECTION_NAME='MY_BOOKING'
and
seq_id=i))
where
(ingres_for_blud.b_id
=
(SELECT C001
FROM apex_collections
WHERE COLLECTION_NAME='MY_BOOKING'
and
seq_id=i))
and
(INGRES_FOR_BLUD.I_ID = ingtes.id);
end loop;
end;

Ошибка
ORA-06550: line 32, column 2: PL/SQL: ORA-00904: "INGRES_FOR_BLUD"."I_ID": invalid identifier ORA-06550: line 14, column 1: PL/SQL: SQL Statement ignored

При том что "INGRES_FOR_BLUD"."I_ID" правильный идентификатор

Помогите пожалуйста, а то у меня голова взрывается