View: PAY_ELEMENT_TYPE_USAGES_V

Product:	PAY - Payroll
Description:
Implementation/DBA Data:	APPS.PAY_ELEMENT_TYPE_USAGES_V

View Text

SELECT ETU.ELEMENT_TYPE_USAGE_ID
, ETU.EFFECTIVE_START_DATE
, ETU.EFFECTIVE_END_DATE
, ETU.INCLUSION_FLAG
, HR_GENERAL.DECODE_LOOKUP('ELEMENT_USAGE_TYPE'
, ETU.USAGE_TYPE) USAGE_TYPE
, ETU.OBJECT_VERSION_NUMBER
, ETU.RUN_TYPE_ID
, PRT_TL.RUN_TYPE_NAME
, ETU.ELEMENT_TYPE_ID
, PET_TL.ELEMENT_NAME
, ETU.BUSINESS_GROUP_ID
, ETU.LEGISLATION_CODE
, ETU.ROWID ROW_ID
FROM PAY_ELEMENT_TYPE_USAGES_F ETU
, PAY_RUN_TYPES_F PRT
, PAY_RUN_TYPES_F_TL PRT_TL
, PAY_ELEMENT_TYPES_F PET
, PAY_ELEMENT_TYPES_F_TL PET_TL
, FND_SESSIONS FS
WHERE ETU.RUN_TYPE_ID = PRT.RUN_TYPE_ID
AND PRT.RUN_TYPE_ID = PRT_TL.RUN_TYPE_ID
AND PRT_TL.LANGUAGE = USERENV('LANG')
AND ETU.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND PET.ELEMENT_TYPE_ID = PET_TL.ELEMENT_TYPE_ID
AND PET_TL.LANGUAGE = USERENV('LANG')
AND FS.SESSION_ID = USERENV('SESSIONID')
AND FS.EFFECTIVE_DATE BETWEEN ETU.EFFECTIVE_START_DATE
AND ETU.EFFECTIVE_END_DATE
AND FS.EFFECTIVE_DATE BETWEEN PRT.EFFECTIVE_START_DATE
AND PRT.EFFECTIVE_END_DATE
AND FS.EFFECTIVE_DATE BETWEEN PET.EFFECTIVE_START_DATE
AND PET.EFFECTIVE_END_DATE

Columns