APPS.MSD_DEM_COLLECT_HISTORY_DATA dependencies on DUAL

Line 636: FROM dual

632:
633: CURSOR c_check_new_items
634: IS
635: SELECT 1
636: FROM dual
637: WHERE EXISTS (SELECT 1
638: FROM msd_dem_new_items
639: WHERE sr_instance_id = p_sr_instance_id
640: AND process_flag = 2);

Line 1709: utl_http.request('''||l_url||'/WorkflowServer?action=run_proc&user='||l_user_name||'&password='||l_password||'&schema=EBS%20Full%20Download&sync=no'') FROM dual';

1705: then
1706: l_url := fnd_profile.value('MSD_DEM_HOST_URL');
1707:
1708: l_sql := 'SELECT
1709: utl_http.request('''||l_url||'/WorkflowServer?action=run_proc&user='||l_user_name||'&password='||l_password||'&schema=EBS%20Full%20Download&sync=no'') FROM dual';
1710: execute immediate l_sql into l_dummy;
1711: else
1712: msd_dem_common_utilities.log_message('Error in launching the download workflow.');
1713: retcode := -1;