Query to extract Job Family Information

Below query can be used to extract loaded Job Families information.

 select  PJFF.JOB_FAMILY_CODE,
    pjfft.JOB_FAMILY_NAME,
    pjff.ACTIVE_STATUS STATUS,
    to_char(pjff.effective_start_date,'YYYY/MM/DD') effective_start_date,
            to_char(pjff.effective_end_date,'YYYY/MM/DD') effective_end_date,
            hrc.source_system_id,
            hrc.source_system_owner,
            hrc.object_name
from hrc_integration_key_map hrc,
         PER_JOB_FAMILY_F  pjff,
         PER_JOB_FAMILY_F_TL pjfft
where hrc.object_name like 'JobFamily'
     and pjff.job_family_id = hrc.surrogate_id
     and pjff.job_family_id = pjfft.job_family_id