View of valid employees used with Oracle Personal Time and Expense
Implementation/DBA Data:
Not implemented in this database
View Text
SELECT HR.NAME BUSINESS_GROUP_NAME , PER.FIRST_NAME || ' ' || PER.LAST_NAME EMPLOYEE_NAME , PER.PERSON_ID , PER.EMPLOYEE_NUMBER FROM HR_ALL_ORGANIZATION_UNITS HR , PER_ALL_PEOPLE_F PER WHERE SYSDATE BETWEEN PER.EFFECTIVE_START_DATE AND PER.EFFECTIVE_END_DATE AND PER.BUSINESS_GROUP_ID = HR.BUSINESS_GROUP_ID AND HR.BUSINESS_GROUP_ID = HR.ORGANIZATION_ID AND PER.BUSINESS_GROUP_ID IN (SELECT DISTINCT BUSINESS_GROUP_ID FROM PA_IMPLEMENTATIONS_ALL)