DBA Data[Home] [Help]

APPS.WF_MAIL dependencies on DUAL

Line 2505: from dual

2501: -- Check if this is FYI type of message
2502: if (t_name = 'OPEN_MAIL') then
2503: begin
2504: select 1 into fyi
2505: from dual
2506: where not exists (select NULL
2507: from WF_MESSAGE_ATTRIBUTES MA,
2508: WF_NOTIFICATIONS N
2509: where N.NOTIFICATION_ID = nid

Line 5941: (select role from dual

5937: select NOTIFICATION_ID, RECIPIENT_ROLE, ACCESS_KEY, PRIORITY, DUE_DATE
5938: from WF_NOTIFICATIONS
5939: where STATUS = 'OPEN'
5940: and RECIPIENT_ROLE IN
5941: (select role from dual
5942: union
5943: select UR.ROLE_NAME
5944: from WF_USER_ROLES UR
5945: where UR.USER_ORIG_SYSTEM = rorig_system

Line 7472: from sys.dual;

7468: dot integer;
7469: begin
7470: select userenv('LANGUAGE')
7471: into nls_str
7472: from sys.dual;
7473:
7474: underscore := instr(nls_str,'_',1,1);
7475: dot := instr(nls_str, '.',1,1);
7476: