View: PAY_EMP_ACCRUALS_ACTION_INFO_V

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

View Text

SELECT PAI.ACTION_CONTEXT_ID
, PAI.TAX_UNIT_ID
, PAI.EFFECTIVE_DATE
, PAI.ACTION_INFORMATION4 ACCRUAL_TYPE
, PAI.ACTION_INFORMATION7 ACCRUAL_CODE
, SUM(FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION5)) CURRENT_AMOUNT
, SUM(FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION6)) NET_AMOUNT
FROM PAY_ACTION_INFORMATION PAI
, PER_ASSIGNMENTS_F PAF
WHERE PAI.ACTION_CONTEXT_TYPE = 'AAP'
AND PAI.ACTION_INFORMATION_CATEGORY = 'EMPLOYEE ACCRUALS'
AND PAF.ASSIGNMENT_ID = PAI.ASSIGNMENT_ID
AND PAI.EFFECTIVE_DATE BETWEEN PAF.EFFECTIVE_START_DATE
AND PAF.EFFECTIVE_END_DATE GROUP BY PAF.BUSINESS_GROUP_ID
, PAI.ACTION_CONTEXT_ID
, PAI.TAX_UNIT_ID
, PAI.EFFECTIVE_DATE
, PAI.ACTION_INFORMATION4
, PAI.ACTION_INFORMATION7

Columns