Product: | PSP - Labor Distribution |
---|---|
Description: | Shows distribution lines that are for debit |
Implementation/DBA Data: | Not implemented in this database |
SELECT D.DISTRIBUTION_LINE_ID
, A.PAYROLL_LINE_ID
, A.PAYROLL_CONTROL_ID
, A.PERSON_ID
, A.ASSIGNMENT_ID
, A.ELEMENT_TYPE_ID
, B.PAYROLL_SOURCE_CODE
, B.SOURCE_TYPE
, B.TIME_PERIOD_ID
, B.BATCH_NAME
, D.DISTRIBUTION_AMOUNT AMOUNT_DISTRIBUTION
, C.PAY_AMOUNT AMOUNT_SUBLINES
, D.BUSINESS_GROUP_ID
, D.SET_OF_BOOKS_ID
FROM PSP_PAYROLL_LINES A
, PSP_PAYROLL_CONTROLS B
, PSP_PAYROLL_SUB_LINES C
, PSP_DISTRIBUTION_LINES D
WHERE A.PAYROLL_CONTROL_ID = B.PAYROLL_CONTROL_ID
AND A.PAYROLL_LINE_ID = C.PAYROLL_LINE_ID
AND C.PAYROLL_SUB_LINE_ID = D.PAYROLL_SUB_LINE_ID
AND A.DR_CR_FLAG = 'D'
AND D.STATUS_CODE = 'N'
AND (D.REVERSAL_ENTRY_FLAG = 'N' OR D.REVERSAL_ENTRY_FLAG IS NULL)