[Home] [Help] [Dependency Information]

VIEW: APPS.PSB_PAY_ELEMENTS_V

Object Details

Object Name:	PSB_PAY_ELEMENTS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PSB.PSB_PAY_ELEMENTS_V
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

Query Text

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

SELECT ROW_ID
,      PAY_ELEMENT_ID
,      BUSINESS_GROUP_ID
,      DATA_EXTRACT_ID
,      BUDGET_SET_ID
,      DATA_EXTRACT_NAME
,      NAME
,      BUDGET_SET_NAME
,      DESCRIPTION
,      ELEMENT_VALUE_TYPE
,      ELEMENT_VALUE_TYPE_MEANING
,      FORMULA_ID
,      OVERWRITE_FLAG
,      REQUIRED_FLAG
,      FOLLOW_SALARY
,      PAY_BASIS
,      START_DATE
,      END_DATE
,      PROCESSING_TYPE
,      PROCESSING_TYPE_MEANING
,      PERIOD_TYPE
,      PERIOD_TYPE_MEANING
,      PROCESS_PERIOD_TYPE
,      PROCESS_PERIOD_TYPE_MEANING
,      MAX_ELEMENT_VALUE_TYPE
,      MAX_ELEMENT_VALUE_TYPE_MEANING
,      MAX_ELEMENT_VALUE
,      SALARY_FLAG
,      SALARY_TYPE
,      SALARY_TYPE_MEANING
,      OPTION_FLAG
,      HR_ELEMENT_TYPE_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM APPS.PSB_PAY_ELEMENTS_V;

Dependencies

[top of page]

APPS

FND_GLOBAL - show dependent code

FND_LOOKUPS

PQH_PSB_DFLT_BUDGET_SETS

PSB_DATA_EXTRACTS

PSB_PAY_ELEMENTS

APPS

PSB_EXCEL_PVT - show dependent code