View: PAY_ELEMENT_TYPES_V

Product:	PAY - Payroll
Description:	Used to support user interface
Implementation/DBA Data:	APPS.PAY_ELEMENT_TYPES_V

View Text

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'))

Columns