How to get the active employees using SQL Query

Solution/Workaround

We need to run the below query to get the require data

select pptv.system_person_type,pptv.user_person_type,pptv.active_flag,pptv.default_flag from per_person_types_vl pptv

I hope this blog post was helpful for you. If you have any questions or feedback, please leave a comment below.

Posted by : Mohammad