eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.PER_GEN_HIERARCHY_NODES1_DFV

Object Details

Object Name:	PER_GEN_HIERARCHY_NODES1_DFV
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length
ROW_ID	ROWID	(10)
CONTEXT_VALUE	VARCHAR2	(30)
TO_STEP_ID	VARCHAR2	(150)
FROM_CORPS_ID	VARCHAR2	(150)
FROM_SENIORITY	VARCHAR2	(150)
FROM_SENIORITY_UOM	VARCHAR2	(150)
TO_SENIORITY	VARCHAR2	(150)
TO_SENIORITY_UOM	VARCHAR2	(150)
TO_CORPS_ID	VARCHAR2	(150)
SENIORITY_TYPE	VARCHAR2	(150)
LOS_YEARS	NUMBER
LOS_MONTHS	NUMBER
LOS_DAYS	NUMBER
REM_CORPS_LOS_YEARS	NUMBER
REM_CORPS_LOS_MONTHS	NUMBER
REM_CORPS_LOS_DAYS	NUMBER
REM_GRADE_LOS_YEARS	NUMBER
REM_GRADE_LOS_MONTHS	NUMBER
REM_GRADE_LOS_DAYS	NUMBER
REM_STEP_LOS_YEARS	NUMBER
REM_STEP_LOS_MONTHS	NUMBER
REM_STEP_LOS_DAYS	NUMBER
GRADE_LADDER_ID	VARCHAR2	(150)
TO_GRADE_ID	NUMBER
COMMENTS	VARCHAR2	(150)
UNIT_PERCENTAGE	NUMBER
STATISTICAL_INDICATOR	VARCHAR2	(150)
ADDITIONAL_AMOUNT_FIRST_CHILD	NUMBER
ADDITIONAL_AMOUNT_FURTH_CHILD	NUMBER
AMOUNT_IF_SINGLE	NUMBER
AMOUNT_IF_MARRIED	NUMBER
AMOUNT_IF_MARRIED_AND_A_CHILD	NUMBER
ADDITIONAL_AMOUNT__THIRD_FURTH	NUMBER
CONCATENATED_SEGMENTS	VARCHAR2	(3352)

Query Text

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


SELECT ROW_ID
,      CONTEXT_VALUE
,      TO_STEP_ID
,      FROM_CORPS_ID
,      FROM_SENIORITY
,      FROM_SENIORITY_UOM
,      TO_SENIORITY
,      TO_SENIORITY_UOM
,      TO_CORPS_ID
,      SENIORITY_TYPE
,      LOS_YEARS
,      LOS_MONTHS
,      LOS_DAYS
,      REM_CORPS_LOS_YEARS
,      REM_CORPS_LOS_MONTHS
,      REM_CORPS_LOS_DAYS
,      REM_GRADE_LOS_YEARS
,      REM_GRADE_LOS_MONTHS
,      REM_GRADE_LOS_DAYS
,      REM_STEP_LOS_YEARS
,      REM_STEP_LOS_MONTHS
,      REM_STEP_LOS_DAYS
,      GRADE_LADDER_ID
,      TO_GRADE_ID
,      COMMENTS
,      UNIT_PERCENTAGE
,      STATISTICAL_INDICATOR
,      ADDITIONAL_AMOUNT_FIRST_CHILD
,      ADDITIONAL_AMOUNT_FURTH_CHILD
,      AMOUNT_IF_SINGLE
,      AMOUNT_IF_MARRIED
,      AMOUNT_IF_MARRIED_AND_A_CHILD
,      ADDITIONAL_AMOUNT__THIRD_FURTH
,      CONCATENATED_SEGMENTS
FROM APPS.PER_GEN_HIERARCHY_NODES1_DFV;

Dependencies

[top of page]

APPS.PER_GEN_HIERARCHY_NODES1_DFV references the following:

APPS: FND_NUMBER - show dependent code; PER_GEN_HIERARCHY_NODES

APPS.PER_GEN_HIERARCHY_NODES1_DFV is not referenced by any database object