VIEW: APPS.PAY_ELEMENT_TYPES_V

Source

View Text - Preformatted

SELECT ET.ELEMENT_TYPE_ID , ETTL.ELEMENT_NAME , ECTL.CLASSIFICATION_NAME , HR.MEANING , ETTL.DESCRIPTION , ET.INPUT_CURRENCY_CODE , ET.OUTPUT_CURRENCY_CODE , ET.BUSINESS_GROUP_ID , ET.LEGISLATION_CODE FROM PAY_ELEMENT_CLASSIFICATIONS_TL ECTL, PAY_ELEMENT_CLASSIFICATIONS EC, HR_LOOKUPS HR, PAY_ELEMENT_TYPES_F_TL ETTL, PAY_ELEMENT_TYPES_F ET WHERE ET.element_type_id = ETTL.element_type_id AND ETTL.LANGUAGE = userenv('LANG') AND EC.Classification_id = ECTL.classification_id AND ECTL.LANGUAGE = userenv('LANG') AND HR.LOOKUP_TYPE = 'PROCESSING_TYPE' AND HR.LOOKUP_CODE = ET.PROCESSING_TYPE AND EC.CLASSIFICATION_ID = ET.CLASSIFICATION_ID AND ET.EFFECTIVE_START_DATE <= (SELECT FS.EFFECTIVE_DATE FROM FND_SESSIONS FS WHERE FS.SESSION_ID = USERENV('SESSIONID')) AND ET.EFFECTIVE_END_DATE >= (SELECT FS.EFFECTIVE_DATE FROM FND_SESSIONS FS WHERE FS.SESSION_ID = USERENV('SESSIONID'))

View Text - HTML Formatted

SELECT ET.ELEMENT_TYPE_ID
, ETTL.ELEMENT_NAME
, ECTL.CLASSIFICATION_NAME
, HR.MEANING
, ETTL.DESCRIPTION
, ET.INPUT_CURRENCY_CODE
, ET.OUTPUT_CURRENCY_CODE
, ET.BUSINESS_GROUP_ID
, ET.LEGISLATION_CODE
FROM PAY_ELEMENT_CLASSIFICATIONS_TL ECTL
, PAY_ELEMENT_CLASSIFICATIONS EC
, HR_LOOKUPS HR
, PAY_ELEMENT_TYPES_F_TL ETTL
, PAY_ELEMENT_TYPES_F ET
WHERE ET.ELEMENT_TYPE_ID = ETTL.ELEMENT_TYPE_ID
AND ETTL.LANGUAGE = USERENV('LANG')
AND EC.CLASSIFICATION_ID = ECTL.CLASSIFICATION_ID
AND ECTL.LANGUAGE = USERENV('LANG')
AND HR.LOOKUP_TYPE = 'PROCESSING_TYPE'
AND HR.LOOKUP_CODE = ET.PROCESSING_TYPE
AND EC.CLASSIFICATION_ID = ET.CLASSIFICATION_ID
AND ET.EFFECTIVE_START_DATE <= (SELECT FS.EFFECTIVE_DATE
FROM FND_SESSIONS FS
WHERE FS.SESSION_ID = USERENV('SESSIONID'))
AND ET.EFFECTIVE_END_DATE >= (SELECT FS.EFFECTIVE_DATE
FROM FND_SESSIONS FS
WHERE FS.SESSION_ID = USERENV('SESSIONID'))