sql to fetch costing of payroll

Summary:

Need help to pull costing of payroll. Using BIP report trying to pull cost account details but not able to achieve.

Content (please ensure you mask any confidential information):

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

Need help to pull costing of payroll. Using BIP report trying to pull cost account details but not able to achieve.

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

WITH c AS (
SELECT
pp.payroll_name,
pcak.segment1,
pcak.segment2,
pcak.segment3,
pcak.segment4,
pcak.segment5,
pcak.segment6,
pcak.CONCATENATED_SEGMENTS,
-- pcak.cost_allocation_keyflex_id,