[Home] [Help]
View: PSP_ORIG_LINE_DETAILS_V
View Text
SELECT PTOL.RUN_ID
, PTOL.ACCT_GROUP_ID
, PSP_GENERAL.GET_ELEMENT_NAME(PTOL.ELEMENT_TYPE_ID
, TRUNC(SYSDATE)) ELEMENT_NAME
, PPX.PAYROLL_NAME
, PTP.PERIOD_NAME
, PPS.SOURCE_CODE SOURCE_TYPE
, SUM(DECODE(PTOL.DR_CR_FLAG
, 'D'
, PTOL.DISTRIBUTION_AMOUNT
, (-1 * PTOL.DISTRIBUTION_AMOUNT))) AMOUNT
FROM PSP_TEMP_ORIG_LINES PTOL
, PAY_PAYROLLS_X PPX
, PER_TIME_PERIODS PTP
, PSP_PAYROLL_CONTROLS PPC
, PSP_PAYROLL_SOURCES PPS WHERE PPX.PAYROLL_ID = PTP.PAYROLL_ID
AND PTP.TIME_PERIOD_ID = PTOL.TIME_PERIOD_ID
AND PPC.PAYROLL_CONTROL_ID = PTOL.PAYROLL_CONTROL_ID
AND PPC.SOURCE_TYPE = PPS.SOURCE_TYPE
AND PPC.PAYROLL_SOURCE_CODE = PPS.SOURCE_CODE GROUP BY PTOL.RUN_ID
, PTOL.ACCT_GROUP_ID
, PSP_GENERAL.GET_ELEMENT_NAME(PTOL.ELEMENT_TYPE_ID
, TRUNC(SYSDATE))
, PPX.PAYROLL_NAME
, PTP.PERIOD_NAME
, PPS.SOURCE_CODE
Columns
Name |
RUN_ID |
ACCT_GROUP_ID |
ELEMENT_NAME |
PAYROLL_NAME |
PERIOD_NAME |
SOURCE_TYPE |
AMOUNT |