SQL query to retrieve a common lookup description at the employee level

Summary:

Content (please ensure you mask any confidential information):

Hello experts,

we created a custom common lookup. We need to extract at the employee level the lookup description. Do you have a sample SQL query to achieve it?

I tried the following ones but it doesn't work:

SELECT Obj.DESCRIPTION
FROM per_all_assignments_m asg, FND_LOOKUP_VALUES Obj
WHERE

AND ASG.ASSIGNMENT_TYPE IN ('C','E','T','N')
AND ASG.EMPLOYEE_CATEGORY in ('E','N','O')
AND asg.ASSIGNMENT_STATUS_TYPE IN ('ACTIVE','SUSPENDED')
AND TRUNC(SYSDATE) BETWEEN TRUNC(ASG.EFFECTIVE_START_DATE) AND TRUNC(ASG.EFFECTIVE_END_DATE)