Как можно использовать параметры в процедурах с конструкцией типа DO$$ END$$
DO
$$
DECLARE
new_id integer;
status_id integer;
steps_id integer;
state integer;
BEGIN
OPEN temp FOR
select app.id, pc.id
from final_decision fd
join APP_PRE_APROV_LOAN app on app.FIN_DECISION_LINK = fd.id
join DICT_DECISION_EG ra on ra.id = fd.RESULT_ASPR
join MICRO_APPLICATION ma on app.id = ma.app_ul_id
join PORTFOLIO_CREDIT pc on ma.app_portfolio_id = pc.id
where app.id not in (select sh.aplication_id
from status_history sh
join LOGS_STATUS_DICT lsd on lsd.id = sh.APP_STATUS
where sh.status=1 and lsd.name = 'Сформировано заключение АСПР')
and **pc.id**=:ID_PORTFL;
LOOP
FETCH temp INTO
app_id,
name_company,
status_id,
steps_id,
state;
IF NOT FOUND THEN EXIT;
END LOOP;
CLOSE temp;
END
$$;