Как можно использовать параметры в процедурах с конструкцией типа 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

$$;


Ответы (0 шт):