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 442: ' (select :1, :2 from dual)';

438: 1,
439: 'dcm_product_id'));
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,new_uom.display_units_id;
445:
446:

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

458: 1,
459: 'dcm_product_id'));
460: l_stmt := 'insert into ' || get_lookup_value('MSD_DEM_TABLES', 'DCM_PRODUCTS_UNITS') ||
461: ' (dcm_product_id ,display_units_id) ' ||
462: ' (select :1, :2 from dual)';
463: msd_dem_common_utilities.log_debug(l_stmt);
464: execute immediate l_stmt using l_component_id_sop,new_uom.display_units_id;
465: -- syenamar
466: