APPS.POR_NOTIFICATION_PKG dependencies on WF_USER_ROLES
Line 35: (select role_name from wf_user_roles
31: select WN.notification_id
32: from WF_NOTIFICATIONS WN
33: where WN.RECIPIENT_ROLE in
34: ((select user from dual) union all 35: (select role_name from wf_user_roles 36: where user_name = user and
37: user_orig_system = origSys and user_orig_system_id = origId ))
38: and wn.message_type in
39: ( select distinct WF_CREATEDOC_ITEMTYPE