What's new in Customer Journeys?

Connect and learn more! ×
How to fetch Cost Center Details which are mapped at Department Level — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to fetch Cost Center Details which are mapped at Department Level

Received Response
1997
Views
4
Comments
edited Nov 5, 2019 4:19AM in Reporting and Analytics for HCM 4 comments

Content

Hi Team,

In our organisation we mapped Cost Center at Department level. How to fetch those cost center details.

If anyone have SQL query please help me.

I tried with below query but i am not getting correct cost center. i didn't find any joins with department table.

SELECT PAPF.PERSON_NUMBER,
        PCAA.*
 
 
FROM  PAY_COST_ALLOC_ACCOUNTS PCAA,
      HR_ALL_ORGANIZATION_UNITS_F HROU,
  PER_ALL_PEOPLE_F PAPF,
  PER_ALL_ASSIGNMENTS_M PAAM,
  PAY_COST_ALLOCATIONS_F PCA,     
      PAY_PAYROLL_ASSIGNMENTS PPA,
      PAY_PAY_RELATIONSHIPS_DN PPRD
 
 
WHERE  PAPF.PERSON_ID=PAAM.PERSON_ID
AND    PAAM.ASSIGNMENT_TYPE= 'E'

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!