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

VIEW: APPS.PAY_APAC_PAYSLIP_ELEMENTS_V

Object Details
Object Name: PAY_APAC_PAYSLIP_ELEMENTS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPAY.PAY_APAC_PAYSLIP_ELEMENTS_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 Comments
ACTION_CONTEXT_ID NUMBER (15) Yes
ACTION_CONTEXT_TYPE VARCHAR2 (15) Yes
ELEMENT_REPORTING_NAME VARCHAR2 (240)
Developer descriptive flexfield column.
ELEMENT_CLASSIFICATION VARCHAR2 (240)
Developer descriptive flexfield column.
CURRENT_AMOUNT NUMBER

YTD_AMOUNT NUMBER

CURRENT_HOURS VARCHAR2 (240)
YTD_HOURS VARCHAR2 (240)
RATE NUMBER

FX_RATE NUMBER

Developer descriptive flexfield column.
FX_AMOUNT NUMBER

Developer descriptive flexfield column.
FX_CURRENCY VARCHAR2 (240)
Developer descriptive flexfield column.
START_DATE DATE

Developer descriptive flexfield column.
END_DATE DATE

Developer descriptive flexfield column.
Query Text

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


SELECT ACTION_CONTEXT_ID
,      ACTION_CONTEXT_TYPE
,      ELEMENT_REPORTING_NAME
,      ELEMENT_CLASSIFICATION
,      CURRENT_AMOUNT
,      YTD_AMOUNT
,      CURRENT_HOURS
,      YTD_HOURS
,      RATE
,      FX_RATE
,      FX_AMOUNT
,      FX_CURRENCY
,      START_DATE
,      END_DATE
FROM APPS.PAY_APAC_PAYSLIP_ELEMENTS_V;

Dependencies

[top of page]

APPS.PAY_APAC_PAYSLIP_ELEMENTS_V references the following:

SchemaAPPS
PL/SQL PackageFND_DATE - show dependent code
PL/SQL PackageFND_NUMBER - show dependent code
SynonymPAY_ACTION_INFORMATION
APPS.PAY_APAC_PAYSLIP_ELEMENTS_V is referenced by following:

SchemaAPPS
Package BodyPAY_IN_SOE - show dependent code