Product: | PAY - Payroll |
---|---|
Description: | Used to support user interface |
Implementation/DBA Data: | APPS.PAY_ELEMENT_TYPE_RULES_V |
SELECT ETR.ROWID ROW_ID
, ETR.ELEMENT_TYPE_ID
, ETR.ELEMENT_SET_ID
, ETR.INCLUDE_OR_EXCLUDE
, ETR.LAST_UPDATE_DATE
, ETR.LAST_UPDATED_BY
, ETR.LAST_UPDATE_LOGIN
, ETR.CREATED_BY
, ETR.CREATION_DATE
, ETTL.ELEMENT_NAME
, HL2.MEANING PROCESSING_TYPE
, ECTL.CLASSIFICATION_NAME
, HL.MEANING INCLUDE_OR_EXCLUDE_MEANING
FROM PAY_ELEMENT_TYPE_RULES ETR
, PAY_ELEMENT_TYPES_F_TL ETTL
, PAY_ELEMENT_TYPES_F ET
, PAY_ELEMENT_CLASSIFICATIONS_TL ECTL
, PAY_ELEMENT_CLASSIFICATIONS EC
, FND_SESSIONS SES
, HR_LOOKUPS HL
, HR_LOOKUPS HL2
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 ET.ELEMENT_TYPE_ID = ETR.ELEMENT_TYPE_ID
AND EC.CLASSIFICATION_ID = ET.CLASSIFICATION_ID
AND HL.LOOKUP_TYPE = 'INCLUDE_EXCLUDE'
AND HL.LOOKUP_CODE = ETR.INCLUDE_OR_EXCLUDE
AND HL2.LOOKUP_TYPE = 'PROCESSING_TYPE'
AND HL2.LOOKUP_CODE = ET.PROCESSING_TYPE
AND SES.SESSION_ID = USERENV('SESSIONID')
AND SES.EFFECTIVE_DATE BETWEEN ET.EFFECTIVE_START_DATE
AND ET.EFFECTIVE_END_DATE