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_VALUE2_V

Object Details

Object Name:	HR_PAY_INTERFACE_OAB_VALUE2_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PER.HR_PAY_INTERFACE_OAB_VALUE2_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)		Contribution amount
ACTY_TYP_CD	VARCHAR2	(30)		activity type code
ASSIGNMENT_ID	NUMBER	(10)	Yes	assignment ID
ASSIGNMENT_NUMBER	VARCHAR2	(30)		assignment number
EFFECTIVE_START_DATE	DATE		Yes	effective start date
EFFECTIVE_END_DATE	DATE		Yes	effective end date
RT_STRT_DT	DATE		Yes	rate start date
RT_END_DT	DATE		Yes	rate end date
MIN_RT_STRT_DT	DATE		Yes	minimum rate start date
MAX_RT_END_DT	DATE		Yes	maximum rate end date
RATE_AMOUNT	NUMBER			rate amount
RATE_PERIOD	VARCHAR2	(30)		rate period
MAX_ANNUAL_AMOUNT	NUMBER			maximum annual amount
ELEMENT_ENTRY_ESD	DATE		Yes	element entry effective start date
ELEMENT_ENTRY_EED	DATE		Yes	element entry effective end date
PRTT_ENRT_RSLT_ID	NUMBER	(15)	Yes	prtt enrt rslt id
PRTT_RT_VAL_ID	NUMBER	(15)	Yes	prtt rt val id
ELEMENT_ENTRY_VALUE_ID	NUMBER	(15)	Yes	element entry value id
PERSON_ID	NUMBER	(10)	Yes	person id
PER_IN_LER_ID	NUMBER	(15)		per in ler id
RT_TYP_CD	VARCHAR2	(30)		rate type code
OABV_LAST_UPDATE_DATE	DATE			OAB view last update 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_VALUE2_V;

Dependencies

[top of page]

APPS.HR_PAY_INTERFACE_OAB_VALUE2_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_VALUE2_V is referenced by following:

APPS: HR_CERIDIAN_500_OAB_ER_V; HR_PAY_INTERFACE_PKG - show dependent code
PUBLIC: HR_PAY_INTERFACE_OAB_VALUE2_V