SELECT C.GREGORIAN_MONTH_ID
,C.BUSINESS_PARTY_ID
,C.TOTAL_MONTO
,C.Capitas_Puntuales
,C.CUIT
,nb_apellido
,nb_oficial_actual
,nb_cne_obe
,nb_nodo
,nb_territorio
,cd_area_negocio

FROM (SELECT gregorian_month_id
                ,business_party_id
                ,Case when BUSINESS_PARTY_ID in (88888,200) then '9999999999999' else business_party_ident_num end CUIT
                ,SUM(amt_accum) Total_Monto
                ,count(*) Capitas_Puntuales

                FROM  dbsreg.A127932_PARTY_MAIN_PAYROLL_HISTORY
                where gregorian_month_id= 201806
                group by 1,2,3
                ) C

LEFT JOIN
    (select NU_CUIT, nb_apellido,nb_oficial_actual, nb_cne_obe, nb_nodo, nb_territorio,cd_area_negocio
    ,(fh_corte/100 + 190000) gregorian_month_id
    from dbsreg.a119527_base_info_gerencial
    ) G

on C.CUIT = G.NU_CUIT
and  (case
         when C.gregorian_month_id  in (G.gregorian_month_id) then C.gregorian_month_id
         else C.gregorian_month_id -1
        END) = G.gregorian_month_id
ORDER BY C.BUSINESS_PARTY_ID