2086: cursor c_get_region_for_facility(cp_location_id NUMBER,
2087: cp_region_type NUMBER) IS
2088: select wrl.location_id,
2089: wrl.region_id
2090: from wsh_region_locations wrl
2091: where wrl.location_id = cp_location_id
2092: and wrl.region_type = cp_region_type;
2093:
2094:
2146: where parent_region_id = cp_region_id;
2147:
2148: cursor c_check_matching_locs(cp_region_id NUMBER) IS
2149: select location_id
2150: from wsh_region_locations
2151: where region_id = cp_region_id;
2152:
2153: cursor c_check_mile_flag(cp_location_id NUMBER) IS
2154: select include_mileage_flag