Tables to get Competencies details

Summary:

Hi Everyone,

I'm working on writing query to get competencies related details.
In Model Profiles under job profiles we have Competencies, Technical & Professional Skills related details.
I've come across following tables while going through multiple CCC discussion
PER_ALL_PEOPLE_F
PER_ALL_ASSIGNMENTS_F
PER_PERSON_NAMES_F
PER_LEGAL_EMPLOYERS
PER_DEPARTMENTS
PER_GRADES_F
PER_GRADES_F_TL
PER_JOBS_F
PER_JOBS_F_TL
PER_JOB_FAMILY_F_VL
HR_ALL_POSITIONS
HRT_PROFILE_RELATIONS
HRT_PROFILES_VL
HRT_PROFILE_ITEMS
HRT_CONTENT_TYPES_VL
HRT_CONTENT_ITEMS_VL
HRT_RATING_MODELS_VL
HRT_RATING_LEVELS_VL