APPS.WF_NOTIFICATION dependencies on WF_MESSAGES_VL

Line 2694: from WF_NOTIFICATIONS N, WF_MESSAGES_VL WM

2690: begin
2691: -- Get subject
2692: select WM.SUBJECT
2693: into local_subject
2694: from WF_NOTIFICATIONS N, WF_MESSAGES_VL WM
2695: where N.NOTIFICATION_ID = nid
2696: and N.MESSAGE_NAME = WM.NAME
2697: and N.MESSAGE_TYPE = WM.TYPE;
2698:

Line 2786: from WF_NOTIFICATIONS N, WF_MESSAGES_VL WM

2782: begin
2783: -- Get body
2784: select WM.BODY, WM.HTML_BODY
2785: into local_body, local_html_body
2786: from WF_NOTIFICATIONS N, WF_MESSAGES_VL WM
2787: where N.NOTIFICATION_ID = nid
2788: and N.MESSAGE_NAME = WM.NAME
2789: and N.MESSAGE_TYPE = WM.TYPE;
2790:

Line 2936: from WF_NOTIFICATIONS N, WF_MESSAGES_VL WM

2932: begin
2933: -- Get body
2934: select WM.BODY
2935: into local_body
2936: from WF_NOTIFICATIONS N, WF_MESSAGES_VL WM
2937: where N.NOTIFICATION_ID = nid
2938: and N.MESSAGE_NAME = WM.NAME
2939: and N.MESSAGE_TYPE = WM.TYPE;
2940:

Line 5310: FROM wf_messages_vl

5306:
5307: -- Get the message subject
5308: SELECT SUBJECT
5309: INTO local_text
5310: FROM wf_messages_vl
5311: WHERE type = message_type
5312: AND name = message_name;
5313:
5314: for msg_attr_row in message_attrs_cursor (message_type, message_name) loop

Line 5382: FROM wf_messages_vl

5378:
5379: -- Get the message subject
5380: SELECT SUBJECT
5381: INTO local_text
5382: FROM wf_messages_vl
5383: WHERE type = message_type
5384: AND name = message_name;
5385:
5386: for msg_attr_row in message_attrs_cursor (message_type, message_name) loop

Line 8895: from WF_NOTIFICATIONS N, WF_MESSAGES_VL WM

8891: lv_fwk_body := 'N';
8892:
8893: select nvl(WM.BODY, ''), nvl(WM.HTML_BODY, '')
8894: into lv_body, lv_html_body
8895: from WF_NOTIFICATIONS N, WF_MESSAGES_VL WM
8896: where N.NOTIFICATION_ID = nid
8897: and N.MESSAGE_NAME = WM.NAME
8898: and N.MESSAGE_TYPE = WM.TYPE;
8899: