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

Object Details

Object Name:	PAYBV_ELEMENT_LINK_DETAIL_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PAY.PAYBV_ELEMENT_LINK_DETAIL_V
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

[View Source]

Columns

Name	Datatype	Length	Mandatory
CLASSIFICATION_NAME	VARCHAR2	(80)	Yes
ELEMENT_NAME	VARCHAR2	(80)	Yes
PROCESSING_TYPE_M	VARCHAR2	(4000)
STANDARD_LINK_M	VARCHAR2	(4000)
LINK_TO_ALL_PAYROLLS_FLAG_M	VARCHAR2	(4000)
AGE_CRITERIA	NUMBER	(2)
SERVICE_CRITERIA	NUMBER	(6)
EFFECTIVE_START_DATE	DATE		Yes
EFFECTIVE_END_DATE	DATE		Yes
LINK_START_DATE	DATE
LINK_END_DATE	DATE
COST_ALLOCATION_KEYFLEX_ID	NUMBER	(9)
BALANCING_KEYFLEX_ID	NUMBER	(9)
PAYROLL_NAME	VARCHAR2	(4000)
PEOPLE_GROUP_NAME	VARCHAR2	(4000)
COSTABLE_TYPE_M	VARCHAR2	(4000)
DISTRIBUTION_SET_NAME	VARCHAR2	(80)
ORGANIZATION_NAME	VARCHAR2	(4000)
JOB_NAME	VARCHAR2	(4000)
POSITION_NAME	VARCHAR2	(4000)
GRADE_NAME	VARCHAR2	(4000)
PAY_BASIS_NAME	VARCHAR2	(4000)
LOCATION_NAME	VARCHAR2	(4000)
EMPLOYMENT_CATEGORY_M	VARCHAR2	(4000)
HOT_DEFAULT_FLAG_M	VARCHAR2	(4000)
COSTING	VARCHAR2	(2000)
BALANCING	VARCHAR2	(2000)
INPUT_VALUE_NAME	VARCHAR2	(80)	Yes
INPUT_VALUE_UOM_M	VARCHAR2	(4000)
INPUT_VALUE_DEFAULT	VARCHAR2	(60)
LINK_TO_ALL_PAYROLLS_FLAG	VARCHAR2	(30)	Yes
PROCESSING_TYPE	VARCHAR2	(30)	Yes
STANDARD_LINK	VARCHAR2	(30)	Yes
COSTABLE_TYPE	VARCHAR2	(30)	Yes
EMPLOYMENT_CATEGORY	VARCHAR2	(30)
HOT_DEFAULT_FLAG	VARCHAR2	(30)	Yes
INPUT_VALUE_UOM	VARCHAR2	(30)	Yes
ELEMENT_TYPE_ID	NUMBER	(9)	Yes
PAYROLL_ID	NUMBER	(9)
PEOPLE_GROUP_ID	NUMBER	(15)
BUSINESS_GROUP_ID	NUMBER	(15)	Yes
CLASSIFICATION_ID	NUMBER	(9)	Yes
ORGANIZATION_ID	NUMBER	(15)
JOB_ID	NUMBER	(15)
POSITION_ID	NUMBER	(15)
GRADE_ID	NUMBER	(15)
PAY_BASIS_ID	NUMBER	(9)
LOCATION_ID	NUMBER	(15)
ELEMENT_LINK_ID	NUMBER	(9)	Yes
BG_SECURITY_FLAG_CODE	CHAR	(1)
QUALIFYING_UNITS	VARCHAR2	(30)
QUALIFYING_UNITS_M	VARCHAR2	(4000)

Query Text

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


SELECT CLASSIFICATION_NAME
,      ELEMENT_NAME
,      PROCESSING_TYPE_M
,      STANDARD_LINK_M
,      LINK_TO_ALL_PAYROLLS_FLAG_M
,      AGE_CRITERIA
,      SERVICE_CRITERIA
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      LINK_START_DATE
,      LINK_END_DATE
,      COST_ALLOCATION_KEYFLEX_ID
,      BALANCING_KEYFLEX_ID
,      PAYROLL_NAME
,      PEOPLE_GROUP_NAME
,      COSTABLE_TYPE_M
,      DISTRIBUTION_SET_NAME
,      ORGANIZATION_NAME
,      JOB_NAME
,      POSITION_NAME
,      GRADE_NAME
,      PAY_BASIS_NAME
,      LOCATION_NAME
,      EMPLOYMENT_CATEGORY_M
,      HOT_DEFAULT_FLAG_M
,      COSTING
,      BALANCING
,      INPUT_VALUE_NAME
,      INPUT_VALUE_UOM_M
,      INPUT_VALUE_DEFAULT
,      LINK_TO_ALL_PAYROLLS_FLAG
,      PROCESSING_TYPE
,      STANDARD_LINK
,      COSTABLE_TYPE
,      EMPLOYMENT_CATEGORY
,      HOT_DEFAULT_FLAG
,      INPUT_VALUE_UOM
,      ELEMENT_TYPE_ID
,      PAYROLL_ID
,      PEOPLE_GROUP_ID
,      BUSINESS_GROUP_ID
,      CLASSIFICATION_ID
,      ORGANIZATION_ID
,      JOB_ID
,      POSITION_ID
,      GRADE_ID
,      PAY_BASIS_ID
,      LOCATION_ID
,      ELEMENT_LINK_ID
,      BG_SECURITY_FLAG_CODE
,      QUALIFYING_UNITS
,      QUALIFYING_UNITS_M
FROM APPS.PAYBV_ELEMENT_LINK_DETAIL_V;

Dependencies

[top of page]

APPS.PAYBV_ELEMENT_LINK_DETAIL_V references the following:

APPS: HR_BIS - show dependent code; HR_GENERAL - show dependent code; HR_SECURITY - show dependent code; PAY_COST_ALLOCATION_KEYFLEX; PAY_ELEMENT_CLASSIFICATIONS; PAY_ELEMENT_CLASSIFICATIONS_TL; PAY_ELEMENT_LINKS_F; PAY_ELEMENT_SETS; PAY_ELEMENT_TYPES_F; PAY_ELEMENT_TYPES_F_TL; PAY_INPUT_VALUES_F; PAY_INPUT_VALUES_F_TL; PAY_LINK_INPUT_VALUES_F; PAY_PAYROLLS_F

APPS.PAYBV_ELEMENT_LINK_DETAIL_V is referenced by following:

PUBLIC: PAYBV_ELEMENT_LINK_DETAIL_V