Here is the Oracle SQL Query for the Person Types.
Please use this as a reference and modify this as per the requirements.
select HL.MEANING as "System Person Type"
, PPTV.USER_PERSON_TYPE as "Assignment Person Type"
, DECODE(PPTV.ACTIVE_FLAG,'Y','Active','Inactive') as "Status"
, DECODE(PPTV.DEFAULT_FLAG,'Y','Yes','No') as "Default"
from PER_PERSON_TYPES_VL PPTV, HR_LOOKUPS HL
where 1=1
and HL.Lookup_code = PPTV.SYSTEM_PERSON_TYPE
and HL.Lookup_type = 'SYSTEM_PERSON_TYPE'
order by PPTV.SYSTEM_PERSON_TYPE
