with CL as (...)
select CLIENT_ID
, L.LAST as LAST_LOG
, P.LAST as LAST_PAYMENT
, S.LAST as LAST_STATUS
, C.LAST as LAST_CHARGE
from CL
left join (
select CL.CLIENT_ID, max(L.MOMENT) as LAST
from CL join BM_ACTION_LOG L on (L.CUSTOMER_ID = CL.CLIENT_ID and L.MOMENT >= CL.MOMENT and L.ACTION_ID < 1000)
group by CL.CLIENT_ID
) L using (CLIENT_ID)
...
where coalesce(L.LAST, P.LAST, S.LAST, C.LAST) is not null

select CLIENT_ID
, case when exists (select * from BM_ACTION_LOG where CUSTOMER_ID = CL.CLIENT_ID and MOMENT >= CL.MOMENT and ACTION_ID < 1000) then 1 end FLAG_LOG
, case when exists (select * from BM_PAYMENT where CUSTOMER_ID = CL.CLIENT_ID and INPUT_MOMENT >= CL.MOMENT) then 1 end FLAG_PAYMENT
, case when exists (select * from SERVICES where CUSTOMER_ID = CL.CLIENT_ID and STATUS_DATE >= CL.MOMENT) then 1 end FLAG_STATUS
, case when exists (select * from SERVICES join BM_SERVICE_MONEY using (SERVICE_ID) where CUSTOMER_ID = CL.CLIENT_ID and MOMENT >= CL.MOMENT and MONEY != 0) then 1 end FLAG_CHARGE
from (...) CL