APPS.POR_NOTIFICATION_PKG dependencies on DUAL

Line 34: ((select user from dual) union all

30: cursor attrs(user in varchar2, origSys in varchar2, origId in number) is
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

Line 45: select 'PORCPT' from dual)

41: union
42: select distinct WF_APPROVAL_ITEMTYPE
43: from PO_DOCUMENT_TYPES
44: union
45: select 'PORCPT' from dual)
46: and wn.status = 'OPEN'
47: and exists( select 1 from WF_NOTIFICATION_ATTRIBUTES NA,
48: WF_MESSAGE_ATTRIBUTES_VL MA,
49: WF_NOTIFICATIONS N