SELECT
PAPF.PERSON_NUMBER EMPLOYEE_NUMBER,
HDRC.DEI_ATTRIBUTE1,
HDRC.DEI_ATTRIBUTE_NUMBER1,
HDRC.DEI_INFORMATION1,
HDRC.ISSUING_COUNTRY,
HDRC.ISSUING_LOCATION,
HDRC.ISSUING_AUTHORITY,
HDRC.PUBLISH_DATE,
HDRC.STATUS,
HDRC.DOCUMENT_NAME,
HDRC.DOCUMENT_NUMBER,
HDRC.DATE_FROM,
HDRC.DATE_TO
FROM
HR_DOCUMENTS_OF_RECORD HDRC,
PER_ALL_PEOPLE_F PAPF
WHERE
PAPF.PERSON_ID = HDRC.PERSON_ID
AND TRUNC(SYSDATE) BETWEEN PAPF.EFFECTIVE_START_DATE AND PAPF.EFFECTIVE_END_DATE
SQL to Fetch the Document of Records
Thinkapace Admin
- March 4, 2025
- 0 Comments
