Find Vacation rule details of an user

select * from apps.WF_ROUTING_RULES
where role='<USER NAME>'

we can also check vacation rules for other users by
Oracle Administrator > Workflow status monitor > Administration > Vacation Rules

Need not login as the same user to check for vacation rule details.