Announcements for Payroll and OTL can now be found in the Announcements - Payroll and OTL - EBS (MOSC) subcategory. Follow to be sure you don't miss a thing!
list employee by element
Dear All,
im trying to implement a query to get the data in this screen but im not sure where these values are stored
my query:
select PET.ELEMENT_NAME ,PEE.effective_start_date , PEE.effective_end_date
FROM
PAY_ELEMENT_LINKS_F PEL,
PAY_ELEMENT_ENTRIES_F PEE,
pay_element_types_f PET,
PER_ASSIGNMENTS_F PAF,
PER_PEOPLE_F PPF
where PEE.ELEMENT_LINK_ID = PEL.ELEMENT_LINK_ID
and PEE.element_type_id = PET.element_type_id
and paf.assignment_id = pee.assignment_id
and ppf.person_id = paf.person_id(+)
and ppf.person_type_id in ( 132,137)
1