select transaction_id, auth_code
from authorize_gateway_result_log
where txn_attempted_type='AUTH_ONLY'
and response_code='1'
and transaction_id=:transaction_id
select version_name
from apm_package_versions
where enabled_p = 't'
and package_key = 'authorize-gateway'
select instance_name
from apm_packages p, apm_package_versions v
where p.package_key = v.package_key
and v.enabled_p = 't'
and p.package_key = 'authorize-gateway'