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

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'