VIEW: APPS.PAY_CA_EOY_RL2_EMPLOYEE_INFO_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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