DBA Data[Home] [Help]

APPS.WSH_OTM_REF_DATA_GEN_PKG dependencies on WSH_REGIONS

Line 1168: from wsh_regions wr,

1164: l_state_code VARCHAR2(100);
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