APPS.WF_ADVANCED_WORKLIST dependencies on WF_NOTIFICATIONS

Line 34: from WF_NOTIFICATIONS WN

30: -- Get recipient and original recipient of this notification
31: begin
32: select RECIPIENT_ROLE, ORIGINAL_RECIPIENT, FROM_ROLE, MORE_INFO_ROLE
33: into recipient, orig_recipient, from_role, more_info_role
34: from WF_NOTIFICATIONS WN
35: where WN.NOTIFICATION_ID = nid;
36: exception
37: when no_data_found then
38: Wf_Core.Token('NID', nid);

Line 60: wf_notifications ntf

56: from sys.dual
57: where exists ( select null
58: from wf_item_activity_statuses ias,
59: wf_item_activity_statuses_h iash,
60: wf_notifications ntf
61: where ntf.status = 'OPEN'
62: and ias.notification_id = ntf.notification_id
63: and ias.item_type = iash.item_type
64: and ias.item_key = iash.item_key

Line 67: from wf_notifications

63: and ias.item_type = iash.item_type
64: and ias.item_key = iash.item_key
65: and ias.process_activity = iash.process_activity
66: and iash.notification_id in (select notification_id
67: from wf_notifications
68: where status in ('CLOSED','CANCELED','INVALID')
69: and from_role = username)
70: and ntf.notification_id = nid
71: );

Line 98: from wf_notifications

94: begin
95: wf_notification.Denormalize_Notification(nid => p_nid, langcode => p_langcode );
96: select DECODE(MORE_INFO_ROLE, NULL, SUBJECT, FND_MESSAGE.GET_STRING('FND','FND_MORE_INFO_REQUESTED')||' '||SUBJECT) AS subject, to_user, from_user
97: into p_subject, p_touser, p_fromuser
98: from wf_notifications
99: where notification_id = p_nid;
100: exception
101: when OTHERS then
102: wf_core.context('Wf_Notification', 'getInfoAfterDenorm', p_nid);

Line 146: FROM wf_notifications wn,

142: FROM dual
143: WHERE username IN
144: (
145: SELECT fg.grantee_key
146: FROM wf_notifications wn,
147: wf_user_roles wur,
148: fnd_grants fg
149: WHERE ((wn.more_info_role IS NOT NULL AND wur.role_name = wn.more_info_role)
150: OR wur.role_name = wn.recipient_role)