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


VIEW: APPS.HXT_PAY_ELEMENT_TYPES_F_DDF_V

Object Details
Object Name: HXT_PAY_ELEMENT_TYPES_F_DDF_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewHXT.HXT_PAY_ELEMENT_TYPES_F_DDF_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
Name Datatype Length Mandatory Comments
ELEMENT_TYPE_ID NUMBER (9) Yes
HXT_EARNING_CATEGORY VARCHAR2 (30) Yes
HXT_ABSENCE_TYPE VARCHAR2 (30)
HXT_ABSENCE_POINTS NUMBER (5)
HXT_PREMIUM_TYPE VARCHAR2 (30)
HXT_PREMIUM_AMOUNT NUMBER (15)
HXT_PROCESSING_ORDER NUMBER (3)
HXT_EXPENDITURE_TYPE VARCHAR2 (30)
EFFECTIVE_START_DATE DATE
Yes
EFFECTIVE_END_DATE DATE
Yes
EXCLUDE_FROM_EXPLOSION VARCHAR2 (30)
Query Text

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


SELECT ELEMENT_TYPE_ID
,      HXT_EARNING_CATEGORY
,      HXT_ABSENCE_TYPE
,      HXT_ABSENCE_POINTS
,      HXT_PREMIUM_TYPE
,      HXT_PREMIUM_AMOUNT
,      HXT_PROCESSING_ORDER
,      HXT_EXPENDITURE_TYPE
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      EXCLUDE_FROM_EXPLOSION
FROM APPS.HXT_PAY_ELEMENT_TYPES_F_DDF_V;

Dependencies

[top of page]

APPS.HXT_PAY_ELEMENT_TYPES_F_DDF_V references the following:

SchemaAPPS
SynonymHXT_ADD_ELEM_INFO_F
APPS.HXT_PAY_ELEMENT_TYPES_F_DDF_V is referenced by following:

SchemaAPPS
ViewHXT_DAILY_HOURS_WORKED_V
Package BodyHXT_GEN_AAI - show dependent code
ViewHXT_HDP_DET_HOURS_WORKED_V
ViewHXT_HDP_SUM_HOURS_WORKED_V
Package BodyHXT_HXT007A_XMLP_PKG - show dependent code
Package BodyHXT_HXT956A_XMLP_PKG - show dependent code
Package BodyHXT_HXT956C_XMLP_PKG - show dependent code
Package BodyHXT_HXT956D_XMLP_PKG - show dependent code
Package BodyHXT_HXT956E_XMLP_PKG - show dependent code
Package BodyHXT_HXT957A_XMLP_PKG - show dependent code
Package BodyHXT_PA_USER_EXITS - show dependent code
Package BodyHXT_RETRO_MIX - show dependent code
Package BodyHXT_RETRO_PA - show dependent code
Package BodyHXT_TC_UTIL - show dependent code
Package BodyHXT_TD_UTIL - show dependent code
Package BodyHXT_TIMECARD_API - show dependent code
PL/SQL PackageHXT_TIME_DETAIL - show dependent code
Package BodyHXT_TIME_DETAIL - show dependent code
Package BodyHXT_TIME_PAY - show dependent code
Package BodyHXT_TIME_SUMMARY - show dependent code
Package BodyHXT_TIM_COL_UTIL - show dependent code
Package BodyHXT_TRAN_PA - show dependent code
Package BodyHXT_UTIL - show dependent code