[Home] [Help]
1407: OPEN x_location FOR
1408: SELECT address1
1409: , wsh_location_id
1410: , ui_location_code
1411: FROM wsh_locations
1412: WHERE (inactive_date IS NULL OR inactive_date > Sysdate)
1413: AND address1 LIKE (p_location_code)
1414: ORDER BY Upper (address1);
1415: