APPS.WF_NOTIFICATION dependencies on WF_USER_ROLE_ASSIGNMENTS_V

Line 965: from WF_LOCAL_ROLES wlr, WF_USER_ROLE_ASSIGNMENTS_V wurav

961: select NAME
962: into user_name
963: from (select wlr.NAME,
964: decode (wlr.ORIG_SYSTEM, 'PER', 1, 'FND_USR', 2, 3) ORIG_SYS_ORDER
965: from WF_LOCAL_ROLES wlr, WF_USER_ROLE_ASSIGNMENTS_V wurav
966: where wurav.USER_NAME = wlr.NAME and
967: wurav.ROLE_NAME = preferred_name and
968: upper(wlr.EMAIL_ADDRESS)=l_email
969: order by ORIG_SYS_ORDER)