APPS.MSD_DEM_COLLECT_LEVEL_TYPES dependencies on DUAL

Line 269: FROM dual

265:
266: CURSOR c_check_new_items
267: IS
268: SELECT 1
269: FROM dual
270: WHERE EXISTS (SELECT 1
271: FROM msd_dem_new_items
272: WHERE sr_instance_id = p_sr_instance_id
273: AND process_flag = 2);

Line 434: select decode(p_collect_level_type, 1 , 'Locations', 2, 'Items') into v_collect_level_type from dual;

430:
431: begin
432:
433:
434: select decode(p_collect_level_type, 1 , 'Locations', 2, 'Items') into v_collect_level_type from dual;
435:
436: msd_dem_common_utilities.log_message('Collecting '|| v_collect_level_type || fnd_global.local_chr(10));
437: msd_dem_common_utilities.log_debug('Collecting '|| v_collect_level_type || fnd_global.local_chr(10));
438: