APPS.WF_XML dependencies on WF_MESSAGE_ATTRIBUTES

Line 42: WF_MESSAGE_ATTRIBUTES_VL WMA

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

Line 1035: WF_MESSAGE_ATTRIBUTES_VL WMA

1031: select WMA.TYPE, WMA.DISPLAY_NAME,
1032: decode(WMA.TYPE, 'URL', WF_NOTIFICATION.GetUrlText(WNA.TEXT_VALUE,
1033: p_nid), WNA.TEXT_VALUE) URL, WNA.NAME
1034: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,
1035: WF_MESSAGE_ATTRIBUTES_VL WMA
1036: where WNA.NOTIFICATION_ID = p_nid
1037: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID
1038: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE
1039: and WN.MESSAGE_NAME = WMA.MESSAGE_NAME

Line 1393: WF_MESSAGE_ATTRIBUTES_VL WMA

1389: 'LOOKUP', WNA.TEXT_VALUE,
1390: WNA.TEXT_VALUE) VALUE
1391: from WF_NOTIFICATION_ATTRIBUTES WNA,
1392: WF_NOTIFICATIONS WN,
1393: WF_MESSAGE_ATTRIBUTES_VL WMA
1394: where WNA.NOTIFICATION_ID = p_nid
1395: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID
1396: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE
1397: and WN.MESSAGE_NAME = WMA.MESSAGE_NAME

Line 1627: from WF_MESSAGE_ATTRIBUTES MA,

1623: begin
1624: select 1 into l_response
1625: from dual
1626: where exists (select NULL
1627: from WF_MESSAGE_ATTRIBUTES MA,
1628: WF_NOTIFICATIONS N
1629: where N.NOTIFICATION_ID = p_nid
1630: and MA.MESSAGE_TYPE = N.MESSAGE_TYPE
1631: and MA.MESSAGE_NAME = N.MESSAGE_NAME