DBA Data[Home] [Help]

APPS.FTE_DIST_DWNLD_PKG dependencies on WSH_REGION_LOCATIONS

Line 2090: from wsh_region_locations wrl

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:

Line 2150: from wsh_region_locations

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