Product: | PSB - Public Sector Budgeting |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PSB_POSITION_ASSIGN_EMP_V |
SELECT PAS.ROWID
, PAS.POSITION_ASSIGNMENT_ID
, PAS.DATA_EXTRACT_ID
, PAS.WORKSHEET_ID
, PAS.POSITION_ID
, PAS.EMPLOYEE_ID
, PE.EMPLOYEE_NUMBER
, PE.FULL_NAME
, PAS.PRIMARY_EMPLOYEE_FLAG
, PAS.EFFECTIVE_START_DATE
, PAS.EFFECTIVE_END_DATE
, PAS.LAST_UPDATE_DATE
, PAS.LAST_UPDATED_BY
, PAS.LAST_UPDATE_LOGIN
, PAS.CREATED_BY
, PAS.CREATION_DATE
FROM PSB_POSITION_ASSIGNMENTS PAS
, PSB_EMPLOYEES PE
WHERE PAS.EMPLOYEE_ID = PE.EMPLOYEE_ID
AND PAS.ASSIGNMENT_TYPE = 'EMPLOYEE'