Product: | PSP - Labor Distribution |
---|---|
Description: | PSPFV_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
, GSB.NAME
, '_LA:PPL.STATUS_CODE:PSP_LOOKUPS:PSP_STATUS_CODE:MEANING'
, PPL.EFFECTIVE_DATE
, PPL.CHECK_DATE
, PPL.EARNED_DATE
, PPL.COST_ALLOCATION_KEYFLEX_ID
, PCA.CONCATENATED_SEGMENTS
, PPL.PAYROLL_CONTROL_ID
, PPL.ELEMENT_TYPE_ID
, PPL.ASSIGNMENT_ID
, PAA.ASSIGNMENT_NUMBER
, '_KF:SQLGL:GL#:GCC:_CO'
, PPL.LAST_UPDATE_DATE
, PPL.LAST_UPDATED_BY
, PPL.CREATED_BY
, PPL.CREATION_DATE
, PPF.EMPLOYEE_NUMBER
, PPF.FIRST_NAME
, PPF.LAST_NAME
, PET.ELEMENT_NAME
FROM PSP_PAYROLL_LINES PPL
, PER_ALL_PEOPLE_F PPF
, PAY_ELEMENT_TYPES_F PET
, GL_SETS_OF_BOOKS GSB
, PAY_COST_ALLOCATION_KEYFLEX PCA
, PER_ALL_ASSIGNMENTS_F PAA
, GL_CODE_COMBINATIONS GCC
WHERE (PPL.PERSON_ID = PPF.PERSON_ID
AND PPL.EFFECTIVE_DATE BETWEEN PPF.EFFECTIVE_START_DATE
AND PPF.EFFECTIVE_END_DATE )
AND (PPL.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND PPL.EFFECTIVE_DATE BETWEEN PET.EFFECTIVE_START_DATE
AND PET.EFFECTIVE_END_DATE )
AND PPL.SET_OF_BOOKS_ID = GSB.SET_OF_BOOKS_ID
AND (PPL.ASSIGNMENT_ID = PAA.ASSIGNMENT_ID
AND PPL.EFFECTIVE_DATE BETWEEN PAA.EFFECTIVE_START_DATE
AND PAA.EFFECTIVE_END_DATE)
AND PPL.COST_ALLOCATION_KEYFLEX_ID = PCA.COST_ALLOCATION_KEYFLEX_ID
AND PPL.GL_CODE_COMBINATION_ID=GCC.CODE_COMBINATION_ID WITH READ ONLY