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

Object Details

Object Name:	HR_PAY_INTERFACE_OAB_VALUE_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PER.HR_PAY_INTERFACE_OAB_VALUE_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
CONTRIBUTION_AMOUNT	VARCHAR2	(60)		The monetary contribution amount per pay period.
ACTY_TYP_CD	VARCHAR2	(30)		The activity type code. This code holds where the contribution amount is coming from.
ASSIGNMENT_ID	NUMBER	(10)	Yes	Internal identification number for the assignment.
ASSIGNMENT_NUMBER	VARCHAR2	(30)		The number of the related assignment.
EFFECTIVE_START_DATE	DATE		Yes	The assignment effective start date
EFFECTIVE_END_DATE	DATE		Yes	The assignment effective end date
RT_STRT_DT	DATE		Yes	The activty rate start date
RT_END_DT	DATE		Yes	The activity rate end date
MIN_RT_STRT_DT	DATE		Yes	The activity rate end date
MAX_RT_END_DT	DATE		Yes	The activity rate end date
RATE_AMOUNT	NUMBER			The contribution amount before it has been converted to a pay period amount.
RATE_PERIOD	VARCHAR2	(30)		The period the rate amount is for.
MAX_ANNUAL_AMOUNT	NUMBER			The maximum amount that can be contributed annual
ELEMENT_ENTRY_ESD	DATE		Yes	The element entry effective start date
ELEMENT_ENTRY_EED	DATE		Yes	The element entry effective effective end date.
PRTT_ENRT_RSLT_ID	NUMBER	(15)	Yes	Internal Identifer to table BEN_PRTT_ENRT_RSLT_F
PRTT_RT_VAL_ID	NUMBER	(15)	Yes	Internal identifier to BEN_PRTT_RT_VAL
ELEMENT_ENTRY_VALUE_ID	NUMBER	(15)	Yes	Internal identifier to table PAY_ELEMENT_ENTRY_VALUES_F
PERSON_ID	NUMBER	(10)	Yes	Internal identifier to the PER_ALL_PEOPLE_F
PER_IN_LER_ID	NUMBER	(15)		Internal identifier
RT_TYP_CD	VARCHAR2	(30)		The type of rate that this is. The lookup_type is 'BEN_RT_TYP'. The value held in this column is the lookup_code.
OABV_LAST_UPDATE_DATE	DATE			The activity rate end date

Query Text

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


SELECT CONTRIBUTION_AMOUNT
,      ACTY_TYP_CD
,      ASSIGNMENT_ID
,      ASSIGNMENT_NUMBER
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      RT_STRT_DT
,      RT_END_DT
,      MIN_RT_STRT_DT
,      MAX_RT_END_DT
,      RATE_AMOUNT
,      RATE_PERIOD
,      MAX_ANNUAL_AMOUNT
,      ELEMENT_ENTRY_ESD
,      ELEMENT_ENTRY_EED
,      PRTT_ENRT_RSLT_ID
,      PRTT_RT_VAL_ID
,      ELEMENT_ENTRY_VALUE_ID
,      PERSON_ID
,      PER_IN_LER_ID
,      RT_TYP_CD
,      OABV_LAST_UPDATE_DATE
FROM APPS.HR_PAY_INTERFACE_OAB_VALUE_V;

Dependencies

[top of page]

APPS.HR_PAY_INTERFACE_OAB_VALUE_V references the following:

APPS: BEN_ACTY_BASE_RT_F; BEN_ACTY_RT_PTD_LMT_F; BEN_PRTT_RT_VAL; BEN_PTD_LMT_F; HR_PAY_INTERFACE_PKG - show dependent code; PAY_ELEMENT_ENTRIES_F; PAY_ELEMENT_ENTRY_VALUES_F; PER_ALL_ASSIGNMENTS_F

APPS.HR_PAY_INTERFACE_OAB_VALUE_V is referenced by following:

APPS: HR_CERIDIAN_500_OAB_BENEFIT_V; HR_CERIDIAN_OAB_BENEFIT_V; HR_PAY_INTERFACE_PKG - show dependent code