wanted to know the table name which stores English department names.

we are using the below SQL Query where we are Geeting the chineese department names in the table.

But we want english name of those department.

Please help us with the table name that stores the english department names.

select pd.name department_name , paaf.assignment_number 

from per_all_assignments_m paaf , per_departments pd 

where pd.organization_id(+) = paaf.organization_id

and trunc(sysdate) between trunc(paaf.effective_start_date) and trunc(paaf.effective_end_date)

and trunc(sysdate) between trunc(pd.effective_start_date(+)) and trunc(pd.effective_end_date(+))

and paaf.assignment_type = 'E'

and paaf.assignment_status_type= 'ACTIVE'