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_MT_ELEMENT_ENTRIES_V

Object Details

Object Name:	GHR_MT_ELEMENT_ENTRIES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	GHR.GHR_MT_ELEMENT_ENTRIES_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
GHR_INTERFACE_ID	NUMBER	(15)	Yes	GHR Interface ID
MT_PROCESS_DATE	DATE		Yes	Process Date
MT_SOURCE	VARCHAR2	(30)		Source
MT_EFFECTIVE_DATE	DATE			Effective Date
MT_NAME	VARCHAR2	(255)		Mass Action Criteria name
MT_STATUS	VARCHAR2	(255)		Status
MT_PERSON_ID	VARCHAR2	(255)		Person ID
MT_TABLE_NAME	VARCHAR2	(255)		Table Name
MT_INFORMATION_TYPE	VARCHAR2	(255)		Information Type
MT_INTER_BG_TRANSFER	VARCHAR2	(255)		Internal Business Group Transfer
TOTAL_SALARY	VARCHAR2	(255)		Total Salary
SALARY	VARCHAR2	(255)		Salary
LOCALITY_ADJUSTMENT	VARCHAR2	(255)		Locality Adjustment
ADJUSTED_PAY	VARCHAR2	(255)		Adjusted Pay
OTHER_PAY	VARCHAR2	(255)		Other Pay
FEGLI	VARCHAR2	(255)		FEGLI
ELIGIBILITY_EXPIRATION	VARCHAR2	(255)		Eligibility Expiration
RETIREMENT_PLAN	VARCHAR2	(255)		Retirement Plan
RETENTION_ALLOWANCE	VARCHAR2	(255)		Retention Allowance
STAFFING_DIFFERENTIAL	VARCHAR2	(255)		Staffing Differential (now not used)
SUPERVISORY_DIFFERENTIAL	VARCHAR2	(255)		Supervisory Differential
ENROLLMENT	VARCHAR2	(255)		Enrollment
HEALTH_PLAN	VARCHAR2	(255)		Health Plan
TEMPS_TOTAL_COST	VARCHAR2	(255)		Temps Total Cost
TSP_AMOUNT	VARCHAR2	(255)		Thrift Savings Plan Amount
TSP_RATE	VARCHAR2	(255)		TSP Rate
TSP_G_FUND	VARCHAR2	(255)		TSP G-Fund
TSP_F_FUND	VARCHAR2	(255)		TSP F-Fund
TSP_C_FUND	VARCHAR2	(255)		TSP C-Fund
TSP_STATUS	VARCHAR2	(255)		TSP Status
TSP_STATUS_DATE	VARCHAR2	(255)		TSP Status Date
TSP_ELIGIBILITY_DATE	VARCHAR2	(255)		TSP Eligibility Date
WGI_STATUS	VARCHAR2	(255)		Within Grade Increase (WGI) - Status
WGI_DATE_DUE	VARCHAR2	(255)		WGI Due Date
WGI_PAY_DATE	VARCHAR2	(255)		WGI Pay Date
WGI_LAST_INCREASE_DATE	VARCHAR2	(255)		WGI Last Increase Date
WGI_POSTPONMT_EFFECTIVE	VARCHAR2	(255)		WGI Postponnment Effective Date
WGI_POSTPONMT_DETERM_DUE	VARCHAR2	(255)		WGI Postponement Determination Due
FEGLI_MEANING	VARCHAR2	(255)		FEGLI Meaning
RETIREMENT_PLAN_MEANING	VARCHAR2	(255)		Retirement Plan Meaning
AUO_AMOUNT	VARCHAR2	(255)		AUO Amount
AUO_PREMIUM_PAY_IND	VARCHAR2	(255)		AUO Premium Pay Indicator
AP_AMOUNT	VARCHAR2	(255)		AP Amount
AP_PREMIUM_PAY_IND	VARCHAR2	(255)		AP Premium Pay Indicator
TO_RETENTION_ALLOW_PERCENTAGE	VARCHAR2	(255)		Retention Allowance Percentage
TO_SUPERVISORY_DIFF_PERCENTAGE	VARCHAR2	(255)		Supervisory Differential Percentage
TO_STAFFING_DIFF_PERCENTAGE	VARCHAR2	(255)		Staffing Differential Percentage
TO_BASIC_SALARY_RATE	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
TO_ADJUSTED_BASIC_PAY	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.
TO_TOTAL_SALARY	VARCHAR2	(255)		Developer defined column based on SOURCE_NAME.

Query Text

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


SELECT GHR_INTERFACE_ID
,      MT_PROCESS_DATE
,      MT_SOURCE
,      MT_EFFECTIVE_DATE
,      MT_NAME
,      MT_STATUS
,      MT_PERSON_ID
,      MT_TABLE_NAME
,      MT_INFORMATION_TYPE
,      MT_INTER_BG_TRANSFER
,      TOTAL_SALARY
,      SALARY
,      LOCALITY_ADJUSTMENT
,      ADJUSTED_PAY
,      OTHER_PAY
,      FEGLI
,      ELIGIBILITY_EXPIRATION
,      RETIREMENT_PLAN
,      RETENTION_ALLOWANCE
,      STAFFING_DIFFERENTIAL
,      SUPERVISORY_DIFFERENTIAL
,      ENROLLMENT
,      HEALTH_PLAN
,      TEMPS_TOTAL_COST
,      TSP_AMOUNT
,      TSP_RATE
,      TSP_G_FUND
,      TSP_F_FUND
,      TSP_C_FUND
,      TSP_STATUS
,      TSP_STATUS_DATE
,      TSP_ELIGIBILITY_DATE
,      WGI_STATUS
,      WGI_DATE_DUE
,      WGI_PAY_DATE
,      WGI_LAST_INCREASE_DATE
,      WGI_POSTPONMT_EFFECTIVE
,      WGI_POSTPONMT_DETERM_DUE
,      FEGLI_MEANING
,      RETIREMENT_PLAN_MEANING
,      AUO_AMOUNT
,      AUO_PREMIUM_PAY_IND
,      AP_AMOUNT
,      AP_PREMIUM_PAY_IND
,      TO_RETENTION_ALLOW_PERCENTAGE
,      TO_SUPERVISORY_DIFF_PERCENTAGE
,      TO_STAFFING_DIFF_PERCENTAGE
,      TO_BASIC_SALARY_RATE
,      TO_ADJUSTED_BASIC_PAY
,      TO_TOTAL_SALARY
FROM APPS.GHR_MT_ELEMENT_ENTRIES_V;

Dependencies

[top of page]

APPS.GHR_MT_ELEMENT_ENTRIES_V references the following:

APPS: GHR_INTERFACE

APPS.GHR_MT_ELEMENT_ENTRIES_V is referenced by following:

APPS: GHR_MTI_INT_INSERT - show dependent code; GHR_MTO_INT - show dependent code; GHR_MTO_INT - show dependent code; GHR_MT_INTERFACE_V