Product: | PSP - Labor Distribution |
---|---|
Description: | PSPBV_COSTED_PAYROLL_LINES displays information about the payroll lines imported from payroll systems. |
Implementation/DBA Data: | Not implemented in this database |
SELECT PPL.PAYROLL_LINE_ID
, PPL.BALANCE_AMOUNT
, '_LA:PPL.DR_CR_FLAG:GL_LOOKUPS:DR_CR:MEANING'
, PPL.SET_OF_BOOKS_ID
, '_LA:PPL.STATUS_CODE:PSP_LOOKUPS:PSP_STATUS_CODE:MEANING'
, PPL.EFFECTIVE_DATE
, PPL.CHECK_DATE
, PPL.EARNED_DATE
, PPL.COST_ALLOCATION_KEYFLEX_ID
, PPL.PAYROLL_CONTROL_ID
, PPL.ELEMENT_TYPE_ID
, PPL.ASSIGNMENT_ID
, '_KF:SQLGL:GL#:GCC:_CO'
, PPL.LAST_UPDATE_DATE
, PPL.LAST_UPDATED_BY
, PPL.CREATED_BY
, PPL.CREATION_DATE
FROM PSP_PAYROLL_LINES PPL
, GL_CODE_COMBINATIONS GCC
, PSP_EFFORT_REPORTS PER
, PER_ALL_PEOPLE_F PPF
WHERE PPL.GL_CODE_COMBINATION_ID=GCC.CODE_COMBINATION_ID WITH READ ONLY