SELECT pesid.final_amount FROM proll_employee_salary_summary pess 
inner join proll_employee_salary_summary_detail pessd on pessd.employee_salary_summary_id=pess.id
INNER JOIN proll_employee_salary_info_detail pesid ON pesid.salary_summary_detail_id=pessd.id
INNER JOIN cb_payroll_headers cph ON cph.payroll_headers_id=pesid.allowance_type_header_id
WHERE cph.header_key='car_allow' AND pess.emp_id='{id}' limit 1;
