i have written below compute method code using Technical -> Models of a field, i want to get Value only in field x_loan_applicable_amount but its throwing error, below query contains inner or sub-query (i tested on pgAdmin but don't know how to pass parameter here due to additional sub-query):

for rec in self:

    applicable_amount = 0

    self.env.cr.execute("select sum(amount) applicable_amount from hr_payslip_input where payslip_id in (select id from hr_payslip where employee_id=%s", (rec.id)))

    self.env.cr.execute(query)

    applicable_data = self.env.cr.fetchall()

    # rec.x_loan_applicable_amount = applicable_data.applicable_amount

i already have tried to place ')' in differently but failed, always throwing error.

note: one important thing too is how to print value in odoo.log file from here? on using print() method it is showing error that print is not defiend.

please help.

regards