View: PAY_CA_EOY_RL2_EMPLOYEE_INFO_V

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

View Text

SELECT PPA_ARCH.BUSINESS_GROUP_ID
, PPA_ARCH.PAYROLL_ACTION_ID
, PAI_EMP.ACTION_CONTEXT_ID
, PAI_EMP.ASSIGNMENT_ID
, PAA_ARCH.SERIAL_NUMBER
, PAI_EMP.ACTION_INFORMATION1
, PAI_EMP.ACTION_INFORMATION2
, PAI_EMP.ACTION_INFORMATION3
, PAI_EMP.ACTION_INFORMATION4
, PAI_EMP.ACTION_INFORMATION5
, PAI_EMP.ACTION_INFORMATION6
, PAI_EMP.ACTION_INFORMATION7
, PAI_EMP.ACTION_INFORMATION8
, PAI_EMP.ACTION_INFORMATION9
, PAI_EMP.ACTION_INFORMATION10
, PAI_EMP.ACTION_INFORMATION11
, PAI_EMP.ACTION_INFORMATION12
, PAI_EMP.ACTION_INFORMATION13
, PAI_EMP.ACTION_INFORMATION14
, PAI_EMP.ACTION_INFORMATION15
, PAI_EMP.ACTION_INFORMATION16
, PAI_EMP.ACTION_INFORMATION17
, PAI_EMP.ACTION_INFORMATION18
, PAI_EMP.ACTION_INFORMATION19
, PAI_EMP.ACTION_INFORMATION20
, PAI_EMP.ACTION_INFORMATION21
, PAI_EMP.ACTION_INFORMATION22
, PAI_EMP.ACTION_INFORMATION23
, PAI_EMP.ACTION_INFORMATION24
, PAI_EMP.ACTION_INFORMATION25
, PAI_EMP.ACTION_INFORMATION26
, PAI_EMP.ACTION_INFORMATION27
, PAI_EMP.ACTION_INFORMATION28
, PAI_EMP.ACTION_INFORMATION29
, PAI_EMP.ACTION_INFORMATION30
FROM PAY_ACTION_INFORMATION PAI_EMP
, PAY_ASSIGNMENT_ACTIONS PAA_ARCH
, PAY_PAYROLL_ACTIONS PPA_ARCH
WHERE PPA_ARCH.REPORT_TYPE IN ('RL2'
, 'CAEOY_RL2_AMEND_PP')
AND PPA_ARCH.REPORT_QUALIFIER IN ('CAEOYRL2'
, 'CAEOY_RL2_AMEND_PPQ')
AND PPA_ARCH.REPORT_CATEGORY = 'ARCHIVE'
AND PPA_ARCH.ACTION_TYPE = 'X'
AND PPA_ARCH.ACTION_STATUS = 'C'
AND PAA_ARCH.PAYROLL_ACTION_ID = PPA_ARCH.PAYROLL_ACTION_ID
AND PAA_ARCH.ACTION_STATUS = 'C'
AND PAI_EMP.ACTION_CONTEXT_ID = PAA_ARCH.ASSIGNMENT_ACTION_ID
AND PAI_EMP.ACTION_INFORMATION_CATEGORY = 'CAEOY RL2 EMPLOYEE INFO'
AND PAI_EMP.ASSIGNMENT_ID = PAA_ARCH.ASSIGNMENT_ID

Columns