View: PAY_CA_EOY_RL2_FOOTNOTE_INFO_V

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

View Text

SELECT PPA_ARCH.BUSINESS_GROUP_ID
, PPA_ARCH.PAYROLL_ACTION_ID
, PAI_EMP_FT.ACTION_CONTEXT_ID
, PAI_EMP_FT.ASSIGNMENT_ID
, PAI_EMP_FT.ACTION_INFORMATION4
, PAI_EMP_FT.ACTION_INFORMATION5
FROM PAY_ACTION_INFORMATION PAI_EMP_FT
, 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_FT.ACTION_CONTEXT_ID = PAA_ARCH.ASSIGNMENT_ACTION_ID
AND PAI_EMP_FT.ACTION_INFORMATION_CATEGORY = 'CA FOOTNOTES'
AND PAI_EMP_FT.ASSIGNMENT_ID = PAA_ARCH.ASSIGNMENT_ID
AND PAI_EMP_FT.ACTION_INFORMATION6 = 'RL2'

Columns