eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WF_MAIL dependencies on WF_USER_ROLES

Line 447: from wf_roles r, wf_user_roles ur

443:
444: cursor c_roles(parent in varchar2)
445: is
446: select name, email_address
447: from wf_roles r, wf_user_roles ur
448: where ur.role_name = parent
449: and r.name = ur.user_name;
450:
451: begin

Line 1670: from wf_user_roles wur

1666: )
1667: WHERE role <> current_role
1668: -- this role should not be a role to whome current user belongs
1669: AND role not in (select wur.role_name
1670: from wf_user_roles wur
1671: where wur.user_name = current_role
1672: and wur.user_orig_system = orig_sys
1673: and wur.user_orig_system_id = orig_sysid
1674: )

Line 5944: from WF_USER_ROLES UR

5940: and RECIPIENT_ROLE IN
5941: (select role from dual
5942: union
5943: select UR.ROLE_NAME
5944: from WF_USER_ROLES UR
5945: where UR.USER_ORIG_SYSTEM = rorig_system
5946: and UR.USER_ORIG_SYSTEM_ID = rorig_system_id
5947: and UR.USER_NAME = role)
5948: order by PRIORITY desc, DUE_DATE asc, NOTIFICATION_ID asc ;