Here is one of your queries reformatted to make it more readable. I am concerned about the WHERE clause. You are using both AND and OR in the clause but you haven't explicitly defined how these are evaluated by using parens. This actually makes it harder to understand the order of evaluation without having to think about the precedence between AND and OR.

Select

a.app_key AS APP_NUMBER,

a.CREDIT_AMOUNT,

REPLACE(d.DLR_REFERENCE_NUM, '.', '') AS DEALER_NUM,

c.cts_contract_number AS APP_CONTRACT_NUMBER,

CASE co.CO_UD_APP_STATUS_TBDESC

WHEN 'PO Issued'

THEN CASE a.APP_DECISION_CODE WHEN 7

THEN 'Booked'

ELSE 'PO Issued'

END

WHEN 'Approved'

THEN CASE co.CO_LESSOR

WHEN '421'

THEN 'Approved - SFP'

WHEN '423'

THEN 'Approved - SFP'

WHEN '424'

THEN 'Approved - SFP'

ELSE 'Approved'

END

ELSE co.CO_UD_APP_STATUS_TBDESC

END AS APPLICATION_STATUS,

CONVERT(VARCHAR, co.CO_BOOKING_DATE, 101) AS BOOKING_DATE,

CONVERT(XML, a.APP_DATA, 0).value('(//CUST.NAME/node())[1]', 'VARCHAR(50)') AS CUSTOMER,

CONVERT(XML, a.APP_DATA, 0 ).value('(//DBA/node())[1]', 'VARCHAR(50)') AS CUSTOMER_DBA,

CASE WHEN LEN(CONVERT(XML, a.APP_DATA, 0 ).value('(//CUST.CREDIT.ACCT/node())[1]', 'VARCHAR(50)')) < 8

THEN CONVERT(XML, a.APP_DATA, 0).value('(//CUST.CREDIT.ACCT/node())[1]', 'VARCHAR(50)')

ELSE NULL

END AS CCAN,

CONVERT(VARCHAR, CONVERT(DATE, CONVERT(XML, a.APP_DATA, 0).value('(//UD_DATE_ENTERED/node())[1]', 'VARCHAR(10)')), 101) AS DATE_ENTERED,

CONVERT(XML, a.APP_DATA, 0 ).value('(//FED.ID/node())[1]', 'VARCHAR(50)') AS FEDERAL_ID

FROM

dbo.APPLICATION AS a

LEFT OUTER JOIN dbo.RPT_CO AS co

ON a.APP_KEY = co.APP_FKEY

LEFT OUTER JOIN dbo.DEALER AS d

ON CONVERT(XML, a.APP_DATA, 0 ).value('(//DEALER/node())[1]', 'VARCHAR(50)') = d.DLR_KEY

LEFT OUTER JOIN dbo.Contract_Setup AS c

ON a.app_key = c.cts_app_fkey

WHERE

c.CTS_LAST_SAVED_DATE > DATEADD(MINUTE,-50,GETDATE()) AND

c.CTS_LAST_SAVED_DATE < DATEADD(MINUTE,-30,GETDATE()) AND

a.APP_LAST_SAVED_DATE > DATEADD(MINUTE,-50,GETDATE()) AND

a.APP_LAST_SAVED_DATE < DATEADD(MINUTE,-30,GETDATE()) OR

a.APP_LAST_SAVED_DATE > DATEADD(MINUTE,-50,GETDATE()) AND

a.APP_LAST_SAVED_DATE < DATEADD(MINUTE,-30,GETDATE());