Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
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'
Tagged:
0