APPS.FTE_ACS_RULE_UTIL_PKG dependencies on WSH_LOCATIONS

Line 68: -- to use WSH_LOCATIONS_V --

64: -- time value has been passed in. --
65: -- --
66: -- 2003/01/20 I ABLUNDEL 2759845 PROCEDURE: GET_LOCATION_DATA --
67: -- replaced the two location cursors --
68: -- to use WSH_LOCATIONS_V --
69: -- --
70: -- 2003/01/21 I ABLUNDEL 2761503 PROCEDURE: PROCESS_TEMP_DATA --
71: -- PROCEDURE: GET_LOCATION_DATA --
72: -- FUNCTION: COMPARE_REGION_TYPES --

Line 607: FROM wsh_locations

603: IS
604:
605: CURSOR c_get_postal_code IS
606: SELECT postal_code
607: FROM wsh_locations
608: WHERE wsh_location_id = p_location_id;
609:
610: l_postal_code WSH_LOCATIONS.POSTAL_CODE%TYPE;
611:

Line 610: l_postal_code WSH_LOCATIONS.POSTAL_CODE%TYPE;

606: SELECT postal_code
607: FROM wsh_locations
608: WHERE wsh_location_id = p_location_id;
609:
610: l_postal_code WSH_LOCATIONS.POSTAL_CODE%TYPE;
611:
612: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
613: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.'||G_PKG_NAME||'.'||'get_postal_code';
614: