APPS.MSD_DEM_COLLECT_LEVEL_TYPES dependencies on DUAL

Line 359: FROM dual

355:
356: CURSOR c_check_new_items
357: IS
358: SELECT 1
359: FROM dual
360: WHERE EXISTS (SELECT 1
361: FROM msd_dem_new_items
362: WHERE sr_instance_id = p_sr_instance_id
363: AND process_flag = 2);

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

686: msd_dem_common_utilities.log_message('NO ACTION performed related to levels assuming its SRP collections');
687: return;
688: End if ;
689:
690: select decode(p_collect_level_type, 1 , 'Locations', 2, 'Items') into v_collect_level_type from dual;
691:
692: msd_dem_common_utilities.log_message('Collecting '|| v_collect_level_type || fnd_global.local_chr(10));
693: msd_dem_common_utilities.log_debug('Collecting '|| v_collect_level_type || fnd_global.local_chr(10));
694: