Many legacy apps use tons of them. In the late 90's there was a style of application development where all DB access went through stored procedures. I find PL/SQL to be terrible.
There are still tons of PL/SQL developers, and a huge ecosystem that uses these things. Triggers were big at one time too.
You will be surprised how H1B 'specialised talent' developers are just people who have worked on these ancient technologies all life, are near impossible to replace so you are left with no options but to hire them.
Oracle is a whole different specialisation in itself and its tentacles go very deep and afar.
PL/SQL is terrible. But organizing your Oracle database in a way where you can do everything with only application-accessible statements is even worse.
Oracle places still do a lot of stored procedures.
