SELECT FNPP.LAST_NAME EMPLOYEE_LAST_NAME,
PAPF.PERSON_NUMBER EMPLOYEE_NUMBER,
FNPP.FIRST_NAME EMPLOYEE_FIRST_NAME,
PRMG.IMAGE_NAME
FROM PER_IMAGES PRMG,
PER_ALL_PEOPLE_F PAPF,
PER_PERSON_NAMES_F FNPP
WHERE 1 = 1
AND PRMG.PERSON_ID =FNPP.PERSON_ID
AND PAPF.PERSON_ID= FNPP.PERSON_ID
AND PRMG.PRIMARY_FLAG = 'Y'
AND FNPP.NAME_TYPE = 'GLOBAL'
AND TRUNC(SYSDATE) BETWEEN PAPF.EFFECTIVE_START_DATE AND PAPF.EFFECTIVE_END_DATE
AND TRUNC(SYSDATE) BETWEEN FNPP.EFFECTIVE_START_DATE AND FNPP.EFFECTIVE_END_DATE
