This content has been marked as final. Show 4 replies
Can you be more specific on what exactly do you need? Do you need cost codes defined at Assignment, Org, Payroll, Element Link, Element entry definition? or are you looking for the details post you have run the Costing process?
For more details please refer one of my article on the this link: http://www.apps2fusion.com/at/38-ss/194-costing-in-oracle-hrms-payroll
Edited by: Sanjay Singh on Mar 7, 2013 3:34 AM
try the following (assignment costing as at today):
from per_assignments_x pax
where ppx.person_id = pax.person_id
and pax.assignment_id = pcax.assignment_id
and pcak.cost_allocation_keyflex_id = pcax.cost_allocation_keyflex_id
i ran your query i did not get any data, i need cost codes defined at Payroll.
can you pls help me on this.
Try this one
SELECt PPF.PAYROLL_ID, PPF.PAYROLL_NAME,pca.concatenated_segments
FROM PAY_PAYROLLS_F PPF, PAY_COST_ALLOCATION_KEYFLEX PCA
where pca.cost_allocation_keyflex_id = ppf.cost_allocation_keyflex_id;