Log in Oracle Applications.
System Administrator-->Oracle Applications Manager --> Workflow
Homepage will get opened like below.
Then click on Site Map tab as show below.
After that from page click on Notification Mailer Link
Below page will get opened.
From that Click on Workflow Notification Mailer as shown below-
After that below page will get opened, from that click on 'set override address' button.
Enter your email which you want set for getting all workflow notifications
After clicking on link and entering code, you will see that your email id has succesfully added in workflow notification mailer.
SQL to find out email address set in override address of workflow notification mailer-