Not able to pull the external posting career site name of a job requisition.

We are trying to pull the external posting career site name of a job requisition. But the site_id in the IRC_PUBLISHED_JOBS table is not getting matched with the site_id in IRC_CX_SITES_B table. Is there a way to pull the external career site of a job requisition?

Using the following sql to pull the site name.

SELECT
irv.REQUISITION_NUMBER,
irv.TITLE AS REQUISITION_TITLE,
cs_tl.SITE_NAME AS CAREER_SITE_NAME

FROM
IRC_REQUISITIONS_VL irv
LEFT OUTER JOIN
IRC_PUBLISHED_JOBS pj ON irv.REQUISITION_ID = pj.REQUISITION_ID
LEFT OUTER JOIN