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_ADDL_EMP_ACTION_INFO_V

Object Details

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

View Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.

The view displays addition employee information that is
used in Online Payslip

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ACTION_CONTEXT_ID	NUMBER	(15)	Yes	Action Context Id
ACTION_CONTEXT_TYPE	VARCHAR2	(15)	Yes	Action Context Type
TAX_UNIT_ID	NUMBER	(15)		Tax Unit Id
ACTION_INFORMATION_CATEGORY	VARCHAR2	(80)	Yes	Action Information Category
ACTION_INFORMATION1	VARCHAR2	(240)		Action Information 1
ACTION_INFORMATION2	VARCHAR2	(240)		Action Information 2
ACTION_INFORMATION3	VARCHAR2	(240)		Action Information 3
ACTION_INFORMATION4	VARCHAR2	(240)		Action Information 4
ACTION_INFORMATION5	VARCHAR2	(240)		Action Information 5
ACTION_INFORMATION6	VARCHAR2	(240)		Action Information 6
ACTION_INFORMATION7	VARCHAR2	(240)		Action Information 7
ACTION_INFORMATION8	VARCHAR2	(240)		Action Information 8
ACTION_INFORMATION9	VARCHAR2	(240)		Action Information 9
ACTION_INFORMATION10	VARCHAR2	(240)		Action Information 10
ACTION_INFORMATION11	VARCHAR2	(240)		Action Information 11
ACTION_INFORMATION12	VARCHAR2	(240)		Action Information 12
ACTION_INFORMATION13	VARCHAR2	(240)		Action Information 13
ACTION_INFORMATION14	VARCHAR2	(240)		Action Information 14
ACTION_INFORMATION15	VARCHAR2	(240)		Action Information 15
ACTION_INFORMATION16	VARCHAR2	(240)		Action Information 16
ACTION_INFORMATION17	VARCHAR2	(240)		Action Information 17
ACTION_INFORMATION18	VARCHAR2	(240)		Action Information 18
ACTION_INFORMATION19	VARCHAR2	(240)		Action Information 19
ACTION_INFORMATION20	VARCHAR2	(240)		Action Information 20

Query Text

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


SELECT ACTION_CONTEXT_ID
,      ACTION_CONTEXT_TYPE
,      TAX_UNIT_ID
,      ACTION_INFORMATION_CATEGORY
,      ACTION_INFORMATION1
,      ACTION_INFORMATION2
,      ACTION_INFORMATION3
,      ACTION_INFORMATION4
,      ACTION_INFORMATION5
,      ACTION_INFORMATION6
,      ACTION_INFORMATION7
,      ACTION_INFORMATION8
,      ACTION_INFORMATION9
,      ACTION_INFORMATION10
,      ACTION_INFORMATION11
,      ACTION_INFORMATION12
,      ACTION_INFORMATION13
,      ACTION_INFORMATION14
,      ACTION_INFORMATION15
,      ACTION_INFORMATION16
,      ACTION_INFORMATION17
,      ACTION_INFORMATION18
,      ACTION_INFORMATION19
,      ACTION_INFORMATION20
FROM APPS.PAY_ADDL_EMP_ACTION_INFO_V;

Dependencies

[top of page]

APPS.PAY_ADDL_EMP_ACTION_INFO_V references the following:

APPS: PAY_ACTION_INFORMATION

APPS.PAY_ADDL_EMP_ACTION_INFO_V is not referenced by any database object