APPS.WSH_OTM_RIQ_XML dependencies on WSH_REGION_LOCATIONS

Line 1769: FROM WSH_REGION_LOCATIONS rl ,WSH_REGIONS r

1765: CURSOR c_get_state_code(p_location_id IN NUMBER)
1766: IS
1767:
1768: SELECT r.state_code
1769: FROM WSH_REGION_LOCATIONS rl ,WSH_REGIONS r
1770: WHERE rl.location_id=p_location_id
1771: AND rl.region_type=g_state_region_type
1772: AND rl.region_id = r.region_id;
1773: /*