Product: | PSP - Labor Distribution |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT PS.FTE
, PS.ASSIGNMENT_ID
, PAA.ASSIGNMENT_NUMBER
, PS.PERSON_ID
, PS.SET_OF_BOOKS_ID
, GL.NAME
, PS.BUSINESS_GROUP_ID
, HOU.NAME
, PS.LAST_UPDATE_DATE
, PS.LAST_UPDATED_BY
, PS.CREATED_BY
, PS.CREATION_DATE
, PPF.EMPLOYEE_NUMBER
, PPF.FIRST_NAME
, PPF.LAST_NAME
FROM PSP_SCHEDULES PS
, PER_PEOPLE_F PPF
, PER_ALL_ASSIGNMENTS_F PAA
, GL_SETS_OF_BOOKS GL
, HR_ALL_ORGANIZATION_UNITS HOU
WHERE (PS.PERSON_ID = PPF.PERSON_ID
AND SYSDATE BETWEEN PPF.EFFECTIVE_START_DATE
AND PPF.EFFECTIVE_END_DATE)
AND (PS.ASSIGNMENT_ID = PAA.ASSIGNMENT_ID
AND SYSDATE BETWEEN PAA.EFFECTIVE_START_DATE
AND PAA.EFFECTIVE_END_DATE)
AND PS.BUSINESS_GROUP_ID=HOU.ORGANIZATION_ID
AND PS.SET_OF_BOOKS_ID = GL.SET_OF_BOOKS_ID WITH READ ONLY