APPS.MSD_DEM_SR_UTIL dependencies on WSH_ZONE_REGIONS

Line 499: ' wsh_zone_regions wzr, ' ||

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 ' ||
503: ' and wzr.parent_region_id = wrv.region_id ' ||

Line 532: wsh_zone_regions wzr,

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
536: and wzr.parent_region_id = wrv.region_id