Query to fetch Union Code on Employment page

 Hi All,

I was trying to pull the union code from employment page for an employee. There is a union_id column in per_all_assignments_m. This needs to be joined with organization_id from hr_organization_units_f_tl and pull the name from this table for union code.

select name from fusion.hr_organization_units_f_tl where organization_id=<PER_ALL_ASSIGNMENTS_M.UNION_ID> and language='US' and trunc(sysdate) between effective_start_date and effective_end_date