[Home] [Help]
| Product: | PSP - Labor Distribution |
|---|---|
| Description: | |
| Implementation/DBA Data: | Not implemented in this database |
SELECT PEE.ENC_ELEMENT_ID
, PEE.BUSINESS_GROUP_ID
, HOU.NAME BUSINESS_GRP_NAME
, PEE.SET_OF_BOOKS_ID
, GL.NAME SET_OF_BOOKS_NAME
, PEE.ELEMENT_TYPE_CATEGORY
, PEE.ELEMENT_TYPE_ID
, PET.ELEMENT_NAME ELEMENT_TYPE_NAME
, PEE.LAST_UPDATE_DATE
, PEE.LAST_UPDATED_BY
, PEE.LAST_UPDATE_LOGIN
, PEE.CREATED_BY
, PEE.CREATION_DATE
FROM PSP_ENC_ELEMENTS PEE
, GL_SETS_OF_BOOKS GL
, HR_ALL_ORGANIZATION_UNITS HOU
, PAY_ELEMENT_TYPES_F PET
WHERE PEE.SET_OF_BOOKS_ID=GL.SET_OF_BOOKS_ID
AND PEE.BUSINESS_GROUP_ID=HOU.ORGANIZATION_ID
AND PEE.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID WITH READ ONLY