VIEW: APPS.PAY_ELEMENT_TYPE_USAGES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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