eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PAY_CA_EOY_RL2_TRANS_INFO_V

Source

View Text - Preformatted


SELECT ppa_arch.business_group_id, trans.action_context_id, trans.action_information2, trans.action_information8, trans.action_information3, trans.action_information4, trans.action_information5, trans.action_information6, trans.action_information7, trans.action_information10, trans.action_information11, trans.action_information12, trans.action_information13, trans.action_information14, trans.action_information15, trans.action_information16, trans.action_information9, trans.action_information17, trans.action_information18, trans.action_information19, trans.action_information20, trans.action_information21, trans.action_information22, trans.action_information23, trans.action_information24, trans.action_information25, trans.action_information26, emplr.action_information2, emplr.action_information3, emplr.action_information4, emplr.action_information5, emplr.action_information6, emplr.action_information7, emplr.action_information9, emplr.action_information8, trans.action_information27 from pay_action_information trans, pay_action_information emplr, 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 trans.action_context_id = ppa_arch.payroll_action_id and trans.action_information1 = 'RL2' and trans.action_information_category = 'CAEOY TRANSMITTER INFO' and emplr.action_context_id = ppa_arch.payroll_action_id and emplr.action_information1 = 'RL2' and emplr.action_information_category = 'CAEOY EMPLOYER INFO'

View Text - HTML Formatted

SELECT PPA_ARCH.BUSINESS_GROUP_ID
, TRANS.ACTION_CONTEXT_ID
, TRANS.ACTION_INFORMATION2
, TRANS.ACTION_INFORMATION8
, TRANS.ACTION_INFORMATION3
, TRANS.ACTION_INFORMATION4
, TRANS.ACTION_INFORMATION5
, TRANS.ACTION_INFORMATION6
, TRANS.ACTION_INFORMATION7
, TRANS.ACTION_INFORMATION10
, TRANS.ACTION_INFORMATION11
, TRANS.ACTION_INFORMATION12
, TRANS.ACTION_INFORMATION13
, TRANS.ACTION_INFORMATION14
, TRANS.ACTION_INFORMATION15
, TRANS.ACTION_INFORMATION16
, TRANS.ACTION_INFORMATION9
, TRANS.ACTION_INFORMATION17
, TRANS.ACTION_INFORMATION18
, TRANS.ACTION_INFORMATION19
, TRANS.ACTION_INFORMATION20
, TRANS.ACTION_INFORMATION21
, TRANS.ACTION_INFORMATION22
, TRANS.ACTION_INFORMATION23
, TRANS.ACTION_INFORMATION24
, TRANS.ACTION_INFORMATION25
, TRANS.ACTION_INFORMATION26
, EMPLR.ACTION_INFORMATION2
, EMPLR.ACTION_INFORMATION3
, EMPLR.ACTION_INFORMATION4
, EMPLR.ACTION_INFORMATION5
, EMPLR.ACTION_INFORMATION6
, EMPLR.ACTION_INFORMATION7
, EMPLR.ACTION_INFORMATION9
, EMPLR.ACTION_INFORMATION8
, TRANS.ACTION_INFORMATION27
FROM PAY_ACTION_INFORMATION TRANS
, PAY_ACTION_INFORMATION EMPLR
, 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 TRANS.ACTION_CONTEXT_ID = PPA_ARCH.PAYROLL_ACTION_ID
AND TRANS.ACTION_INFORMATION1 = 'RL2'
AND TRANS.ACTION_INFORMATION_CATEGORY = 'CAEOY TRANSMITTER INFO'
AND EMPLR.ACTION_CONTEXT_ID = PPA_ARCH.PAYROLL_ACTION_ID
AND EMPLR.ACTION_INFORMATION1 = 'RL2'
AND EMPLR.ACTION_INFORMATION_CATEGORY = 'CAEOY EMPLOYER INFO'