VIEW: APPS.PAY_US_EARNINGS_TYPES_V

Source

View Text - Preformatted

SELECT DISTINCT pettl.element_name, pet.element_type_id, pet.effective_start_date ,pet.effective_end_date, 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 pet.element_type_id = pettl.element_type_id AND pettl.LANGUAGE = userenv ('LANG') AND pec.classification_id = pectl.classification_id AND pectl.LANGUAGE = userenv ('LANG') AND pec.classification_name IN ('Earnings', 'Supplemental Earnings', 'Imputed Earnings', 'Non-payroll Payments','Alien/Expat Earnings') 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.EFFECTIVE_START_DATE
, PET.EFFECTIVE_END_DATE
, 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 PET.ELEMENT_TYPE_ID = PETTL.ELEMENT_TYPE_ID
AND PETTL.LANGUAGE = USERENV ('LANG')
AND PEC.CLASSIFICATION_ID = PECTL.CLASSIFICATION_ID
AND PECTL.LANGUAGE = USERENV ('LANG')
AND PEC.CLASSIFICATION_NAME IN ('EARNINGS'
, 'SUPPLEMENTAL EARNINGS'
, 'IMPUTED EARNINGS'
, 'NON-PAYROLL PAYMENTS'
, 'ALIEN/EXPAT EARNINGS')
AND PEC.CLASSIFICATION_ID = PET.CLASSIFICATION_ID
AND PET.ELEMENT_NAME NOT LIKE '%SPECIAL FEATURES'
AND PET.ELEMENT_NAME NOT LIKE '%SPECIAL INPUTS'