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

Object Details

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

View Type

A public view which may be useful for custom reporting or other data
requirements.

PAY_ELEMENT_SET_MEMBERS identifies the list of elements that
belong to each element set. The members of an element set are
derived from the rules in PAY_ELE_CLASSIFICATION_RULES and
PAY_ELEMENT_TYPE_RULES.

[View Source]

Columns

Name	Datatype	Length	Comments
ELEMENT_SET_ID	NUMBER	(9)	Element set id of PAY_ELEMENT_SETS table
ELEMENT_TYPE_ID	NUMBER	(9)	Element type id of PAY_ELEMENT_TYPES_F table
ELEMENT_NAME	VARCHAR2	(80)	Element Name
CLASSIFICATION_ID	NUMBER	(9)	Element classification
PROCESSING_TYPE	VARCHAR2	(30)	Element processing type
BUSINESS_GROUP_ID	NUMBER	(15)	Business group id
LEGISLATION_CODE	VARCHAR2	(30)	Legislation code
CLASSIFICATION_NAME	VARCHAR2	(80)	Name of the classification
PROCESSING_TYPE_MEANING	VARCHAR2	(80)	Processing type meaning from HR_LOOKUPS

Query Text

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


SELECT ELEMENT_SET_ID
,      ELEMENT_TYPE_ID
,      ELEMENT_NAME
,      CLASSIFICATION_ID
,      PROCESSING_TYPE
,      BUSINESS_GROUP_ID
,      LEGISLATION_CODE
,      CLASSIFICATION_NAME
,      PROCESSING_TYPE_MEANING
FROM APPS.PAY_ELEMENT_SET_MEMBERS;

Dependencies

[top of page]

APPS.PAY_ELEMENT_SET_MEMBERS references the following:

APPS: FND_GLOBAL - show dependent code; HR_API - show dependent code; HR_LOOKUPS; PAY_ELEMENT_CLASSIFICATIONS; PAY_ELEMENT_CLASSIFICATIONS_TL; PAY_ELEMENT_SETS; PAY_ELEMENT_TYPES; PAY_ELEMENT_TYPE_RULES; PAY_ELE_CLASSIFICATION_RULES; PAY_INPUT_VALUES_F

APPS.PAY_ELEMENT_SET_MEMBERS is referenced by following:

APPS: HR_ELEMENT_LINKS - show dependent code; PAY_DK_PR_ELE - show dependent code; PAY_DK_PR_LE - show dependent code; PAY_DK_PR_ORG - show dependent code; PAY_ELEMENT_LINKS_PKG - show dependent code; PAY_FI_ARCHIVE_ACRA - show dependent code; PQP_GB_PSI_STH_HISTORY - show dependent code; PQP_UTILITIES - show dependent code
PUBLIC: PAY_ELEMENT_SET_MEMBERS