create view vm_not_matched_employee_leave_condition
as
select k.id from tenant_employees k where k.id in (
    select t1.ITEM_SECURITYID from tms.tlk_qualify_person_apply t1 where t1.ITEM_APPLYSTATUS='0'
    union
    select t2.ITEM_securityId from tms.tlk_grade_registration t2 where t2.ITEM_applyStatus='0'
)