DBA Data[Home] [Help]

APPS.WF_MAIL dependencies on DUAL

Line 2351: from dual

2347: -- Check if this is FYI type of message
2348: if (t_name = 'OPEN_MAIL') then
2349: begin
2350: select 1 into fyi
2351: from dual
2352: where not exists (select NULL
2353: from WF_MESSAGE_ATTRIBUTES MA,
2354: WF_NOTIFICATIONS N
2355: where N.NOTIFICATION_ID = nid

Line 5677: (select role from dual

5673: select NOTIFICATION_ID, RECIPIENT_ROLE, ACCESS_KEY, PRIORITY, DUE_DATE
5674: from WF_NOTIFICATIONS
5675: where STATUS = 'OPEN'
5676: and RECIPIENT_ROLE IN
5677: (select role from dual
5678: union
5679: select UR.ROLE_NAME
5680: from WF_USER_ROLES UR
5681: where UR.USER_ORIG_SYSTEM = rorig_system

Line 7200: from sys.dual;

7196: begin
7197:
7198: select userenv('LANGUAGE')
7199: into nls_str
7200: from sys.dual;
7201:
7202: underscore := instr(nls_str,'_',1,1);
7203: dot := instr(nls_str, '.',1,1);
7204: