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

VIEW: APPS.PAY_ELEMENT_TYPES_D

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

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ELEMENT_TYPE_ID NUMBER (9) Yes
EFFECTIVE_START_DATE DATE
Yes
EFFECTIVE_END_DATE DATE
Yes
ELEMENT_NAME VARCHAR2 (80) Yes
PROCESSING_PRIORITY NUMBER (9) Yes
QUALIFYING_AGE NUMBER (2)

QUALIFYING_LENGTH_OF_SERVICE NUMBER (6)

QUALIFYING_UNITS VARCHAR2 (30)

REPORTING_NAME VARCHAR2 (80)

CLASSIFICATION VARCHAR2 (80) Yes
CLOSED_FOR_ENTRY VARCHAR2 (80) Yes
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY VARCHAR2 (100)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
THIRD_PARTY_PAY_ONLY_FLAG VARCHAR2 (30)

SYSTEM_ELEMENT_NAME VARCHAR2 (80) Yes
Query Text

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


SELECT ELEMENT_TYPE_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      ELEMENT_NAME
,      PROCESSING_PRIORITY
,      QUALIFYING_AGE
,      QUALIFYING_LENGTH_OF_SERVICE
,      QUALIFYING_UNITS
,      REPORTING_NAME
,      CLASSIFICATION
,      CLOSED_FOR_ENTRY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      THIRD_PARTY_PAY_ONLY_FLAG
,      SYSTEM_ELEMENT_NAME
FROM APPS.PAY_ELEMENT_TYPES_D;

Dependencies

[top of page]

APPS.PAY_ELEMENT_TYPES_D references the following:

SchemaAPPS
PL/SQL PackageFND_GLOBAL - show dependent code
ViewFND_LOOKUPS
SynonymFND_USER
SynonymPAY_ELEMENT_CLASSIFICATIONS
SynonymPAY_ELEMENT_CLASSIFICATIONS_TL
SynonymPAY_ELEMENT_TYPES_F
SynonymPAY_ELEMENT_TYPES_F_TL

APPS.PAY_ELEMENT_TYPES_D is not referenced by any database object