APPS.MSD_WS_DEM_RENAME_FORECAST dependencies on FND_PROFILE

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

560:
561: BEGIN
562:
563: EXECUTE IMMEDIATE ' SELECT supply_plan_id '
564: || ' FROM ' || fnd_profile.value('MSD_DEM_SCHEMA') || '.supply_plan sp'
565: || ' WHERE sp.plan_id = ' || PlanId
566: INTO x_member_id;
567:
568: RETURN x_member_id;

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

590:
591: BEGIN
592:
593: /* Alter session to APPS */
594: x_schema := apps.fnd_profile.VALUE('MSD_DEM_SCHEMA');
595: x_small_sql := 'alter session set current_schema = APPS';
596: EXECUTE IMMEDIATE x_small_sql;
597:
598: /*Refresh the mview */

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

626: x_drop_mview_sql VARCHAR2(300) := NULL;
627:
628: BEGIN
629:
630: x_schema := apps.fnd_profile.VALUE('MSD_DEM_SCHEMA');
631:
632: /*Check if the Materialized view exists*/
633: SELECT object_name into x_mview
634: FROM dba_objects