Friday, November 29, 2013

Query to find out payroll Costing Detail - How to find out payroll costed accounts - Query to find out Payroll Charged Accounts




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

No comments:

Post a Comment

Best Blogger TipsGet Flower Effect