APPS.POR_NOTIFICATION_PKG dependencies on WF_NOTIFICATIONS

Line 32: from WF_NOTIFICATIONS WN

28: and orig_system not in ('POS', 'ENG_LIST', 'CUST_CONT');
29:
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

Line 49: WF_NOTIFICATIONS N

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
50: where
51: N.NOTIFICATION_ID=WN.NOTIFICATION_ID
52: and NA.NOTIFICATION_ID = N.NOTIFICATION_ID
53: and MA.MESSAGE_NAME = N.MESSAGE_NAME