Query to find vacation rules in Oracle R12

1--Query to find delegate rules for APEXP workflow. change the workflow type in the query to find related delegate rules.(Unimportant columns are commented in the select statement)
2SELECT routingruleseo.role            employee,
3       routingruleseo.action_argument delegate,
4       -- routingruleseo.rule_id,
5       routingruleseo.MESSAGE_TYPE,
6       -- routingruleseo.message_name,
7       routingruleseo.begin_date,
8       routingruleseo.end_date,
9       routingruleseo.action,
10       -- itemtypeseo.display_name type_display,
11       --messageseo.display_name msg_display,
12       -- messageseo.subject,
13       lookupseo.meaning              AS action_display,
14       itemtypeseo.name                                                    --,
15  -- messageseo.type,
16  -- messageseo.name AS name1,
17  -- lookupseo.lookup_type,
18  -- lookupseo.lookup_code
19  FROM apps.wf_routing_rules routingruleseo,
20       apps.wf_item_types_vl itemtypeseo,
21       apps.wf_messages_vl   messageseo,
22       apps.wf_lookups       lookupseo
23 WHERE     1 = 1                                   -- routingruleseo.role = :1
24       AND routingruleseo.MESSAGE_TYPE = itemtypeseo.name(+)
25       AND routingruleseo.MESSAGE_TYPE = messageseo.TYPE(+)
26       AND routingruleseo.message_name = messageseo.name(+)
27       AND routingruleseo.action = lookupseo.lookup_code
28       AND lookupseo.lookup_type = 'WFSTD_ROUTING_ACTIONS'
29       AND MESSAGE_TYPE = 'APEXP'
30       AND routingruleseo.end_date > SYSDATE
31--ORDER BY
32-- type_display,
33-- msg_display,
34-- begin_date
35;