APPS.MSD_DEM_SR_UTIL dependencies on WSH_REGION_LOCATIONS

Line 498: ' from wsh_region_locations wrl, ' ||

494: return msd_sr_util.get_null_desc;
495: else
496:
497: l_sql_stmt := ' select wrv.zone ' ||
498: ' from wsh_region_locations wrl, ' ||
499: ' wsh_zone_regions wzr, ' ||
500: ' wsh_regions_v wrv ' ||
501: ' where wrl.location_id = ''' || p_location_id || '''' ||
502: ' and wrl.region_id = wzr.region_id ' ||

Line 531: from wsh_region_locations wrl,

527: p_zone_attr IN VARCHAR2) return number IS --jarora
528:
529: cursor c1 is
530: select wrv.region_id
531: from wsh_region_locations wrl,
532: wsh_zone_regions wzr,
533: wsh_regions_v wrv
534: where wrl.location_id = p_location_id
535: and wrl.region_id = wzr.region_id