SELECT peef.*
FROM per_all_people_f papf
,pay_element_entries_f peef
,pay_element_types_f pet
WHERE peef.element_type_id = pet.element_type_id
AND papf.person_id = peef.person_id
AND papf.person_number = 'E-12345'
AND peef.creator_type = 'BEN'
AND pet.base_element_name= 'XX_ELEMENT_NAME'
No comments:
Post a Comment