View: PAY_AC_EMP_SUM_ACTION_INFO_V

Product:	PAY - Payroll
Description:
Implementation/DBA Data:	APPS.PAY_AC_EMP_SUM_ACTION_INFO_V

View Text

SELECT PAI.ACTION_CONTEXT_ID ACTION_CONTEXT_ID
, PAI.ACTION_INFORMATION_CATEGORY ACTION_INFORMATION_CATEGORY
, PAI.ACTION_INFORMATION14 ROW_LABEL
, NVL(SUM(FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION4))
, 0) EARNINGS
, NVL(SUM(FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION5))
, 0) SUPPLEMENTAL_EARNINGS
, NVL(SUM(FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION6))
, 0) IMPUTED_EARNINGS
, NVL(SUM(FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION7))
, 0) PRETAX_DEDUCTIONS
, SUM(FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION8)) INVOLUNTARY_DEDUCTIONS
, SUM(FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION9)) VOLUNTARY_DEDUCTIONS
, NVL(SUM(FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION10))
, 0) TAXES
, SUM(FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION13)) NON_PAYROLL_PAYMENTS
, NVL(SUM(FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION11))
, 0) TAXABLE_BENEFITS
, DECODE(PAY_US_EMPLOYEE_PAYSLIP_WEB.GET_LEGISLATION_CODE(PAF.BUSINESS_GROUP_ID)
, 'CA'
, ( NVL(SUM(FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION7))
, 0) + NVL(SUM(FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION8))
, 0) + NVL(SUM(FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION9))
, 0) )
, ( NVL(SUM(FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION8))
, 0) + NVL(SUM(FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION9))
, 0) ) ) AFTER_TAX_DEDUCTIONS
, ( NVL(SUM(FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION4))
, 0) + NVL(SUM(FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION5))
, 0) + NVL(SUM(FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION6))
, 0) + NVL(SUM(FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION11))
, 0) + NVL(SUM(FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION12))
, 0)) GROSS_EARNINGS
, ( NVL(SUM(FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION4))
, 0) + NVL(SUM(FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION12))
, 0) + NVL(SUM(FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION5))
, 0)) GROSS_PAY
, (GREATEST( ( NVL(SUM(FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION4))
, 0) + NVL(SUM(FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION5))
, 0) - NVL(SUM(FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION7))
, 0) - NVL(SUM(FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION8))
, 0) - NVL(SUM(FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION9))
, 0) - NVL(SUM(FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION10))
, 0) + NVL(SUM(FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION12))
, 0) + NVL(SUM(FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION13))
, 0))
, 0)) NET_PAY
, ( NVL(SUM(FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION7))
, 0) + NVL(SUM(FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION8))
, 0) + NVL(SUM(FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION9))
, 0) ) CA_TOTAL_DEDUCTIONS
FROM PAY_ACTION_INFORMATION PAI
, PER_ASSIGNMENTS_F PAF
WHERE PAI.ACTION_INFORMATION_CATEGORY IN ('AC SUMMARY CURRENT'
, 'AC SUMMARY YTD')
AND PAF.ASSIGNMENT_ID = PAI.ASSIGNMENT_ID
AND PAI.EFFECTIVE_DATE BETWEEN PAF.EFFECTIVE_START_DATE
AND PAF.EFFECTIVE_END_DATE GROUP BY PAI.ACTION_CONTEXT_ID
, PAI.ACTION_INFORMATION_CATEGORY
, PAI.ACTION_INFORMATION14
, PAF.BUSINESS_GROUP_ID

Columns