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.GHR_MASS_AWARDS_PREVIEW_V

Object Details

Object Name:	GHR_MASS_AWARDS_PREVIEW_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	GHR.GHR_MASS_AWARDS_PREVIEW_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
MASS_AWARD_ID	NUMBER	(15)		Mass Award ID
PA_REQUEST_ID	NUMBER	(15)	Yes	Personnel Action request ID
PERSON_ID	NUMBER	(10)		Person ID
EFFECTIVE_DATE	DATE			Effective Date
SELECT_FLAG	VARCHAR2	(1)		Select Flag
EMPLOYEE_LAST_NAME	VARCHAR2	(150)		Employee Last Name
EMPLOYEE_FIRST_NAME	VARCHAR2	(150)		Employee First Name
EMPLOYEE_MIDDLE_NAMES	VARCHAR2	(60)		Employee Middle Names
EMPLOYEE_NATIONAL_IDENTIFIER	VARCHAR2	(30)		Employee National Identifier
AWARD_AMOUNT	NUMBER	(15)		Award Amount
AWARD_UOM	VARCHAR2	(30)		Award Unit of Measure
AWARD_PERCENTAGE	NUMBER	(5)		Award Percentage
AWARD_AGENCY_CODE	VARCHAR2	(150)		Award Agency Code
AWARD_TYPE	VARCHAR2	(150)		Award type
GROUP_AWARD_ID	VARCHAR2	(150)		Group Award ID
TANGIBLE_BENEFIT_DOLLARS	VARCHAR2	(150)		Tangible Benefit Dollars
DATE_AWARD_EARNED	VARCHAR2	(150)		Date Award Earned
BASIC_PAY	NUMBER	(15)		Basic Pay
ORGANIZATION_ID	NUMBER	(15)		Organization ID
DUTY_STATION_CODE	VARCHAR2	(9)		Duty Station Code
DUTY_STATION_DESC	VARCHAR2	(150)		Duty Station Description
AGENCY_CODE	VARCHAR2	(30)		Agency Code
AGENCY_CODE_DESC	VARCHAR2	(80)		Agency Code Description
POI	VARCHAR2	(4)		Personnel Office ID
POSITION_OCCUPIED	VARCHAR2	(30)		Position Occupied
POSITION_TITLE	VARCHAR2	(240)		Position Title
PAY_PLAN	VARCHAR2	(2)		Pay Plan
GRADE_OR_LEVEL	VARCHAR2	(30)		Grade or Level
OCC_CODE	VARCHAR2	(150)		Occ. Code
OFFICE_SYMBOL	VARCHAR2	(30)		Office Symbol
COMMENTS	VARCHAR2	(255)		Comments
AWARD_SALARY	NUMBER	(15)

Query Text

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


SELECT MASS_AWARD_ID
,      PA_REQUEST_ID
,      PERSON_ID
,      EFFECTIVE_DATE
,      SELECT_FLAG
,      EMPLOYEE_LAST_NAME
,      EMPLOYEE_FIRST_NAME
,      EMPLOYEE_MIDDLE_NAMES
,      EMPLOYEE_NATIONAL_IDENTIFIER
,      AWARD_AMOUNT
,      AWARD_UOM
,      AWARD_PERCENTAGE
,      AWARD_AGENCY_CODE
,      AWARD_TYPE
,      GROUP_AWARD_ID
,      TANGIBLE_BENEFIT_DOLLARS
,      DATE_AWARD_EARNED
,      BASIC_PAY
,      ORGANIZATION_ID
,      DUTY_STATION_CODE
,      DUTY_STATION_DESC
,      AGENCY_CODE
,      AGENCY_CODE_DESC
,      POI
,      POSITION_OCCUPIED
,      POSITION_TITLE
,      PAY_PLAN
,      GRADE_OR_LEVEL
,      OCC_CODE
,      OFFICE_SYMBOL
,      COMMENTS
,      AWARD_SALARY
FROM APPS.GHR_MASS_AWARDS_PREVIEW_V;

Dependencies

[top of page]

APPS.GHR_MASS_AWARDS_PREVIEW_V references the following:

APPS: GHR_PA_REQUESTS; GHR_PA_REQUEST_EXTRA_INFO

APPS.GHR_MASS_AWARDS_PREVIEW_V is not referenced by any database object