SELECT  
	COUNT(CASE WHEN(  A.TMS1> SYSTIMESTAMP - INTERVAL '30' MINUTE)  THEN 1  END),
	COUNT(CASE WHEN  A.LAST_UPD_TMS> SYSTIMESTAMP - INTERVAL '2' hour  AND A.TMS1<= SYSTIMESTAMP - INTERVAL '1' hour THEN  1  END),
	COUNT(CASE WHEN  A.TMS1>= SYSTIMESTAMP - INTERVAL '24' hour  AND A.TMS1<= SYSTIMESTAMP - INTERVAL '2' hour THEN  1  END),
	COUNT(CASE WHEN (  A.TMS1< SYSTIMESTAMP - INTERVAL '1' DAY)  THEN  1  END),
        COUNT(*) AS CNT 
FROM MQ A,CODE B
WHERE SUBSTR(A.PROCESS_NAME,1,4) = B.INDICATOR_TXT
	--// Pass application name
	AND B.IND_TXT = p_application_nm
	AND A.LOCATION_ID = p_loc_id;