SELECT
BLE.BLE_CODPRO AS codigoPacote,
BLE.BLE_CODPAD AS tabelaPacote,
ISNULL(BTU.BTU_CODTAB, BTQ.BTQ_CODTAB) AS TabelaProcedimento,
ISNULL(BTU.BTU_CDTERM, BTQ.BTQ_CDTERM) AS codigoProcedimento
FROM BLE010 BLE
LEFT JOIN BTU010 BTU ON (BTU.BTU_VLRBUS = BLE_CODOPC AND BTU.D_E_L_E_T_ = ' ')
LEFT JOIN BTQ010 BTQ ON (BTQ.BTQ_CDTERM = BLE_CODOPC AND BTQ.D_E_L_E_T_ = ' ')
WHERE BLE.D_E_L_E_T_ = ' '
AND (BTQ_CODTAB IS NULL OR BTQ_CODTAB IN ('18', '19', '20', '22', '90', '98'))
AND (BTU_CODTAB IS NULL OR BTU_CODTAB IN ('18', '19', '20', '22', '90', '98'))
AND ((BTU_CODTAB IS NOT NULL AND BTU_CDTERM IS NOT NULL) OR (BTQ_CODTAB IS NOT NULL AND BTQ_CDTERM IS NOT NULL))
AND BLE.S_T_A_M_P_ > (DATEADD(HOUR, -1, GETUTCDATE()))