View: PAY_ADDL_EMP_ACTION_INFO_V

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

View Text

SELECT PAI_ADDL_EMP.ACTION_CONTEXT_ID
, PAI_ADDL_EMP.ACTION_CONTEXT_TYPE
, PAI_ADDL_EMP.TAX_UNIT_ID
, PAI_ADDL_EMP.ACTION_INFORMATION_CATEGORY
, PAI_ADDL_EMP.ACTION_INFORMATION1
, PAI_ADDL_EMP.ACTION_INFORMATION2
, PAI_ADDL_EMP.ACTION_INFORMATION3
, PAI_ADDL_EMP.ACTION_INFORMATION4
, PAI_ADDL_EMP.ACTION_INFORMATION5
, PAI_ADDL_EMP.ACTION_INFORMATION6
, PAI_ADDL_EMP.ACTION_INFORMATION7
, PAI_ADDL_EMP.ACTION_INFORMATION8
, PAI_ADDL_EMP.ACTION_INFORMATION9
, PAI_ADDL_EMP.ACTION_INFORMATION10
, PAI_ADDL_EMP.ACTION_INFORMATION11
, PAI_ADDL_EMP.ACTION_INFORMATION12
, PAI_ADDL_EMP.ACTION_INFORMATION13
, PAI_ADDL_EMP.ACTION_INFORMATION14
, PAI_ADDL_EMP.ACTION_INFORMATION15
, PAI_ADDL_EMP.ACTION_INFORMATION16
, PAI_ADDL_EMP.ACTION_INFORMATION17
, PAI_ADDL_EMP.ACTION_INFORMATION18
, PAI_ADDL_EMP.ACTION_INFORMATION19
, PAI_ADDL_EMP.ACTION_INFORMATION20
FROM PAY_ACTION_INFORMATION PAI_ADDL_EMP /* AIC ---- ADDITIONAL EMPLOYEE DETAIL */
WHERE /* AIC ----ADDITIONAL EMPLOYEE DETAILS */ PAI_ADDL_EMP.ACTION_CONTEXT_TYPE = 'AAP'
AND PAI_ADDL_EMP.ACTION_INFORMATION_CATEGORY = 'ADDL EMPLOYEE DETAILS'

Columns