APPS.IBE_WF_NOTIF_SETUP_PVT dependencies on DUAL

Line 72: FROM DUAL

68: P_LAST_UPDATED_BY,
69: P_LAST_UPDATE_DATE,
70: P_LAST_UPDATE_LOGIN,
71: P_OBJECT_VERSION_NUMBER
72: FROM DUAL
73: WHERE not exists
74: (select NULL
75: from IBE_WF_NOTIF_SETUP T
76: where T.NOTIF_SETUP_ID = P_NOTIF_SETUP_ID);

Line 307: from dual

303: BEGIN
304: --debug('in Validate_Name ' || p_notification_name);
305: select '1'
306: into l_exists
307: from dual
308: where exists(
309: select distinct notification_name
310: from ibe_wf_notif_setup
311: where notification_name = p_notification_name);

Line 336: From Dual

332: BEGIN
333: if( p_object_version_number = FND_API.G_MISS_NUM OR p_object_version_number is NULL ) then
334: select '1'
335: into l_exists
336: From Dual
337: where exists(
338: select notif_setup_id, object_version_number, notification_name
339: from ibe_wf_notif_setup
340: where notif_setup_id = p_notif_setup_id);

Line 353: From Dual

349: END if;
350: else
351: select '1'
352: into l_exists
353: From Dual
354: where exists(
355: select notif_setup_id, object_version_number, notification_name
356: from ibe_wf_notif_setup
357: where notif_setup_id = p_notif_setup_id

Line 409: From dual;

405: l_exists VARCHAr2(1);
406: l_object_version_number NUMBER;
407: cursor wf_setup_seq IS
408: select ibe_wf_notif_setup_s1.nextval
409: From dual;
410: l_rowid ROWID;
411: BEGIN
412: --debug('Save_wf_notif_setup 1');
413: savepoint save_wf_notif_setup;