VIEW: APPS.PAY_ELEMENT_TYPES_D

Source

View Text - Preformatted

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

View Text - HTML Formatted

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