APPS.WF_NOTIFICATION dependencies on WF_MESSAGES_VL

Line 2608: from WF_NOTIFICATIONS N, WF_MESSAGES_VL WM

2604: begin
2605: -- Get subject
2606: select WM.SUBJECT
2607: into local_subject
2608: from WF_NOTIFICATIONS N, WF_MESSAGES_VL WM
2609: where N.NOTIFICATION_ID = nid
2610: and N.MESSAGE_NAME = WM.NAME
2611: and N.MESSAGE_TYPE = WM.TYPE;
2612:

Line 2700: from WF_NOTIFICATIONS N, WF_MESSAGES_VL WM

2696: begin
2697: -- Get body
2698: select WM.BODY, WM.HTML_BODY
2699: into local_body, local_html_body
2700: from WF_NOTIFICATIONS N, WF_MESSAGES_VL WM
2701: where N.NOTIFICATION_ID = nid
2702: and N.MESSAGE_NAME = WM.NAME
2703: and N.MESSAGE_TYPE = WM.TYPE;
2704:

Line 2850: from WF_NOTIFICATIONS N, WF_MESSAGES_VL WM

2846: begin
2847: -- Get body
2848: select WM.BODY
2849: into local_body
2850: from WF_NOTIFICATIONS N, WF_MESSAGES_VL WM
2851: where N.NOTIFICATION_ID = nid
2852: and N.MESSAGE_NAME = WM.NAME
2853: and N.MESSAGE_TYPE = WM.TYPE;
2854:

Line 5473: FROM wf_messages_vl

5469:
5470: -- Get the message subject
5471: SELECT SUBJECT
5472: INTO local_text
5473: FROM wf_messages_vl
5474: WHERE type = message_type
5475: AND name = message_name;
5476:
5477: for msg_attr_row in message_attrs_cursor (message_type, message_name) loop

Line 5545: FROM wf_messages_vl

5541:
5542: -- Get the message subject
5543: SELECT SUBJECT
5544: INTO local_text
5545: FROM wf_messages_vl
5546: WHERE type = message_type
5547: AND name = message_name;
5548:
5549: for msg_attr_row in message_attrs_cursor (message_type, message_name) loop

Line 8645: from WF_NOTIFICATIONS N, WF_MESSAGES_VL WM

8641: lv_fwk_body := 'N';
8642:
8643: select nvl(WM.BODY, ''), nvl(WM.HTML_BODY, '')
8644: into lv_body, lv_html_body
8645: from WF_NOTIFICATIONS N, WF_MESSAGES_VL WM
8646: where N.NOTIFICATION_ID = nid
8647: and N.MESSAGE_NAME = WM.NAME
8648: and N.MESSAGE_TYPE = WM.TYPE;
8649: