First "Approved" Position Record

Summary

SQL

Content

Hey guys.

I'm trying to extract the first approved record's effective start date of all my active positions.
I tried to use this in order to extract the first effective date but it didn't result the wanted outcome.

Can you pls let me know what i am doing wrong?

Thanks in advance for all the kind helpers.
Ben.

Code Snippet

select 
pos.position_id,
min(pos.effective_start_date) 

from HR_ALL_POSITIONS_F pos

where 
pos_app.position_code in ('NOV_BEN_TEST2','NOV_MMD_MMD_ALGOSPE1')
pos_app.hiring_status in ('APPROVED') 

group by pos_app.position_id