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_T4A_REG_V

Object Details

Object Name:	PAY_CA_EOY_T4A_REG_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PAY.PAY_CA_EOY_T4A_REG_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)
EMPLOYEE_NUMBER	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
T4A_BOX16	VARCHAR2	(4000)
T4A_BOX18	VARCHAR2	(4000)
T4A_BOX20	VARCHAR2	(4000)
T4A_BOX22	VARCHAR2	(4000)
T4A_BOX24	VARCHAR2	(4000)
T4A_BOX26	VARCHAR2	(4000)
T4A_BOX27	VARCHAR2	(4000)
T4A_BOX28	VARCHAR2	(4000)
T4A_BOX30	VARCHAR2	(4000)
T4A_BOX32	VARCHAR2	(4000)
T4A_BOX34	VARCHAR2	(4000)
T4A_BOX36	VARCHAR2	(4000)
T4A_BOX38	VARCHAR2	(4000)
T4A_BOX40	VARCHAR2	(4000)
T4A_BOX42	VARCHAR2	(4000)
T4A_BOX46	VARCHAR2	(4000)

Query Text

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


SELECT SIN
,      EMPLOYEE_NUMBER
,      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
,      T4A_BOX16
,      T4A_BOX18
,      T4A_BOX20
,      T4A_BOX22
,      T4A_BOX24
,      T4A_BOX26
,      T4A_BOX27
,      T4A_BOX28
,      T4A_BOX30
,      T4A_BOX32
,      T4A_BOX34
,      T4A_BOX36
,      T4A_BOX38
,      T4A_BOX40
,      T4A_BOX42
,      T4A_BOX46
FROM APPS.PAY_CA_EOY_T4A_REG_V;

Dependencies

[top of page]

APPS.PAY_CA_EOY_T4A_REG_V references the following:

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

APPS.PAY_CA_EOY_T4A_REG_V is not referenced by any database object