Table to query Collective Agreement Union Name

Summary:

Content (please ensure you mask any confidential information):

Hi All,

I need to fetch Union Name under Collective Agreements in Assignment Page in my report. I understand that we can get UNION_ID from PER_ALL_ASSIGNMENTS_M table. However, I need to fetch the Union Name only. Has anyone worked on this before?

Thanks in advance,

Pooja

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

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