How to fetch 'Y' for Managers having direct reportee and 'N' for Managers not h'ing direct reports

Summary:

Sql to get 'Y' for the Managers having direct reportee and 'N' for the Managers not having direct reportees in oracle fusion hcm. Please suggest.

Content (required):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):