APPS.IBE_WF_NOTIF_MSG_MAPS_PVT dependencies on DUAL

Line 83: from DUAL

79: P_MSITE_ID,
80: P_ORG_ID,
81: P_CREATION_DATE,
82: P_CREATED_BY
83: from DUAL
84: where not exists
85: (select NULL
86: from IBE_WF_NOTIF_MSG_MAPS T
87: where T.NOTIF_MSG_MAP_ID = P_NOTIF_MSG_MAP_ID

Line 416: from dual

412: BEGIN
413: if( p_object_version_number = FND_API.G_MISS_NUM OR p_object_version_number IS NULL ) then
414: select '1'
415: into l_exists
416: from dual
417: where exists (
418: select notif_msg_map_id, object_version_number
419: From ibe_wf_notif_msg_maps
420: where notif_msg_map_id = p_notif_msg_map_id

Line 433: from dual

429: end if;
430: else
431: select '1'
432: into l_exists
433: from dual
434: where exists (
435: select notif_msg_map_id, object_version_number
436: From ibe_wf_notif_msg_maps
437: where notif_msg_map_id = p_notif_msg_map_id

Line 614: from dual;

610: if( l_operation_type = 'INSERT' ) then
611: debug('save_notif_msg_maps 7');
612: select ibe_wf_notif_msg_maps_s1.nextval
613: into l_notif_msg_map_id
614: from dual;
615:
616: debug('save_notif_msg_maps 8');
617: select notif_setup_id
618: into l_notif_setup_id