SELECT LAST_NAME,EMPLOYEE_NUMBER , NATIONAL_IDENTIFIER
FROM PER_ALL_PEOPLE_F PAPF, PER_IMAGES PI
WHERE PAPF.PERSON_ID = PI.PARENT_ID(+)
AND IMAGE_ID IS NULL --AND LAST_NAME LIKE 'RUSHI%'
AND CURRENT_EMPLOYEE_FLAG = 'Y'
AND TRUNC(SYSDATE) BETWEEN PAPF.EFFECTIVE_START_DATE AND PAPF.EFFECTIVE_END_DATE
No comments:
Post a Comment