VIEW: APPS.PAY_ELEMENT_CLASS_USAGES_V

Source

View Text - Preformatted

SELECT ECU.ELEMENT_CLASS_USAGE_ID , ECU.EFFECTIVE_START_DATE , ECU.EFFECTIVE_END_DATE , ECU.OBJECT_VERSION_NUMBER , ECU.RUN_TYPE_ID , PRT_TL.RUN_TYPE_NAME , ECU.CLASSIFICATION_ID , PEC.CLASSIFICATION_NAME , ECU.BUSINESS_GROUP_ID , ECU.LEGISLATION_CODE , ECU.ROWID ROW_ID FROM PAY_ELEMENT_CLASS_USAGES_F ECU , PAY_RUN_TYPES_F PRT , PAY_RUN_TYPES_F_TL PRT_TL , PAY_ELEMENT_CLASSIFICATIONS PEC , FND_SESSIONS FS WHERE ECU.RUN_TYPE_ID = PRT.RUN_TYPE_ID AND PRT.RUN_TYPE_ID = PRT_TL.RUN_TYPE_ID AND PRT_TL.LANGUAGE = USERENV('LANG') AND ECU.CLASSIFICATION_ID = PEC.CLASSIFICATION_ID AND FS.SESSION_ID = USERENV('SESSIONID') AND FS.EFFECTIVE_DATE BETWEEN ECU.EFFECTIVE_START_DATE AND ECU.EFFECTIVE_END_DATE AND FS.EFFECTIVE_DATE BETWEEN PRT.EFFECTIVE_START_DATE AND PRT.EFFECTIVE_END_DATE

View Text - HTML Formatted

SELECT ECU.ELEMENT_CLASS_USAGE_ID
, ECU.EFFECTIVE_START_DATE
, ECU.EFFECTIVE_END_DATE
, ECU.OBJECT_VERSION_NUMBER
, ECU.RUN_TYPE_ID
, PRT_TL.RUN_TYPE_NAME
, ECU.CLASSIFICATION_ID
, PEC.CLASSIFICATION_NAME
, ECU.BUSINESS_GROUP_ID
, ECU.LEGISLATION_CODE
, ECU.ROWID ROW_ID
FROM PAY_ELEMENT_CLASS_USAGES_F ECU
, PAY_RUN_TYPES_F PRT
, PAY_RUN_TYPES_F_TL PRT_TL
, PAY_ELEMENT_CLASSIFICATIONS PEC
, FND_SESSIONS FS
WHERE ECU.RUN_TYPE_ID = PRT.RUN_TYPE_ID
AND PRT.RUN_TYPE_ID = PRT_TL.RUN_TYPE_ID
AND PRT_TL.LANGUAGE = USERENV('LANG')
AND ECU.CLASSIFICATION_ID = PEC.CLASSIFICATION_ID
AND FS.SESSION_ID = USERENV('SESSIONID')
AND FS.EFFECTIVE_DATE BETWEEN ECU.EFFECTIVE_START_DATE
AND ECU.EFFECTIVE_END_DATE
AND FS.EFFECTIVE_DATE BETWEEN PRT.EFFECTIVE_START_DATE
AND PRT.EFFECTIVE_END_DATE