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.
