Query show for the payment elements relationships
select pes.ELEMENT_SET_NAME,petf.ELEMENT_NAME,petf.DESCRIPTION
from HR.PAY_ELEMENT_SETS pes ,HR.PAY_ELEMENT_TYPE_RULES petr,HR.PAY_ELEMENT_TYPES_F petf
where pes.ELEMENT_SET_ID = petr.ELEMENT_SET_ID
and petf.ELEMENT_TYPE_ID = petr.ELEMENT_TYPE_ID
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment