APPS.WFA_HTML_UTIL dependencies on WF_NOTIFICATIONS

Line 205: WF_NOTIFICATIONS N

201: select text_value
202: into buf
203: from WF_NOTIFICATION_ATTRIBUTES NA,
204: WF_MESSAGE_ATTRIBUTES_VL MA,
205: WF_NOTIFICATIONS N
206: where N.NOTIFICATION_ID = nid
207: and NA.NOTIFICATION_ID = N.NOTIFICATION_ID
208: and MA.MESSAGE_NAME = N.MESSAGE_NAME
209: and MA.MESSAGE_TYPE = N.MESSAGE_TYPE

Line 279: -- Populate WF_NOTIFICATIONS with the needed values with supplied langcode.

275: end GetDisplayValue;
276:
277: --
278: -- GetDenormalizedValues
279: -- Populate WF_NOTIFICATIONS with the needed values with supplied langcode.
280: -- Then returns those values via the out variables.
281: -- IN:
282: -- nid - notification id
283: -- langcode - language code

Line 301: from WF_NOTIFICATIONS

297:
298: begin
299: select FROM_USER, TO_USER, SUBJECT
300: into from_user, to_user, subject
301: from WF_NOTIFICATIONS
302: where NOTIFICATION_ID = nid;
303: exception
304: when OTHERS then
305: from_user := null;