Wednesday, December 7, 2011

Payroll - Employes Whose Pics are Missing

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