SQL Query to get the list of seniority date version

SELECT SeniorityDateSetUp.seniority_date_code, 
HcmLookup.MEANING,SeniorityDateSetUp.SENIORITY_VERSION 
FROM fusion.per_seniority_dates_setup SeniorityDateSetUp, 
fusion.HCM_LOOKUPS HcmLookup 
WHERE HcmLookup.lookup_code =SeniorityDateSetUp.seniority_date_code 
AND SeniorityDateSetUp.Active_flag ='Y

I hope this blog post was helpful for you. If you have any questions or feedback, please leave a comment below.

Technical Contents - SQL Query
Posted by : Mohammad
Follow on Linkedin