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

VIEW: APPS.GHR_PERSON_ANALYSES_H_V

Object Details
Object Name: GHR_PERSON_ANALYSES_H_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewGHR.GHR_PERSON_ANALYSES_H_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
PA_HISTORY_ID NUMBER (15) Yes Personnel Action History ID
PROCESS_DATE DATE
Yes Process Date
EFFECTIVE_DATE DATE
Yes Effective Date
DML_OPERATION VARCHAR2 (1)
DML Operation
PRE_VALUES_FLAG VARCHAR2 (1)
Pre Values Existed
ALTERED_PA_REQUEST_ID NUMBER (15)
Personnel Action ID of Original Action
PA_REQUEST_ID NUMBER (15)
Personnel Action ID
NATURE_OF_ACTION_ID NUMBER (15)
Nature of Action ID
PERSON_ANALYSIS_ID NUMBER

Person Analysis ID
BUSINESS_GROUP_ID NUMBER

Business Group of Record
ANALYSIS_CRITERIA_ID NUMBER

Analysis Criterial ID
PERSON_ID NUMBER

Person ID
COMMENTS VARCHAR2 (255)
Comments
DATE_FROM DATE

Date From
DATE_TO DATE

Date To
ID_FLEX_NUM NUMBER

ID Flex Number
REQUEST_ID NUMBER

Request ID
PROGRAM_APPLICATION_ID NUMBER

Program Application ID
PROGRAM_ID NUMBER

Program ID
PROGRAM_UPDATE_DATE DATE

Program Update Date
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Attribute Category Descriptive Flexfield Columns
ATTRIBUTE1 VARCHAR2 (15)
Descriptive Flexfield
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE16 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE17 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE18 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE19 VARCHAR2 (150)
Descriptive Flexfield
ATTRIBUTE20 VARCHAR2 (150)
Descriptive FlexfieldDescriptive FlexfieldDescriptive FlexfieldDescriptive FlexfieldDescriptive Flexfield
Query Text

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


SELECT PA_HISTORY_ID
,      PROCESS_DATE
,      EFFECTIVE_DATE
,      DML_OPERATION
,      PRE_VALUES_FLAG
,      ALTERED_PA_REQUEST_ID
,      PA_REQUEST_ID
,      NATURE_OF_ACTION_ID
,      PERSON_ANALYSIS_ID
,      BUSINESS_GROUP_ID
,      ANALYSIS_CRITERIA_ID
,      PERSON_ID
,      COMMENTS
,      DATE_FROM
,      DATE_TO
,      ID_FLEX_NUM
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
FROM APPS.GHR_PERSON_ANALYSES_H_V;

Dependencies

[top of page]

APPS.GHR_PERSON_ANALYSES_H_V references the following:

SchemaAPPS
PL/SQL PackageFND_DATE - show dependent code
PL/SQL PackageGHR_GENERAL - show dependent code
SynonymGHR_PA_HISTORY
APPS.GHR_PERSON_ANALYSES_H_V is referenced by following:

SchemaAPPS
PL/SQL PackageGHR_HISTORY_CONV_RG - show dependent code
Package BodyGHR_HISTORY_CONV_RG - show dependent code