Product: | PAY - Payroll |
---|---|
Description: | Denormalized view of PAY_ELEMENT_TYPES_F used by US legislation specific forms modules.. |
Implementation/DBA Data: | APPS.PAY_ELEMENT_TYPES_V2 |
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