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

VIEW: APPS.GHR_ASSIGNMENTS_H_V

Object Details
Object Name: GHR_ASSIGNMENTS_H_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewGHR.GHR_ASSIGNMENTS_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)
Personnal Action Request ID of Original Action
PA_REQUEST_ID NUMBER (15)
Personnel Action Request ID
NATURE_OF_ACTION_ID NUMBER (15)
Nature of Action ID
ASSIGNMENT_ID NUMBER

Assignment ID
EFFECTIVE_START_DATE DATE

Effective Start Date
EFFECTIVE_END_DATE DATE

Effective End Date
RECRUITER_ID NUMBER

Recruiter ID
ASSIGNMENT_STATUS_TYPE_ID NUMBER

Assignment Status Type ID
PAYROLL_ID NUMBER

Payroll ID
PERSON_REFERRED_BY_ID NUMBER

Person Referred by ID
SUPERVISOR_ID NUMBER

Supervisor ID
SPECIAL_CEILING_STEP_ID NUMBER

Special ceiling Step ID
PERSON_ID NUMBER

Person ID
RECRUITMENT_ACTIVITY_ID NUMBER

Recruitment Activity ID
SOURCE_ORGANIZATION_ID NUMBER

Source Organization ID
PEOPLE_GROUP_ID NUMBER

People Group ID
SOFT_CODING_KEYFLEX_ID NUMBER

Soft Keyflex
VACANCY_ID NUMBER

Vacancy ID
PAY_BASIS_ID NUMBER

Pay Basis ID
ASSIGNMENT_SEQUENCE NUMBER

Assignment Sequence
ASSIGNMENT_TYPE VARCHAR2 (1)
Type of Assignment
PRIMARY_FLAG VARCHAR2 (30)
Primary Flag
APPLICATION_ID NUMBER

Application ID
ASSIGNMENT_NUMBER VARCHAR2 (30)
Assignment Number
CHANGE_REASON VARCHAR2 (30)
Change Reason
COMMENT_ID NUMBER

Comment ID
DATE_PROBATION_END DATE

Date Probation End
DEFAULT_CODE_COMB_ID NUMBER

Default Code Combination ID
EMPLOYMENT_CATEGORY VARCHAR2 (30)
Employment Category
FREQUENCY VARCHAR2 (30)
Frequency
INTERNAL_ADDRESS_LINE VARCHAR2 (80)
Internal Address Line
MANAGER_FLAG VARCHAR2 (30)
Manager Flag
NORMAL_HOURS NUMBER

Normal Hours
PERF_REVIEW_PERIOD NUMBER

Performance Review Period
PERF_REVIEW_PERIOD_FREQUENCY VARCHAR2 (255)
Performance Review Period Frequencey
PERIOD_OF_SERVICE_ID NUMBER

Period of Service ID
PROBATION_PERIOD NUMBER

Probation Period
PROBATION_UNIT VARCHAR2 (30)
Probation Unit
SAL_REVIEW_PERIOD NUMBER

Salary Review Period
SAL_REVIEW_PERIOD_FREQUENCY VARCHAR2 (30)
Salary Review Period Frequency
SET_OF_BOOKS_ID NUMBER

Set of Books Identifier
SOURCE_TYPE VARCHAR2 (30)
Source Type
TIME_NORMAL_FINISH VARCHAR2 (5)
Time Normal Finish
TIME_NORMAL_START VARCHAR2 (5)
Time Normal Start
TITLE VARCHAR2 (30)
Title
ORGANIZATION_ID NUMBER

Organization ID
JOB_ID NUMBER

Job ID
POSITION_ID NUMBER

Position ID
GRADE_ID NUMBER

Grade ID
LOCATION_ID NUMBER

Location ID
BUSINESS_GROUP_ID NUMBER

Business Group of the Record
REQUEST_ID NUMBER

Request ID
PROGRAM_APPLICATION_ID NUMBER

Program Application ID
PROGRAM_ID NUMBER

Program ID
PROGRAM_UPDATE_DATE DATE

