DBA Data[Home] [Help]

APPS.WFA_HTML_JSP dependencies on WF_NOTIFICATIONS

Line 52: from WF_NOTIFICATIONS

48: ctx := itemtype||':'||itemkey||':'||'%';
49: select MAX(notification_id) into nid
50: from (
51: select notification_id, context
52: from WF_NOTIFICATIONS
53: where more_info_role = username
54: union all
55: select notification_id, context
56: from WF_NOTIFICATIONS

Line 56: from WF_NOTIFICATIONS

52: from WF_NOTIFICATIONS
53: where more_info_role = username
54: union all
55: select notification_id, context
56: from WF_NOTIFICATIONS
57: where more_info_role is null
58: and RECIPIENT_ROLE in
59: (select WUR.ROLE_NAME
60: from WF_USER_ROLES WUR

Line 124: from WF_NOTIFICATIONS

120: ctx := itemtype||':'||itemkey||':'||'%';
121: select MAX(notification_id) into nid
122: from (
123: select notification_id, context
124: from WF_NOTIFICATIONS
125: where more_info_role = username
126: and status = 'OPEN'
127: union all
128: select notification_id, context

Line 129: from WF_NOTIFICATIONS

125: where more_info_role = username
126: and status = 'OPEN'
127: union all
128: select notification_id, context
129: from WF_NOTIFICATIONS
130: where more_info_role is null
131: and RECIPIENT_ROLE in
132: (select WUR.ROLE_NAME
133: from WF_USER_ROLES WUR