Product: | PAY - Payroll |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PAY_US_ER_LIABILITY_TYPES_V |
SELECT DISTINCT PETTL.ELEMENT_NAME
, PET.ELEMENT_TYPE_ID
, PET.BUSINESS_GROUP_ID
, PET.EFFECTIVE_START_DATE
, PET.EFFECTIVE_END_DATE
, PET.LEGISLATION_CODE
, PET.ELEMENT_INFORMATION10
, PET.PROCESSING_PRIORITY
, PETTL.REPORTING_NAME
, NVL(PETTL.REPORTING_NAME
, PETTL.ELEMENT_NAME) REPORTING_NAME_ALT
, PECTL.CLASSIFICATION_NAME
, PEC.CLASSIFICATION_ID
FROM PAY_ELEMENT_CLASSIFICATIONS PEC
, PAY_ELEMENT_CLASSIFICATIONS_TL PECTL
, PAY_ELEMENT_TYPES_F PET
, PAY_ELEMENT_TYPES_F_TL PETTL
WHERE PEC.CLASSIFICATION_ID = PECTL.CLASSIFICATION_ID
AND PECTL.LANGUAGE = USERENV('LANG')
AND PET.ELEMENT_TYPE_ID = PETTL.ELEMENT_TYPE_ID
AND PETTL.LANGUAGE = USERENV('LANG')
AND PEC.CLASSIFICATION_NAME = 'EMPLOYER LIABILITIES'
AND PEC.CLASSIFICATION_ID = PET.CLASSIFICATION_ID
AND PET.ELEMENT_NAME NOT LIKE '%SPECIAL FEATURES'
AND PET.ELEMENT_NAME NOT LIKE '%SPECIAL INPUTS'