APPS.MSD_WS_DEM_RENAME_FORECAST dependencies on MSD_DEM_TRANSFER_QUERY

Line 60: || ' FROM msd_dem_transfer_query tq '

56:
57:
58: /* Check if the Data Profile Name specified is present inside Demantra or not */
59: x_sql_stmt := 'SELECT nvl(sum(tq.id), 0) '
60: || ' FROM msd_dem_transfer_query tq '
61: || ' WHERE tq.query_name = ''' || x_data_profile_name || ''''
62: || ' AND msd_dem_upload_forecast.is_valid_scenario(tq.id) = 1 ';
63: EXECUTE IMMEDIATE x_sql_stmt INTO x_data_profile_id;
64:

Line 160: msd_dem_transfer_query tq,

156: FND_GLOBAL.USER_ID,
157: sysdate,
158: FND_GLOBAL.USER_ID
159: FROM
160: msd_dem_transfer_query tq,
161: msd_dem_transfer_query_levels tql,
162: msd_dem_group_tables gt,
163: fnd_lookup_values_vl flv
164: WHERE

Line 161: msd_dem_transfer_query_levels tql,

157: sysdate,
158: FND_GLOBAL.USER_ID
159: FROM
160: msd_dem_transfer_query tq,
161: msd_dem_transfer_query_levels tql,
162: msd_dem_group_tables gt,
163: fnd_lookup_values_vl flv
164: WHERE
165: tq.id = x_data_profile_id