Product: | PSP - Labor Distribution |
---|---|
Description: | Shows payroll sublines that are for credit |
Implementation/DBA Data: | Not implemented in this database |
SELECT 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
, A.PAY_AMOUNT AMOUNT_LINES
, C.PAY_AMOUNT AMOUNT_SUBLINES
, B.BUSINESS_GROUP_ID
, B.SET_OF_BOOKS_ID
FROM PSP_PAYROLL_LINES A
, PSP_PAYROLL_CONTROLS B
, PSP_PAYROLL_SUB_LINES C
WHERE A.PAYROLL_CONTROL_ID = B.PAYROLL_CONTROL_ID
AND A.PAYROLL_LINE_ID = C.PAYROLL_LINE_ID
AND A.DR_CR_FLAG = 'C'