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.

[Home] [Help]

View: PAY_CA_EOY_RL2_TRANS_INFO_V

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

View Text

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 = 'RL2'
AND PPA_ARCH.REPORT_QUALIFIER = 'CAEOYRL2'
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'

Columns

Name
BUSINESS_GROUP_ID
PAYROLL_ACTION_ID
QUEBEC_BUSINESS_NUMBER
REPORTING_YEAR
TRANSMITTER_NUMBER
TRANSMITTER_DATA_TYPE
TRANSMITTER_PACKAGE_TYPE
TRANSMITTER_TYPE_INDICATOR
SOURCE_OF_SLIPS
TRANSMITTER_NAME
TRANSMITTER_ADDRESS_LINE1
TRANSMITTER_ADDRESS_LINE2
TRANSMITTER_ADDRESS_LINE3
TRANSMITTER_CITY
TRANSMITTER_PROVINCE
TRANSMITTER_POSTAL_CODE
TRANSMITTER_COUNTRY
TRANSMITTER_TECH_CONTACT_NAME
TRANSMITTER_TECH_CONTACT_CODE
TRANSMITTER_TECH_CONTACT_PHONE
TRANSMITTER_TECH_CONTACT_EXTN
TRANSMITTER_TECH_CONTACT_LANG
TRANSMITTER_ACCT_CONTACT_NAME
TRANSMITTER_ACCT_CONTACT_CODE
TRANSMITTER_ACCT_CONTACT_PHONE
TRANSMITTER_ACCT_CONTACT_EXTN
TRANSMITTER_ACCT_CONTACT_LANG
EMPLOYER_NAME
EMPLOYER_ADD_LINE1
EMPLOYER_ADD_LINE2
EMPLOYER_ADD_LINE3
EMPLOYER_CITY
EMPLOYER_PROVINCE
EMPLOYER_POSTAL_CODE
EMPLOYER_COUNTRY
PRE_ORG_ID