APPS.WF_XML dependencies on DUAL

Line 1625: from dual

1621: -- the response attributes.
1622: l_response := 0;
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

Line 1913: -- Determine the total list of individual recipients

1909: when others then
1910: raise;
1911: end;
1912: if l_recipient_role is not null then
1913: -- Determine the total list of individual recipients
1914: -- ordered by Protocol and then Language.
1915: l_recipient_list.DELETE;
1916: GetRecipients(l_recipient_role, l_recipient_list);
1917:

Line 2631: from sys.dual;

2627:
2628: begin
2629: select userenv('LANGUAGE')
2630: into nls_base
2631: from sys.dual;
2632:
2633: underscore_pos := instr(nls_base, '_');
2634: dot_pos := instr(nls_base, '.');
2635:

Line 4118: -- send or not should come from the individual memebers and not the

4114:
4115:
4116: -- 4104735 Removing the test for "p_notification_pref not in
4117: -- ('QUERY','SUMMARY','SUMHTML', 'DISABLED')". The rule to
4118: -- send or not should come from the individual memebers and not the
4119: -- parent role. If there are simply no members then the NULL document
4120: -- should be sent. The testing of the notification preference for
4121: -- the members will be performed again in genreateDoc.
4122: if members_t.count = 0 then