How can I pull costing on job level?

Summary:

We have an extract linking per_ext_pay_employees_ue to a costing structure UE. Costing on job level will not pull into extract. Only on payroll assignment level

Content (required):

per_ext_pay_employees_ue linked to costing structure UE based on Extract Employee Payroll Assignment ID to costing structure ue source_id. Have also linked based on job_id to source_id to test.

Filtered by 'JOB' for source_type and job_id=source_id.

Can pull the costing based on following query (but no results in extract):

select pcaa.cost_alloc_account_id , pcaf.source_id, paaf.job_id, pcaa.segment3, pcaa.segment4, pcaa.segment8