You as the owner of the procedure/view probably have been granted the access to V$SESSION through some role (probably through DBA role). To be able to access it from PL/SQL or from view, you need to have a direct grant to your schema. Use:

GRANT SELECT ANY TABLE TO skid;

or connect as SYS and do:

GRANT SELECT ON v_$session TO skid;