APPS.MSD_WS_DEM_RENAME_FORECAST dependencies on FND_PROFILE

Line 306: || ' FROM ' || fnd_profile.value('MSD_DEM_SCHEMA') || '.supply_plan sp'

302:
303: BEGIN
304:
305: EXECUTE IMMEDIATE ' SELECT supply_plan_id '
306: || ' FROM ' || fnd_profile.value('MSD_DEM_SCHEMA') || '.supply_plan sp'
307: || ' WHERE sp.plan_id = ' || PlanId
308: INTO x_member_id;
309:
310: RETURN x_member_id;

Line 336: x_schema := apps.fnd_profile.VALUE('MSD_DEM_SCHEMA');

332:
333: BEGIN
334:
335: /* Alter session to APPS */
336: x_schema := apps.fnd_profile.VALUE('MSD_DEM_SCHEMA');
337: x_small_sql := 'alter session set current_schema = APPS';
338: EXECUTE IMMEDIATE x_small_sql;
339:
340: /*Refresh the mview */

Line 372: x_schema := apps.fnd_profile.VALUE('MSD_DEM_SCHEMA');

368: x_drop_mview_sql VARCHAR2(300) := NULL;
369:
370: BEGIN
371:
372: x_schema := apps.fnd_profile.VALUE('MSD_DEM_SCHEMA');
373:
374: /*Check if the Materialized view exists*/
375: SELECT object_name into x_mview
376: FROM dba_objects