How to find out the payment elements deductions and Earnings ?
SELECT DISTINCT PET.ELEMENT_NAME,PET.ELEMENT_TYPE_ID,PET.EFFECTIVE_START_DATE,PET.REPORTING_NAME,PEC.CLASSIFICATION_NAME
FROM PAY_ELEMENT_CLASSIFICATIONS PEC, PAY_ELEMENT_TYPES_F PET
WHERE PEC.CLASSIFICATION_ID = PET.CLASSIFICATION_ID
AND PEC.CLASSIFICATION_NAME IN ('Earnings','Tax Deductions')
ORDER BY PEC.CLASSIFICATION_NAME
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment