create or replace procedure V8_CCM_YEMN_YEBR_DESCRIPTION as
begin
    update yemn set yemn_description=(select YSME_DESCRIPTION from ysme where ysme_id=yemn_ysme_id)
    where trunc(yemn_servestart)>=(select wgbs_datevalue from fideliodate) 
    and yemn_description is null;

    update yebr set yebr_description=(select ycit_description from ycit where ycit_id=yebr_ycit_id)
    where trunc(yebr_starttime)>=(select wgbs_datevalue from fideliodate)
    and yebr_description is null;
end;
/
