APPS.WF_XML dependencies on WF_NOTIFICATION_ATTRIBUTES

Line 39: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,

35:
36:
37: cursor g_urls(p_nid varchar2) is
38: select WMA.TYPE, WMA.DISPLAY_NAME, WNA.TEXT_VALUE, WNA.NAME
39: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,
40: WF_MESSAGE_ATTRIBUTES_VL WMA
41: where WNA.NOTIFICATION_ID = p_nid
42: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID
43: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE

Line 917: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,

913: cursor c_attr(p_nid varchar2) is
914: select WMA.TYPE, WMA.DISPLAY_NAME,
915: decode(WMA.TYPE, 'URL', WF_NOTIFICATION.GetUrlText(WNA.TEXT_VALUE,
916: p_nid), WNA.TEXT_VALUE) URL, WNA.NAME
917: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,
918: WF_MESSAGE_ATTRIBUTES_VL WMA
919: where WNA.NOTIFICATION_ID = p_nid
920: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID
921: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE

Line 1320: from WF_NOTIFICATION_ATTRIBUTES WNA,

1316: '', to_char(WNA.DATE_VALUE),
1317: to_char(WNA.DATE_VALUE, WMA.FORMAT)),
1318: 'LOOKUP', WNA.TEXT_VALUE,
1319: WNA.TEXT_VALUE) VALUE
1320: from WF_NOTIFICATION_ATTRIBUTES WNA,
1321: WF_NOTIFICATIONS WN,
1322: WF_MESSAGE_ATTRIBUTES_VL WMA
1323: where WNA.NOTIFICATION_ID = p_nid
1324: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID