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.

[Home] [Help]

View: PAY_ELEMENT_TYPES_D

Product:	PAY - Payroll
Description:	Used by DateTrack History
Implementation/DBA Data:	APPS.PAY_ELEMENT_TYPES_D

View Text

SELECT TYPE.ELEMENT_TYPE_ID
, TYPE.EFFECTIVE_START_DATE
, TYPE.EFFECTIVE_END_DATE
, TYPETL.ELEMENT_NAME
, TYPE.PROCESSING_PRIORITY
, TYPE.QUALIFYING_AGE
, TYPE.QUALIFYING_LENGTH_OF_SERVICE
, TYPE.QUALIFYING_UNITS
, TYPETL.REPORTING_NAME
, ECLASSTL.CLASSIFICATION_NAME
, FND1.MEANING
, TYPE.LAST_UPDATE_DATE
, FUSER.USER_NAME
, TYPE.THIRD_PARTY_PAY_ONLY_FLAG
, TYPE.ELEMENT_NAME SYSTEM_ELEMENT_NAME
FROM PAY_ELEMENT_CLASSIFICATIONS_TL ECLASSTL
, PAY_ELEMENT_TYPES_F_TL TYPETL
, PAY_ELEMENT_TYPES_F TYPE
, PAY_ELEMENT_CLASSIFICATIONS ECLASS
, FND_LOOKUPS FND1
, FND_USER FUSER
WHERE TYPE.ELEMENT_TYPE_ID = TYPETL.ELEMENT_TYPE_ID
AND TYPETL.LANGUAGE = USERENV('LANG')
AND ECLASS.CLASSIFICATION_ID = ECLASSTL.CLASSIFICATION_ID
AND ECLASSTL.LANGUAGE = USERENV('LANG')
AND ECLASS.CLASSIFICATION_ID = TYPE.CLASSIFICATION_ID
AND FND1.LOOKUP_CODE = TYPE.CLOSED_FOR_ENTRY_FLAG
AND FND1.LOOKUP_TYPE = 'YES_NO'
AND FUSER.USER_ID (+)= TYPE.LAST_UPDATED_BY

Columns

Name
ELEMENT_TYPE_ID
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
ELEMENT_NAME
PROCESSING_PRIORITY
QUALIFYING_AGE
QUALIFYING_LENGTH_OF_SERVICE
QUALIFYING_UNITS
REPORTING_NAME
CLASSIFICATION
CLOSED_FOR_ENTRY
LAST_UPDATE_DATE
LAST_UPDATED_BY
THIRD_PARTY_PAY_ONLY_FLAG
SYSTEM_ELEMENT_NAME