Update record

update att_emp_attendance set aea_sts = 5 where aea_sts = 2 and emp_id in (
select EMP_ID from emp_empl_terms1 where eet_work_cs_id = 74 and eet_sts = 2
and (EET_EFF_TO is null or EET_EFF_TO > sysdate)
)