164
164
join res_country rc on rc.id = he.country_id
165
165
where hpe.period_account_id = %s --periodo contable
166
166
and hc.code in ('%s') -- concepto de pago de nomina
169
168
group by name_employee, period_id, employee_vat
170
169
'''%(xml_doc_id,concepto_base,period_id,concepto_pago)