APPS.MSD_DEM_COLLECT_PRICE_LISTS dependencies on DUAL

Line 21: from dual;

17: and language = 'US';
18:
19: cursor get_schema_name is
20: select fnd_profile.value('MSD_DEM_SCHEMA')
21: from dual;
22:
23: l_lookup_value varchar2(200);
24: l_schema_name varchar2(200);
25:

Line 334: ' (select :1, :2 from dual)';

330: /* Bug# 8224935 - APP ID */
331: l_component_id := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'COMP_DM', 1, 'dcm_product_id'));
332: l_stmt := 'insert into ' || get_lookup_value('MSD_DEM_TABLES', 'DCM_PRODUCTS_UNITS') ||
333: ' (dcm_product_id ,display_units_id) ' ||
334: ' (select :1, :2 from dual)';
335:
336: msd_dem_common_utilities.log_debug(l_stmt);
337: execute immediate l_stmt using l_component_id,new_prl.display_units_id;
338:

Line 363: ' (select :1, :2 from dual)';

359: /* Bug# 8224935 - APP ID */
360: l_component_id_sop := to_number(msd_dem_common_utilities.get_app_id_text('MSD_DEM_DEMANTRA_OBJECT_ID', 'COMP_SOP', 1, 'dcm_product_id'));
361: l_stmt := 'insert into ' || get_lookup_value('MSD_DEM_TABLES', 'DCM_PRODUCTS_UNITS') ||
362: ' (dcm_product_id ,display_units_id) ' ||
363: ' (select :1, :2 from dual)';
364:
365: msd_dem_common_utilities.log_debug(l_stmt);
366: execute immediate l_stmt using l_component_id_sop,new_prl.display_units_id;
367: --syenamar