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.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.PAY_CA_EOY_REGISTER_V

Object Details

Object Name:	PAY_CA_EOY_REGISTER_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PAY.PAY_CA_EOY_REGISTER_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

Name	Datatype	Length	Mandatory
SIN	VARCHAR2	(4000)
CPP_QPP_EXEMPT	VARCHAR2	(4000)
EI_EXEMPT	VARCHAR2	(4000)
EMPLOYMENT_CODE	VARCHAR2	(4000)
RPP_DPSP_REG_NO	VARCHAR2	(4000)
EMPLOYEE_SURNAME	VARCHAR2	(4000)
EMPLOYEE_FIRST_NAME	VARCHAR2	(4000)
EMPLOYEE_INITIAL	VARCHAR2	(4000)
EMP_ADDRESS_LINE1	VARCHAR2	(4000)
EMP_ADDRESS_LINE2	VARCHAR2	(4000)
EMP_ADDRESS_LINE3	VARCHAR2	(4000)
EMP_CITY	VARCHAR2	(4000)
EMP_PROVINCE	VARCHAR2	(4000)
EMP_COUNTRY	VARCHAR2	(4000)
EMP_POSTAL_CODE	VARCHAR2	(4000)
ORGANIZATION_ID	VARCHAR2	(4000)
LOCATION_ID	VARCHAR2	(4000)
PERSON_ID	VARCHAR2	(4000)
BUSINESS_GROUP_ID	NUMBER	(15)	Yes
TAX_UNIT_ID	NUMBER	(15)
PAYROLL_ACTION_ID	NUMBER	(9)	Yes
ASSIGNMENT_ACTION_ID	NUMBER	(15)	Yes
CONTEXT	VARCHAR2	(30)	Yes
EMPLOYMENT_INCOME	VARCHAR2	(4000)
INCOME_TAX_DEDUCTED	VARCHAR2	(4000)
EMPLOYEES_CPP	VARCHAR2	(4000)
EMPLOYEES_QPP	VARCHAR2	(4000)
EMPLOYEES_EI	VARCHAR2	(4000)
RPP_CONTRIBUTION	VARCHAR2	(4000)
PENSION_ADJUSTMENT	VARCHAR2	(4000)
EI_INSURABLE_EARNINGS	VARCHAR2	(4000)
CPP_EARNINGS	VARCHAR2	(4000)
QPP_EARNINGS	VARCHAR2	(4000)
UNION_DUES	VARCHAR2	(4000)
CHARITABLE_DONATIONS	VARCHAR2	(4000)
T4_OTHER_INFO_AMT_30	VARCHAR2	(4000)
T4_OTHER_INFO_AMT_31	VARCHAR2	(4000)
T4_OTHER_INFO_AMT_32	VARCHAR2	(4000)
T4_OTHER_INFO_AMT_33	VARCHAR2	(4000)
T4_OTHER_INFO_AMT_34	VARCHAR2	(4000)
T4_OTHER_INFO_AMT_35	VARCHAR2	(4000)
T4_OTHER_INFO_AMT_36	VARCHAR2	(4000)
T4_OTHER_INFO_AMT_37	VARCHAR2	(4000)
T4_OTHER_INFO_AMT_38	VARCHAR2	(4000)
T4_OTHER_INFO_AMT_39	VARCHAR2	(4000)
T4_OTHER_INFO_AMT_40	VARCHAR2	(4000)
T4_OTHER_INFO_AMT_41	VARCHAR2	(4000)
T4_OTHER_INFO_AMT_42	VARCHAR2	(4000)
T4_OTHER_INFO_AMT_70	VARCHAR2	(4000)
T4_OTHER_INFO_AMT_71	VARCHAR2	(4000)
T4_OTHER_INFO_AMT_72	VARCHAR2	(4000)
T4_OTHER_INFO_AMT_73	VARCHAR2	(4000)
T4_OTHER_INFO_AMT_74	VARCHAR2	(4000)
T4_OTHER_INFO_AMT_75	VARCHAR2	(4000)
T4_OTHER_INFO_AMT_76	VARCHAR2	(4000)

Query Text

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


SELECT SIN
,      CPP_QPP_EXEMPT
,      EI_EXEMPT
,      EMPLOYMENT_CODE
,      RPP_DPSP_REG_NO
,      EMPLOYEE_SURNAME
,      EMPLOYEE_FIRST_NAME
,      EMPLOYEE_INITIAL
,      EMP_ADDRESS_LINE1
,      EMP_ADDRESS_LINE2
,      EMP_ADDRESS_LINE3
,      EMP_CITY
,      EMP_PROVINCE
,      EMP_COUNTRY
,      EMP_POSTAL_CODE
,      ORGANIZATION_ID
,      LOCATION_ID
,      PERSON_ID
,      BUSINESS_GROUP_ID
,      TAX_UNIT_ID
,      PAYROLL_ACTION_ID
,      ASSIGNMENT_ACTION_ID
,      CONTEXT
,      EMPLOYMENT_INCOME
,      INCOME_TAX_DEDUCTED
,      EMPLOYEES_CPP
,      EMPLOYEES_QPP
,      EMPLOYEES_EI
,      RPP_CONTRIBUTION
,      PENSION_ADJUSTMENT
,      EI_INSURABLE_EARNINGS
,      CPP_EARNINGS
,      QPP_EARNINGS
,      UNION_DUES
,      CHARITABLE_DONATIONS
,      T4_OTHER_INFO_AMT_30
,      T4_OTHER_INFO_AMT_31
,      T4_OTHER_INFO_AMT_32
,      T4_OTHER_INFO_AMT_33
,      T4_OTHER_INFO_AMT_34
,      T4_OTHER_INFO_AMT_35
,      T4_OTHER_INFO_AMT_36
,      T4_OTHER_INFO_AMT_37
,      T4_OTHER_INFO_AMT_38
,      T4_OTHER_INFO_AMT_39
,      T4_OTHER_INFO_AMT_40
,      T4_OTHER_INFO_AMT_41
,      T4_OTHER_INFO_AMT_42
,      T4_OTHER_INFO_AMT_70
,      T4_OTHER_INFO_AMT_71
,      T4_OTHER_INFO_AMT_72
,      T4_OTHER_INFO_AMT_73
,      T4_OTHER_INFO_AMT_74
,      T4_OTHER_INFO_AMT_75
,      T4_OTHER_INFO_AMT_76
FROM APPS.PAY_CA_EOY_REGISTER_V;

Dependencies

[top of page]

APPS.PAY_CA_EOY_REGISTER_V references the following:

APPS: FF_ARCHIVE_ITEMS; FF_ARCHIVE_ITEM_CONTEXTS; FF_CONTEXTS; PAY_ASSIGNMENT_ACTIONS; PAY_CA_ARCHIVE_UTILS - show dependent code; PAY_PAYROLL_ACTIONS

APPS.PAY_CA_EOY_REGISTER_V is referenced by following:

PUBLIC: PAY_CA_EOY_REGISTER_V