Wednesday, August 26, 2009

Oracle Apps HRMS Employee Allowances

How to find out the allowances amount of an employee

SELECT paaf.PERSON_ID,papf.FULL_NAME,paaf.PAYROLL_ID,c.NAME as allowordeduc
FROM pay_element_entry_values_f f, PAY_INPUT_VALUES_F c,
PAY_ELEMENT_LINKS_F b,PAY_LINK_INPUT_VALUES_F d,PAY_ELEMENT_ENTRIES_F A,PER_ALL_ASSIGNMENTS_F paaf,per_all_people_f papf
WHERE C.INPUT_VALUE_ID(+) = f.INPUT_VALUE_ID
--and UPPER(c.NAME) LIKE UPPER( 'Amount')
and d.ELEMENT_LINK_ID=b.ELEMENT_LINK_ID
and papf.person_id = paaf.person_id
AND d.INPUT_VALUE_ID=c.INPUT_VALUE_ID
and a.element_entry_id = F.element_entry_id
AND a.effective_start_date = F.effective_start_date
AND A.EFFECTIVE_END_DATE >= TO_DATE (sysdate,'dd-mon-RRRR')
AND a.assignment_id = paaf.assignment_id
AND b.PAYROLL_ID = 112
AND paaf.ASSIGNMENT_ID =327
AND paaf.business_group_id = 626
and b.element_link_id = a.element_link_id
AND b.effective_end_date >=SYSDATE
AND paaf.effective_end_date >=SYSDATE;

No comments:

Post a Comment