View: PAY_NL_PAY_DED_ACTION_INFO_V

Product:	PAY - Payroll
Description:	View Used in Dutch Payslip Report
Implementation/DBA Data:	APPS.PAY_NL_PAY_DED_ACTION_INFO_V

View Text

SELECT PAI_1.ACTION_CONTEXT_ID ACTION_CONTEXT_ID
, PAI_1.ACTION_INFORMATION4 MAIN_SEQUENCE
, PAI_1.ACTION_INFORMATION5 SUB_SEQUENCE
, PAI_1.ACTION_INFORMATION6 DESCRIPTION
, PAI_1.ACTION_INFORMATION7 EXTRA_INFO1
, MAX(PAI_1.ACTION_INFORMATION8) EXTRA_INFO2
, PAI_1.ACTION_INFORMATION9 EXTRA_INFO3
, DECODE(MAX(PAI_1.ACTION_INFORMATION13)
, NULL
, SUM(FND_NUMBER.CANONICAL_TO_NUMBER(PAI_1.ACTION_INFORMATION10))
, MAX(FND_NUMBER.CANONICAL_TO_NUMBER(PAI_1.ACTION_INFORMATION10)) ) STANDARD_RATE
, DECODE(MAX(PAI_1.ACTION_INFORMATION13)
, NULL
, SUM(FND_NUMBER.CANONICAL_TO_NUMBER(PAI_1.ACTION_INFORMATION11))
, MAX(FND_NUMBER.CANONICAL_TO_NUMBER(PAI_1.ACTION_INFORMATION11)) ) SPECIAL_RATE
, DECODE(MAX(PAI_1.ACTION_INFORMATION13)
, NULL
, SUM(FND_NUMBER.CANONICAL_TO_NUMBER(PAI_1.ACTION_INFORMATION12))
, MAX(FND_NUMBER.CANONICAL_TO_NUMBER(PAI_1.ACTION_INFORMATION12)) ) PAYABLE
, MAX(FND_NUMBER.CANONICAL_TO_NUMBER(PAI_1.ACTION_INFORMATION13)) YEAR
FROM PAY_ACTION_INFORMATION PAI_1 /* AIC ---- NL CALCULATIONS */
WHERE /* AIC ---- NL CALCULATIONS */ PAI_1.ACTION_CONTEXT_TYPE = 'AAP'
AND PAI_1.ACTION_INFORMATION_CATEGORY = 'NL CALCULATIONS' GROUP BY PAI_1.ACTION_CONTEXT_ID
, PAI_1.ACTION_INFORMATION4
, PAI_1.ACTION_INFORMATION5
, PAI_1.ACTION_INFORMATION6
, PAI_1.ACTION_INFORMATION7
, PAI_1.ACTION_INFORMATION9
, PAI_1.EFFECTIVE_DATE

Columns