DBA Data[Home] [Help]

APPS.WSH_OTM_REF_DATA_GEN_PKG dependencies on WSH_REGION_LOCATIONS

Line 1130: wsh_region_locations wrl,

1126:
1127: cursor l_get_state_code_csr(p_location_id IN NUMBER) is
1128: select wr.state_code
1129: from wsh_regions wr,
1130: wsh_region_locations wrl,
1131: wsh_locations wl
1132: where wl.wsh_location_id = p_location_id
1133: and wl.wsh_location_id = wrl.location_id
1134: and wrl.region_type = 1