[Home] [Help]
View: PSPBV_LABOR_DIST_ASSIGNMENTS
Product: | PSP - Labor Distribution |
Description: | PSPBV_LABOR_DIST_ASSIGNMENTS displays assignment identifiers from Oracle Human Resources that have schedules in Labor Distribution. |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT PS.FTE
, PS.ASSIGNMENT_ID
, PS.PERSON_ID
, PS.SET_OF_BOOKS_ID
, PS.BUSINESS_GROUP_ID
, PS.LAST_UPDATE_DATE
, PS.LAST_UPDATED_BY
, PS.CREATED_BY
, PS.CREATION_DATE
FROM PSP_SCHEDULES PS
, PER_ALL_ASSIGNMENTS_F PAA
WHERE PS.ASSIGNMENT_ID=PAA.ASSIGNMENT_ID
AND ( SYSDATE BETWEEN PAA.EFFECTIVE_START_DATE
AND PAA.EFFECTIVE_END_DATE) WITH READ ONLY
Columns
Name |
FULL_TIME_EQUIVALENT |
ASSIGNMENT_ID |
PERSON_ID |
SET_OF_BOOKS_ID |
BUSINESS_GROUP_ID |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATED_BY |
CREATION_DATE |