VIEW: APPS.PAY_CA_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', 'CA_REGULAR_EARNINGS', 'SUPPLEMENTAL EARNINGS', 'CA_SUPPLEMENTAL_EARNINGS', 'TAXABLE BENEFITS', 'CA_TAXABLE_BENEFITS', 'NON-PAYROLL PAYMENTS', 'CA_PAYMENT', NULL), et.element_information1) CATEGORY , NVL(PET.CONFIGURATION_INFORMATION3, 'N') OVERTIME_EARNINGS , NVL(PET.CONFIGURATION_INFORMATION4, 'N') OVERTIME_HOURS , ET.PROCESSING_TYPE , ET.PROCESSING_PRIORITY , ET.STANDARD_LINK_FLAG , ET.ELEMENT_INFORMATION10 PRIMARY_BALTYPE_ID , ET.ELEMENT_INFORMATION12 HOURS_BALTYPE_ID , NVL(PET.CONFIGURATION_INFORMATION5, 'N') REDUCE_REGULAR , NVL(PET.CONFIGURATION_INFORMATION6, 'N') EI_HOURS , hr_general.decode_lookup('CA_TAX_PROCESSING_TYPE', ET.ELEMENT_INFORMATION2) TAX_PROCESSING_TYPE , ET.ELEMENT_INFORMATION4 YEAR_END_FORM , ET.ELEMENT_INFORMATION18 ,ET.ELEMENT_INFORMATION19 ,ET.ELEMENT_INFORMATION20 , ET.LAST_UPDATE_DATE , ET.LAST_UPDATED_BY , ET.LAST_UPDATE_LOGIN , ET.CREATED_BY , ET.CREATION_DATE FROM PAY_ELEMENT_TYPES_F ET , PAY_ELEMENT_TYPES_F_TL ETTL , PAY_ELEMENT_TEMPLATES PET , PAY_ELEMENT_CLASSIFICATIONS EC , PAY_ELEMENT_CLASSIFICATIONS_TL ECTL WHERE ec.classification_id = ectl.classification_id and ectl.language = userenv('LANG') and et.element_type_id = ettl.element_type_id and ettl.language = userenv('LANG') AND UPPER(EC.CLASSIFICATION_NAME) IN ( 'EARNINGS', 'SUPPLEMENTAL EARNINGS', 'TAXABLE BENEFITS', 'NON-PAYROLL PAYMENTS') 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 = 'CA' AND ET.ELEMENT_NAME = PET.BASE_NAME AND PET.BUSINESS_GROUP_ID = ET.BUSINESS_GROUP_ID

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'
, 'CA_REGULAR_EARNINGS'
, 'SUPPLEMENTAL EARNINGS'
, 'CA_SUPPLEMENTAL_EARNINGS'
, 'TAXABLE BENEFITS'
, 'CA_TAXABLE_BENEFITS'
, 'NON-PAYROLL PAYMENTS'
, 'CA_PAYMENT'
, NULL)
, ET.ELEMENT_INFORMATION1) CATEGORY
, NVL(PET.CONFIGURATION_INFORMATION3
, 'N') OVERTIME_EARNINGS
, NVL(PET.CONFIGURATION_INFORMATION4
, 'N') OVERTIME_HOURS
, ET.PROCESSING_TYPE
, ET.PROCESSING_PRIORITY
, ET.STANDARD_LINK_FLAG
, ET.ELEMENT_INFORMATION10 PRIMARY_BALTYPE_ID
, ET.ELEMENT_INFORMATION12 HOURS_BALTYPE_ID
, NVL(PET.CONFIGURATION_INFORMATION5
, 'N') REDUCE_REGULAR
, NVL(PET.CONFIGURATION_INFORMATION6
, 'N') EI_HOURS
, HR_GENERAL.DECODE_LOOKUP('CA_TAX_PROCESSING_TYPE'
, ET.ELEMENT_INFORMATION2) TAX_PROCESSING_TYPE
, ET.ELEMENT_INFORMATION4 YEAR_END_FORM
, ET.ELEMENT_INFORMATION18
, ET.ELEMENT_INFORMATION19
, ET.ELEMENT_INFORMATION20
, ET.LAST_UPDATE_DATE
, ET.LAST_UPDATED_BY
, ET.LAST_UPDATE_LOGIN
, ET.CREATED_BY
, ET.CREATION_DATE
FROM PAY_ELEMENT_TYPES_F ET
, PAY_ELEMENT_TYPES_F_TL ETTL
, PAY_ELEMENT_TEMPLATES PET
, PAY_ELEMENT_CLASSIFICATIONS EC
, PAY_ELEMENT_CLASSIFICATIONS_TL ECTL
WHERE EC.CLASSIFICATION_ID = ECTL.CLASSIFICATION_ID
AND ECTL.LANGUAGE = USERENV('LANG')
AND ET.ELEMENT_TYPE_ID = ETTL.ELEMENT_TYPE_ID
AND ETTL.LANGUAGE = USERENV('LANG')
AND UPPER(EC.CLASSIFICATION_NAME) IN ( 'EARNINGS'
, 'SUPPLEMENTAL EARNINGS'
, 'TAXABLE BENEFITS'
, 'NON-PAYROLL PAYMENTS')
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 = 'CA'
AND ET.ELEMENT_NAME = PET.BASE_NAME
AND PET.BUSINESS_GROUP_ID = ET.BUSINESS_GROUP_ID