I need a subquery that returns whether the manager filled out an assessment of the employees' goals

I need a subquery that returns whether the manager filled out an assessment of the employees' goals - from which tables can this be retrieved? In Oracle HCM

Explanation - After the employees have met goals and objectives during the year, the manager gives a score for each goal, and I need to check if he really fulfilled a score for all the goals