VIEW: APPS.PAY_CA_EOY_RL2_FURTHER_INFO_V

Source

View Text - Preformatted

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 = 'CAEOY RL2 FURTHER INFO' and pai_emp_ft.assignment_id = paa_arch.assignment_id and pai_emp_ft.action_information6 = 'RL2'

View Text - HTML Formatted

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 = 'CAEOY RL2 FURTHER INFO'
AND PAI_EMP_FT.ASSIGNMENT_ID = PAA_ARCH.ASSIGNMENT_ID
AND PAI_EMP_FT.ACTION_INFORMATION6 = 'RL2'