Query to find out payroll Costing Detail / ”How to find out payroll costed accounts” / “Query to find out Payroll Charged Accounts”.

Oracle HR and Payroll Related Queries

*********************

SELECT distinct d.EMPLOYEE_NUMBER,d.FULL_NAME,a.CONCATENATED_SEGMENTS, a.element_name,decode(a.debit_or_credit,’Debit’,COSTED_VALUE,”) Debit  ,
decode(debit_or_credit,’Credit’,COSTED_VALUE,”) Credit
FROM  pay_costs_v a, pay_assignment_actions_v b,per_assignments_x c,per_people_x d
where     d.EMPLOYEE_NUMBER= nvl(:p_emp_no,d.EMPLOYEE_NUMBER)
and   trunc (b.EFFECTIVE_DATE)  between :p_from_date and :p_to_date
and a.ASSIGNMENT_ACTION_ID=b.ASSIGNMENT_ACTION_ID
and  b.ASSIGNMENT_ID=c.ASSIGNMENT_ID
and c.PERSON_ID=d.PERSON_ID

 **********************