Product: | PSP - Labor Distribution |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT PEC.ENC_CONTROL_ID
, PEC.PAYROLL_ID
, PPF.PAYROLL_NAME
, PEC.TIME_PERIOD_ID
, PTP.PERIOD_NAME
, PEC.GL_ENC_PERIOD_EXT_VALUE
, PEC.OGM_ENC_PERIOD_EXT_VALUE
, PEC.ENCUMBRANCE_DATE
, PEC.CI_SUMMARIZATION_OPTION
, PEC.TIME_SUMMARIZATION_OPTION
, PEC.NUMBER_OF_DR
, PEC.NUMBER_OF_CR
, PEC.TOTAL_DR_AMOUNT
, PEC.TOTAL_CR_AMOUNT
, PEC.GL_DR_AMOUNT
, PEC.GL_CR_AMOUNT
, PEC.OGM_DR_AMOUNT
, PEC.OGM_CR_AMOUNT
, PEC.ACTION_CODE
, PEC.RUN_ID
, PEC.BATCH_NAME
, PEC.SUMM_GL_DR_AMOUNT
, PEC.SUMM_GL_CR_AMOUNT
, PEC.SUMM_OGM_DR_AMOUNT
, PEC.SUMM_OGM_CR_AMOUNT
, PEC.BUSINESS_GROUP_ID
, HOU.NAME BUSINESS_GRP_NAME
, PEC.ACTION_TYPE
, PEC.SET_OF_BOOKS_ID
, GL.NAME SET_OF_BOOKS_NAME
, PEC.LAST_UPDATE_DATE
, PEC.LAST_UPDATED_BY
, PEC.LAST_UPDATE_LOGIN
, PEC.CREATED_BY
, PEC.CREATION_DATE
FROM PSP_ENC_CONTROLS PEC
, PAY_PAYROLLS_F PPF
, HR_ORGANIZATION_UNITS HOU
, GL_SETS_OF_BOOKS GL
, PER_TIME_PERIODS PTP
WHERE PEC.TIME_PERIOD_ID = PTP.TIME_PERIOD_ID
AND (PEC.PAYROLL_ID = PPF.PAYROLL_ID
AND PTP.START_DATE BETWEEN PPF.EFFECTIVE_START_DATE
AND PPF.EFFECTIVE_END_DATE)
AND PEC.BUSINESS_GROUP_ID = HOU.ORGANIZATION_ID
AND PEC.SET_OF_BOOKS_ID= GL.SET_OF_BOOKS_ID WITH READ ONLY