APPS.WSH_OTM_REF_DATA_GEN_PKG dependencies on WSH_REGION_LOCATIONS

Line 1169: wsh_region_locations wrl,

1165:
1166: cursor l_get_state_code_csr(p_location_id IN NUMBER) is
1167: select wr.state_code
1168: from wsh_regions wr,
1169: wsh_region_locations wrl,
1170: wsh_locations wl
1171: where wl.wsh_location_id = p_location_id
1172: and wl.wsh_location_id = wrl.location_id
1173: and wrl.region_type = 1