Help with Extracting L1/L2/L3 Managers in Reports

Hi, We’re working on extracting L1/L2/L3 manager hierarchy using the standard logic (e.g., PER_MANAGER_HRCHY_DN). In most cases, the extraction works fine — but in specific scenarios, some employees don’t appear at all, likely due to how the query is structured. If you’ve solved something similar, I’d really appreciate it if you could share the code/logic you're using to pull the hierarchy in your reports.
Thanks in advance!