APPS.WSH_REGIONS_SEARCH_PKG dependencies on WSH_ZONE_REGIONS

Line 2502: wsh_zone_regions z

2498: null,
2499: 'N'
2500: FROM wsh_regions r,
2501: wsh_regions_tl rt,
2502: wsh_zone_regions z
2503: WHERE r.region_id = z.parent_region_id AND
2504: z.region_id = l_region_id AND
2505: r.region_type = 10 AND
2506: rt.region_id = r.region_id AND

Line 3117: FROM wsh_zone_regions wzr,wsh_regions wr

3113: x_return_status OUT NOCOPY VARCHAR2) IS
3114:
3115: CURSOR c_get_zone_for_region(c_region_id IN NUMBER) IS
3116: SELECT wr.region_id
3117: FROM wsh_zone_regions wzr,wsh_regions wr
3118: WHERE wzr.region_id = c_region_id
3119: AND zone_flag = 'Y'
3120: AND wzr.parent_region_id = wr.region_id
3121: AND wr.region_type=10;

Line 3275: FROM wsh_zone_regions wzr,wsh_regions wr

3271: SELECT wr.region_id,
3272: --null,
3273: wr.region_type,
3274: wr.deconsol_location_id
3275: FROM wsh_zone_regions wzr,wsh_regions wr
3276: WHERE wzr.region_id = c_region_id
3277: AND zone_flag = 'Y'
3278: AND wzr.parent_region_id = wr.region_id
3279: AND wr.region_type=10