SELECT PER.PERSON_ID ID , PER.FULL_NAME VALUE , PER.EFFECTIVE_START_DATE DATE_FROM , PER.EFFECTIVE_END_DATE DATE_FROM , PER.BUSINESS_GROUP_ID BUSINESS_GROUP_ID , PER.CURRENT_EMPLOYEE_FLAG CURRENT_EMPLOYEE_FLAG , PER.CURRENT_APPLICANT_FLAG CURRENT_APPLICANT_FLAG , PER.CURRENT_EMP_OR_APL_FLAG CURRENT_EMP_OR_APL_FLAG FROM PER_PEOPLE_X PER , FND_USER USR WHERE USR.EMPLOYEE_ID = PER.PERSON_ID AND USR.USER_ID = FND_GLOBAL.USER_ID AND PER.CURRENT_EMPLOYEE_FLAG = 'Y' WITH READ ONLY
[Home] [Help]