APPS.PAY_CA_ALL_DEDUCTION_TYPES_V
[Home] [Help]
| Product: | PAY - Payroll |
|---|---|
| Description: | |
| Implementation/DBA Data: |
APPS.PAY_CA_ALL_DEDUCTION_TYPES_V
|
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)
, 'VOLUNTARY DEDUCTIONS'
, 'CA_VOLUNTARY_DEDUCTIONS'
, 'INVOLUNTARY DEDUCTIONS'
, 'CA_INVOLUNTARY_DEDUCTIONS'
, 'PRE-TAX DEDUCTIONS'
, 'CA_PRE_TAX_DEDUCTIONS'
, NULL)
, ET.ELEMENT_INFORMATION1 ) CATEGORY
, BC.BENEFIT_CLASSIFICATION_NAME BEN_CLASS_NAME
, ET.PROCESSING_TYPE
, ET.PROCESSING_PRIORITY
, ET.STANDARD_LINK_FLAG
, NVL(ET.ELEMENT_INFORMATION2
, 'NONE') INSUFF_FUNDS_CODE
, NVL(ET.ELEMENT_INFORMATION3
, 'REG') PROCESSING_RUN_TYPE
, ET.ELEMENT_INFORMATION10 PRIMARY_BALTYPE_ID
, ET.ELEMENT_INFORMATION11 ACCRUED_BALTYPE_ID
, ET.ELEMENT_INFORMATION12 ARREARS_BALTYPE_ID
, ET.ELEMENT_INFORMATION13 NOT_TAKEN_BALTYPE_ID
, 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_CLASSIFICATIONS EC
, PAY_ELEMENT_CLASSIFICATIONS_TL ECTL
, BEN_BENEFIT_CLASSIFICATIONS BC
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 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 UPPER(EC.CLASSIFICATION_NAME) IN ( 'VOLUNTARY DEDUCTIONS'
, 'INVOLUNTARY DEDUCTIONS'
, 'PRE-TAX DEDUCTIONS')
AND EC.CLASSIFICATION_ID = ET.CLASSIFICATION_ID
AND BC.BENEFIT_CLASSIFICATION_ID(+) = ET.BENEFIT_CLASSIFICATION_ID