Query to get the List of Job name and job codes

SELECT PJFT.NAME, PJF.JOB_CODE

FROM PER_JOBS_F_TL PJFT , PER_JOBS_F PJF

WHERE PJFT.LANGUAGE = 'US'

AND TRUNC(SYSDATE) BETWEEN PJFT.EFFECTIVE_START_DATE AND PJFT.EFFECTIVE_END_DATE

AND PJFT.JOB_ID = PJF.JOB_ID

AND TRUNC(SYSDATE) BETWEEN PJF.EFFECTIVE_START_DATE AND PJF.EFFECTIVE_END_DATE

ORDER BY PJFT.NAME, PJF.JOB_CODE

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

Posted by : Mohammad