Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table applications as
select 123 as id, 'JOHN  ' as first_name,  'SMITH' as last_name, 'EDUCATION' as application_type, 'APPROVED' as status_type from dual union all
select 456 as id, 'JANE  ' as first_name,  'DOE' as last_name, 'EDUCATION' as application_type, 'APPROVED' as status_type from dual union all
select 789 as id, 'SARA  ' as first_name,  'JAN' as last_name, 'EDUCATION' as application_type, 'APPROVED' as status_type from dual union all
select 321 as id, 'BOB   ' as first_name,  'KAN' as last_name, 'GENERAL' as application_type, 'APPROVED' as status_type from dual union all
select 879 as id, 'OLIVER' as first_name,  'QUEEN' as last_name, 'GENERAL' as application_type, 'APPROVED' as status_type from dual 
5 rows affected

create table assignments as
select '0001' as id, 456 as application_id, 0 as inactive from dual union all
select '0002' as id, 789 as application_id, 1 as inactive from dual
2 rows affected

select a.*
from applications a left join
     assignments am
     on a.ID = am.APPLICATION_ID and am.inactive <> 1
where a.STATUS_TYPE = 'APPROVED' and
      a.APPLICATION_TYPE = 'EDUCATION' and
      am.application_id is null;


ID
FIRST_NAME
LAST_NAME
APPLICATION_TYPE
STATUS_TYPE


123
JOHN
SMITH
EDUCATION
APPROVED

789
SARA
JAN
EDUCATION
APPROVED