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

VIEW: APPS.PAY_EMP_OTHERS_ACTION_INFO_V

Object Details
Object Name: PAY_EMP_OTHERS_ACTION_INFO_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPAY.PAY_EMP_OTHERS_ACTION_INFO_V
Subobject Name:
Status: VALID

View Type

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


This view retrieves any user defined information specified in Business Group or Organization level descriptive flexfield Payslip Information.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ACTION_CONTEXT_ID NUMBER (15)
ACTION CONTEXT ID
ASSIGNMENT_ID NUMBER (10)
Assignment ID
EFFECTIVE_DATE DATE

Effective Date
INFO_TYPE VARCHAR2 (240)
info_type, (gives type ..balance/element/message)
NAME VARCHAR2 (240)
Contains balance name or element name or message
VALUE_TYPE VARCHAR2 (240)
Contains input value for element, or dimension for balance
VALUE VARCHAR2 (240)
Value
UOM VARCHAR2 (240)
Unit of Measure
ORG_INFORMATION_CNTXT VARCHAR2 (240)
Org Information Context
REPORTING_NAME VARCHAR2 (240)
Reporting Name
Query Text

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


SELECT ACTION_CONTEXT_ID
,      ASSIGNMENT_ID
,      EFFECTIVE_DATE
,      INFO_TYPE
,      NAME
,      VALUE_TYPE
,      VALUE
,      UOM
,      ORG_INFORMATION_CNTXT
,      REPORTING_NAME
FROM APPS.PAY_EMP_OTHERS_ACTION_INFO_V;

Dependencies

[top of page]

APPS.PAY_EMP_OTHERS_ACTION_INFO_V references the following:

SchemaAPPS
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
SynonymPAY_ACTION_INFORMATION
SynonymPAY_ACTION_INTERLOCKS
SynonymPAY_ASSIGNMENT_ACTIONS
SynonymPAY_INPUT_VALUES_F
SynonymPAY_PAYROLL_ACTIONS
SynonymPER_ALL_ASSIGNMENTS_F
ViewPER_ASSIGNMENTS_F

APPS.PAY_EMP_OTHERS_ACTION_INFO_V is not referenced by any database object