APPS.MSD_DEM_SR_UTIL dependencies on WSH_REGION_LOCATIONS

Line 474: ' from wsh_region_locations wrl, ' ||

470: return msd_sr_util.get_null_desc;
471: else
472:
473: l_sql_stmt := ' select wrv.zone ' ||
474: ' from wsh_region_locations wrl, ' ||
475: ' wsh_zone_regions wzr, ' ||
476: ' wsh_regions_v wrv ' ||
477: ' where wrl.location_id = ''' || p_location_id || '''' ||
478: ' and wrl.region_id = wzr.region_id ' ||

Line 507: from wsh_region_locations wrl,

503: p_zone_attr IN VARCHAR2) return number IS --jarora
504:
505: cursor c1 is
506: select wrv.region_id
507: from wsh_region_locations wrl,
508: wsh_zone_regions wzr,
509: wsh_regions_v wrv
510: where wrl.location_id = p_location_id
511: and wrl.region_id = wzr.region_id