VIEW: APPS.PAY_ALL_EARNINGS_TYPES_V

Source

View Text - Preformatted

SELECT et.element_type_id , et.effective_start_date , et.effective_end_date, et.business_group_id + 0 business_group_id , et.legislation_code , ettl.element_name , ettl.reporting_name , ettl.description , ectl.classification_name , hr_general.decode_lookup(decode(upper(ec.classification_name), 'EARNINGS', 'US_EARNINGS', 'SUPPLEMENTAL EARNINGS', 'US_SUPPLEMENTAL_EARNINGS', 'IMPUTED EARNINGS', 'US_IMPUTED_EARNINGS', 'NON-PAYROLL PAYMENTS', 'US_PAYMENT','ALIEN/EXPAT EARNINGS', 'PER_US_INCOME_TYPES', null), et.element_information1) category , hr_general.decode_lookup('US_SUPPLEMENTAL_EARNINGS', et.element_information14) alien_expat_suppl_category, nvl(et.element_information8, 'n') include_in_ot_base , nvl(et.element_information11, 'n') flsa_hours, et.element_information9 mix_category , et.processing_type , et.processing_priority , et.standard_link_flag , et.element_information10 primary_baltype_id , et.element_information12 hours_baltype_id , et.element_information13 reduce_regular , et.last_update_date , et.last_updated_by , et.last_update_login , et.created_by , et.creation_date FROM pay_element_types_f_tl ettl , pay_element_types_f et, pay_element_classifications_tl ectl, pay_element_classifications ec 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 ec.classification_name in ( 'Earnings', 'Supplemental Earnings', 'Imputed Earnings', 'Non-payroll Payments', 'Alien/Expat Earnings') and ec.classification_id = et.classification_id and et.effective_start_date <= (select s.effective_date from fnd_sessions s where s.session_id = userenv('sessionid')) and et.effective_end_date >= (select s.effective_date from fnd_sessions s where s.session_id = userenv('sessionid')) AND EC.LEGISLATION_CODE = 'US'

View Text - HTML Formatted

SELECT ET.ELEMENT_TYPE_ID
, ET.EFFECTIVE_START_DATE
, ET.EFFECTIVE_END_DATE
, ET.BUSINESS_GROUP_ID + 0 BUSINESS_GROUP_ID
, ET.LEGISLATION_CODE
, ETTL.ELEMENT_NAME
, ETTL.REPORTING_NAME
, ETTL.DESCRIPTION
, ECTL.CLASSIFICATION_NAME
, HR_GENERAL.DECODE_LOOKUP(DECODE(UPPER(EC.CLASSIFICATION_NAME)
, 'EARNINGS'
, 'US_EARNINGS'
, 'SUPPLEMENTAL EARNINGS'
, 'US_SUPPLEMENTAL_EARNINGS'
, 'IMPUTED EARNINGS'
, 'US_IMPUTED_EARNINGS'
, 'NON-PAYROLL PAYMENTS'
, 'US_PAYMENT'
, 'ALIEN/EXPAT EARNINGS'
, 'PER_US_INCOME_TYPES'
, NULL)
, ET.ELEMENT_INFORMATION1) CATEGORY
, HR_GENERAL.DECODE_LOOKUP('US_SUPPLEMENTAL_EARNINGS'
, ET.ELEMENT_INFORMATION14) ALIEN_EXPAT_SUPPL_CATEGORY
, NVL(ET.ELEMENT_INFORMATION8
, 'N') INCLUDE_IN_OT_BASE
, NVL(ET.ELEMENT_INFORMATION11
, 'N') FLSA_HOURS
, ET.ELEMENT_INFORMATION9 MIX_CATEGORY
, ET.PROCESSING_TYPE
, ET.PROCESSING_PRIORITY
, ET.STANDARD_LINK_FLAG
, ET.ELEMENT_INFORMATION10 PRIMARY_BALTYPE_ID
, ET.ELEMENT_INFORMATION12 HOURS_BALTYPE_ID
, ET.ELEMENT_INFORMATION13 REDUCE_REGULAR
, ET.LAST_UPDATE_DATE
, ET.LAST_UPDATED_BY
, ET.LAST_UPDATE_LOGIN
, ET.CREATED_BY
, ET.CREATION_DATE
FROM PAY_ELEMENT_TYPES_F_TL ETTL
, PAY_ELEMENT_TYPES_F ET
, PAY_ELEMENT_CLASSIFICATIONS_TL ECTL
, PAY_ELEMENT_CLASSIFICATIONS EC
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 EC.CLASSIFICATION_NAME IN ( 'EARNINGS'
, 'SUPPLEMENTAL EARNINGS'
, 'IMPUTED EARNINGS'
, 'NON-PAYROLL PAYMENTS'
, 'ALIEN/EXPAT EARNINGS')
AND EC.CLASSIFICATION_ID = ET.CLASSIFICATION_ID
AND ET.EFFECTIVE_START_DATE <= (SELECT S.EFFECTIVE_DATE
FROM FND_SESSIONS S
WHERE S.SESSION_ID = USERENV('SESSIONID'))
AND ET.EFFECTIVE_END_DATE >= (SELECT S.EFFECTIVE_DATE
FROM FND_SESSIONS S
WHERE S.SESSION_ID = USERENV('SESSIONID'))
AND EC.LEGISLATION_CODE = 'US'