How to add Action check on Secure resources

Summary:

How to add Action check on Secure resources so that prevent the action whilst the same driver is assigned to another enroute_enroute shipment

We have tried the following Action check with saved query as follow but still not working:

SELECT 'Y'

FROM DUAL

WHERE not EXISTS

(SELECT SHIPMENT_GID

FROM SHIPMENT_STATUS

WHERE STATUS_TYPE_GID = 'TM.ENROUTE'

AND STATUS_VALUE_GID = 'TM.ENROUTE_ENROUTE'

AND SHIPMENT_GID in (SELECT X.SHIPMENT_GID

FROM driver_assignment X

WHERE X.DRIVER_GID = ?))

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):