Program Update Date
ASS_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Determines context of the Assignment Descriptive Flexfield in parameters.
ASS_ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield
ASS_ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield
ASS_ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield
ASS_ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield
ASS_ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield
ASS_ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield
ASS_ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield
ASS_ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield
ASS_ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield
ASS_ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield
ASS_ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield
ASS_ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield
ASS_ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield
ASS_ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield
ASS_ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield
ASS_ATTRIBUTE16 VARCHAR2 (150)
Descriptive flexfield
ASS_ATTRIBUTE17 VARCHAR2 (150)
Descriptive flexfield
ASS_ATTRIBUTE18 VARCHAR2 (150)
Descriptive flexfield
ASS_ATTRIBUTE19 VARCHAR2 (150)
Descriptive flexfield
ASS_ATTRIBUTE20 VARCHAR2 (150)
Descriptive flexfield
ASS_ATTRIBUTE21 VARCHAR2 (150)
Descriptive flexfield
ASS_ATTRIBUTE22 VARCHAR2 (150)
Descriptive flexfield
ASS_ATTRIBUTE23 VARCHAR2 (150)
Descriptive flexfield
ASS_ATTRIBUTE24 VARCHAR2 (150)
Descriptive flexfield
ASS_ATTRIBUTE25 VARCHAR2 (150)
Descriptive flexfield
ASS_ATTRIBUTE26 VARCHAR2 (150)
Descriptive flexfield
ASS_ATTRIBUTE27 VARCHAR2 (150)
Descriptive flexfield
ASS_ATTRIBUTE28 VARCHAR2 (150)
Descriptive flexfield
ASS_ATTRIBUTE29 VARCHAR2 (150)
Descriptive flexfield
ASS_ATTRIBUTE30 VARCHAR2 (150)
Descriptive 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
,      ASSIGNMENT_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      RECRUITER_ID
,      ASSIGNMENT_STATUS_TYPE_ID
,      PAYROLL_ID
,      PERSON_REFERRED_BY_ID
,      SUPERVISOR_ID
,      SPECIAL_CEILING_STEP_ID
,      PERSON_ID
,      RECRUITMENT_ACTIVITY_ID
,      SOURCE_ORGANIZATION_ID
,      PEOPLE_GROUP_ID
,      SOFT_CODING_KEYFLEX_ID
,      VACANCY_ID
,      PAY_BASIS_ID
,      ASSIGNMENT_SEQUENCE
,      ASSIGNMENT_TYPE
,      PRIMARY_FLAG
,      APPLICATION_ID
,      ASSIGNMENT_NUMBER
,      CHANGE_REASON
,      COMMENT_ID
,      DATE_PROBATION_END
,      DEFAULT_CODE_COMB_ID
,      EMPLOYMENT_CATEGORY
,      FREQUENCY
,      INTERNAL_ADDRESS_LINE
,      MANAGER_FLAG
,      NORMAL_HOURS
,      PERF_REVIEW_PERIOD
,      PERF_REVIEW_PERIOD_FREQUENCY
,      PERIOD_OF_SERVICE_ID
,      PROBATION_PERIOD
,      PROBATION_UNIT
,      SAL_REVIEW_PERIOD
,      SAL_REVIEW_PERIOD_FREQUENCY
,      SET_OF_BOOKS_ID
,      SOURCE_TYPE
,      TIME_NORMAL_FINISH
,      TIME_NORMAL_START
,      TITLE
,      ORGANIZATION_ID
,      JOB_ID
,      POSITION_ID
,      GRADE_ID
,      LOCATION_ID
,      BUSINESS_GROUP_ID
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ASS_ATTRIBUTE_CATEGORY
,      ASS_ATTRIBUTE1
,      ASS_ATTRIBUTE2
,      ASS_ATTRIBUTE3
,      ASS_ATTRIBUTE4
,      ASS_ATTRIBUTE5
,      ASS_ATTRIBUTE6
,      ASS_ATTRIBUTE7
,      ASS_ATTRIBUTE8
,      ASS_ATTRIBUTE9
,      ASS_ATTRIBUTE10
,      ASS_ATTRIBUTE11
,      ASS_ATTRIBUTE12
,      ASS_ATTRIBUTE13
,      ASS_ATTRIBUTE14
,      ASS_ATTRIBUTE15
,      ASS_ATTRIBUTE16
,      ASS_ATTRIBUTE17
,      ASS_ATTRIBUTE18
,      ASS_ATTRIBUTE19
,      ASS_ATTRIBUTE20
,      ASS_ATTRIBUTE21
,      ASS_ATTRIBUTE22
,      ASS_ATTRIBUTE23
,      ASS_ATTRIBUTE24
,      ASS_ATTRIBUTE25
,      ASS_ATTRIBUTE26
,      ASS_ATTRIBUTE27
,      ASS_ATTRIBUTE28
,      ASS_ATTRIBUTE29
,      ASS_ATTRIBUTE30
FROM APPS.GHR_ASSIGNMENTS_H_V;

Dependencies

[top of page]

APPS.GHR_ASSIGNMENTS_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_ASSIGNMENTS_H_V is referenced by following:

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