In multi country HCM Implementations, work structures data can be stored in a COMMON set or a country specific set. In such cases, it becomes important to show the correct business unit name against the jobs in reports.
Use the below report to extract the Job and the business unit:
SELECT BU_ID ,BU_NAME ,DEFAULT_SET_ID ,SHORT_CODE ,pjft.name FROM PER_JOBS_F pjf ,PER_JOBS_F_TL pjft ,FUN_ALL_BUSINESS_UNITS_V fabuv WHERE pjf.SET_ID = fabuv.DEFAULT_SET_ID and pjf.job_id = pjft.job_id and trunc(sysdate) between pjf.effective_start_date and pjf.effective_end_date and trunc(sysdate) between pjft.effective_start_date and pjft.effective_end_date and pjft.language = 'US' order by pjft.name
To get more details on SET Name, Set assignments, you can make use of following tables: