Error in trigger: table is mutating
Replace

select portfoliono into mportfoliono from sipholder where accno=:new.accno;


with 

mportfoliono := new.portfoliono;


no need to use a SELECT for values of the updated row.