Product: | PSP - Labor Distribution |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT PPC.PAYROLL_CONTROL_ID
, PPC.RUN_ID
, PPC.BATCH_NAME
, PPC.PAYROLL_SOURCE_CODE
, '_LA:SOURCE_TYPE:PSP_LOOKUPS:PSP_SOURCE_TYPE:MEANING'
, PPC.SET_OF_BOOKS_ID
, GL.NAME
, PPC.BUSINESS_GROUP_ID
, HOU.NAME
, PPC.NUMBER_OF_CR
, PPC.NUMBER_OF_DR
, PPC.TOTAL_DR_AMOUNT
, PPC.TOTAL_CR_AMOUNT
, PPC.SUBLINES_DR_AMOUNT
, PPC.SUBLINES_CR_AMOUNT
, PPC.DIST_DR_AMOUNT
, PPC.DIST_CR_AMOUNT
, PPC.OGM_DR_AMOUNT
, PPC.OGM_CR_AMOUNT
, PPC.GL_DR_AMOUNT
, PPC.GL_CR_AMOUNT
, PPC.STATUS_CODE
, PPC.PAYROLL_ACTION_ID
, PPC.TIME_PERIOD_ID
, PPC.PAYROLL_ID
, PPF.PAYROLL_NAME
, PTP.PERIOD_NAME
, PPA.EFFECTIVE_DATE
, PPA.DATE_EARNED
, PPA.PAY_ADVICE_DATE
, PPC.GL_PHASE
, PPC.GMS_PHASE
, PPC.ADJ_SUM_BATCH_NAME
, PPC.LAST_UPDATE_DATE
, PPC.LAST_UPDATED_BY
, PPC.CREATED_BY
, PPC.CREATION_DATE
FROM PSP_PAYROLL_CONTROLS PPC
, PAY_PAYROLLS_F PPF
, PER_TIME_PERIODS PTP
, PAY_PAYROLL_ACTIONS PPA
, HR_ALL_ORGANIZATION_UNITS HOU
, GL_SETS_OF_BOOKS GL
WHERE PPC.TIME_PERIOD_ID = PTP.TIME_PERIOD_ID
AND (PPC.PAYROLL_ID = PPF.PAYROLL_ID
AND PTP.START_DATE BETWEEN PPF.EFFECTIVE_START_DATE
AND PPF.EFFECTIVE_END_DATE)
AND PPC.PAYROLL_ACTION_ID = PPA.PAYROLL_ACTION_ID
AND PPC.BUSINESS_GROUP_ID = HOU.ORGANIZATION_ID
AND PPC.SET_OF_BOOKS_ID= GL.SET_OF_BOOKS_ID WITH READ ONLY