Product: | PSP - Labor Distribution |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT PES.ENC_SUMMARY_LINE_ID
, PES.BUSINESS_GROUP_ID
, PES.GMS_BATCH_NAME
, PES.TIME_PERIOD_ID
, PES.PERSON_ID
, PES.ASSIGNMENT_ID
, PES.EFFECTIVE_DATE
, PES.SET_OF_BOOKS_ID
, '_KF:SQLGL:GL#:GCC:_CO'
, PES.PROJECT_ID
, PES.EXPENDITURE_ORGANIZATION_ID
, PES.EXPENDITURE_TYPE
, PES.TASK_ID
, PES.AWARD_ID
, PES.SUMMARY_AMOUNT
, '_LA:DR_CR_FLAG:GL_LOOKUPS:DR_CR:MEANING'
, PES.GROUP_ID
, PES.INTERFACE_STATUS
, PES.PAYROLL_ID
, PES.GL_PERIOD_ID
, PES.GL_PROJECT_FLAG
, PES.REJECT_REASON_CODE
, PES.ENC_CONTROL_ID
, PES.STATUS_CODE
, PES.LAST_UPDATE_DATE
, PES.LAST_UPDATED_BY
, PES.LAST_UPDATE_LOGIN
, PES.CREATED_BY
, PES.CREATION_DATE
FROM PSP_ENC_SUMMARY_LINES PES
, GL_CODE_COMBINATIONS GCC
WHERE PES.GL_CODE_COMBINATION_ID = GCC.CODE_COMBINATION_ID WITH READ ONLY