With below sub query i'm getting error is ORA-01427: single-row subquery returns more than one row

HI Team,

when i sepeartely run the below sub query is working fine but when i run the total below query I'm getting single-row subquery returns more than one row.

how to reslove this we need Citizenship column ?

if any one help me how to add Citizenship in below query?

Thanks,

Ajay

Content (please ensure you mask any confidential information):

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

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

Select DISTINCT

papf.person_number,
ppnf.full_name as Name,
haou.Name Department_Name,
HDOR.DEI_ATTRIBUTE6 as Notes,