VIEW: APPS.PAY_ELEMENT_TYPES_V2

Source

View Text - Preformatted

SELECT ET.ROWID ROW_ID , ET.ELEMENT_TYPE_ID ELEMENT_TYPE_ID , ET.EFFECTIVE_START_DATE EFFECTIVE_START_DATE , ET.EFFECTIVE_END_DATE EFFECTIVE_END_DATE , ET.BUSINESS_GROUP_ID + 0 BUSINESS_GROUP_ID , ET.LEGISLATION_CODE LEGISLATION_CODE , ETTL.ELEMENT_NAME ELEMENT_NAME , ETTL.DESCRIPTION ELEMENT_DESCRIPTION , ET.INPUT_CURRENCY_CODE CURRENCY_CODE , BC.BENEFIT_CLASSIFICATION_NAME BENEFIT_CLASSIFICATION_NAME , ECTL.CLASSIFICATION_NAME PAYROLL_CLASSIFICATION_NAME , BCV.NAME CARRIER , ET.ELEMENT_INFORMATION4 PERIOD_TYPE , NVL(BC.DEPENDENTS_ALLOWED_FLAG, 'N') DEPENDENT_ALLOWED_FLAG , NVL(BC.COBRA_FLAG, 'N') COBRA_FLAG , IV_ER.UOM ER_UOM , IV_ER.INPUT_VALUE_ID ER_CONTR_INPUT_VALUE_ID FROM HR_BENEFITS_CARRIERS_V BCV, PAY_ELEMENT_CLASSIFICATIONS EC, PAY_ELEMENT_CLASSIFICATIONS_TL ECTL, BEN_BENEFIT_CLASSIFICATIONS BC, PAY_INPUT_VALUES_F IV_ER, PAY_ELEMENT_TYPES_F ET, PAY_ELEMENT_TYPES_F_TL ETTL, FND_SESSIONS S 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 S.SESSION_ID = USERENV('SESSIONID') AND S.EFFECTIVE_DATE BETWEEN ET.EFFECTIVE_START_DATE AND ET.EFFECTIVE_END_DATE AND ET.PROCESSING_TYPE = 'R' AND IV_ER.ELEMENT_TYPE_ID = ET.ELEMENT_TYPE_ID AND S.EFFECTIVE_DATE BETWEEN IV_ER.EFFECTIVE_START_DATE AND IV_ER.EFFECTIVE_END_DATE AND UPPER(IV_ER.NAME) = 'ER CONTR' AND EC.CLASSIFICATION_ID = ET.CLASSIFICATION_ID AND BC.BENEFIT_CLASSIFICATION_ID = ET.BENEFIT_CLASSIFICATION_ID AND BC.CONTRIBUTIONS_USED = 'Y' AND BCV.ORGANIZATION_ID(+) = ET.ELEMENT_INFORMATION5

View Text - HTML Formatted

SELECT ET.ROWID ROW_ID
, ET.ELEMENT_TYPE_ID ELEMENT_TYPE_ID
, ET.EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, ET.EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, ET.BUSINESS_GROUP_ID + 0 BUSINESS_GROUP_ID
, ET.LEGISLATION_CODE LEGISLATION_CODE
, ETTL.ELEMENT_NAME ELEMENT_NAME
, ETTL.DESCRIPTION ELEMENT_DESCRIPTION
, ET.INPUT_CURRENCY_CODE CURRENCY_CODE
, BC.BENEFIT_CLASSIFICATION_NAME BENEFIT_CLASSIFICATION_NAME
, ECTL.CLASSIFICATION_NAME PAYROLL_CLASSIFICATION_NAME
, BCV.NAME CARRIER
, ET.ELEMENT_INFORMATION4 PERIOD_TYPE
, NVL(BC.DEPENDENTS_ALLOWED_FLAG
, 'N') DEPENDENT_ALLOWED_FLAG
, NVL(BC.COBRA_FLAG
, 'N') COBRA_FLAG
, IV_ER.UOM ER_UOM
, IV_ER.INPUT_VALUE_ID ER_CONTR_INPUT_VALUE_ID
FROM HR_BENEFITS_CARRIERS_V BCV
, PAY_ELEMENT_CLASSIFICATIONS EC
, PAY_ELEMENT_CLASSIFICATIONS_TL ECTL
, BEN_BENEFIT_CLASSIFICATIONS BC
, PAY_INPUT_VALUES_F IV_ER
, PAY_ELEMENT_TYPES_F ET
, PAY_ELEMENT_TYPES_F_TL ETTL
, FND_SESSIONS S
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 S.SESSION_ID = USERENV('SESSIONID')
AND S.EFFECTIVE_DATE BETWEEN ET.EFFECTIVE_START_DATE
AND ET.EFFECTIVE_END_DATE
AND ET.PROCESSING_TYPE = 'R'
AND IV_ER.ELEMENT_TYPE_ID = ET.ELEMENT_TYPE_ID
AND S.EFFECTIVE_DATE BETWEEN IV_ER.EFFECTIVE_START_DATE
AND IV_ER.EFFECTIVE_END_DATE
AND UPPER(IV_ER.NAME) = 'ER CONTR'
AND EC.CLASSIFICATION_ID = ET.CLASSIFICATION_ID
AND BC.BENEFIT_CLASSIFICATION_ID = ET.BENEFIT_CLASSIFICATION_ID
AND BC.CONTRIBUTIONS_USED = 'Y'
AND BCV.ORGANIZATION_ID(+) = ET.ELEMENT_INFORMATION5