SELECT BRIDGE_NAME INTO :h_achBridgeDefBridgeName FROM LANM.BRIDGE_DEFINITIONS WHERE BRIDGE_NAME = :h_achBridgeDefBridgeName
SELECT ADDRESS1 INTO :h_achBridgeDefAdaptAddr1 FROM LANM.BRIDGE_DEFINITIONS WHERE ADDRESS1 = :h_achBridgeDefAdaptAddr1 OR ADDRESS2 = :h_achBridgeDefAdaptAddr1
SELECT ADDRESS1 INTO :h_achBridgeDefAdaptAddr2 FROM LANM.BRIDGE_DEFINITIONS WHERE ADDRESS1 = :h_achBridgeDefAdaptAddr2 OR ADDRESS2 = :h_achBridgeDefAdaptAddr2