APPS.MSD_DEM_COLLECT_UOMS dependencies on DUAL

Line 19: from dual;

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

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

423: close get_component;
424:
425: l_stmt := 'insert into ' || get_lookup_value('MSD_DEM_TABLES', 'DCM_PRODUCTS_UNITS') ||
426: ' (dcm_product_id ,display_units_id) ' ||
427: ' (select :1, :2 from dual)';
428: msd_dem_common_utilities.log_debug(l_stmt);
429: execute immediate l_stmt using l_component_id,new_uom.display_units_id;
430:
431:

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

438: close get_component_sop;
439:
440: l_stmt := 'insert into ' || get_lookup_value('MSD_DEM_TABLES', 'DCM_PRODUCTS_UNITS') ||
441: ' (dcm_product_id ,display_units_id) ' ||
442: ' (select :1, :2 from dual)';
443: msd_dem_common_utilities.log_debug(l_stmt);
444: execute immediate l_stmt using l_component_id_sop,new_uom.display_units_id;
445:
446: else