[Home] [Help] [Dependency Information]

VIEW: APPS.PAY_CA_EOY_RL2_TRANS_INFO_V

Object Details

Object Name:	PAY_CA_EOY_RL2_TRANS_INFO_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PAY.PAY_CA_EOY_RL2_TRANS_INFO_V
Subobject Name:
Status:	VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Query Text

Cut, paste (and edit) the following text to query this object:

SELECT 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
FROM APPS.PAY_CA_EOY_RL2_TRANS_INFO_V;

Dependencies

[top of page]

APPS

PAY_ACTION_INFORMATION

PAY_PAYROLL_ACTIONS

APPS

PAY_CA_RL2_AMEND_MAG - show dependent code

PAY_CA_RL2_CAN_MAG - show dependent code

PAY_CA_RL2_MAG - show dependent code

PAY_CA_YEER_PKG - show dependent code