VIEW: APPS.PAY_US_ER_LIABILITY_TYPES_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'