APPS.FTE_PARCEL_LOADER dependencies on WSH_REGIONS_TL

Line 88: -- WSH_REGIONS_TL - Change Zone Name

84: --
85: -- FTE_LANES - Change Expiry_Date to new Effective_Date -1
86: -- FTE_PRC_PARAMETERS - No change
87: -- WSH_REGIONS - No change
88: -- WSH_REGIONS_TL - Change Zone Name
89: -- WSH_ZONE_REGIONS - No change
90: ----------------------------------------------------------------------------
91: PROCEDURE OBSOLETE_PREVIOUS_DATA(p_zone_name IN VARCHAR2,
92: x_status OUT NOCOPY NUMBER,

Line 177: UPDATE wsh_regions_tl t

173: WHERE lane_number like p_zone_name||'%'
174: AND editable_flag = 'N';
175:
176: -- Update Zone Name of the previously loaded Zones
177: UPDATE wsh_regions_tl t
178: SET t.zone = t.region_id||'-PARCEL'
179: WHERE t.zone like p_zone_name||'%'
180: AND t.region_id IN (SELECT region_id FROM wsh_regions
181: WHERE region_id=t.region_id AND region_type=11);