eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: PAY_IN_TAX_DECLARATIONS_V

Product:	PAY - Payroll
Description:
Implementation/DBA Data:	APPS.PAY_IN_TAX_DECLARATIONS_V

View Text

SELECT DISTINCT PPF.PERSON_ID
, PPF.FULL_NAME
, PPF.EMPLOYEE_NUMBER
, PAF.ASSIGNMENT_ID
, PAF.ASSIGNMENT_NUMBER
, SYSDATE
, HOU.NAME
, PAY_IN_TAX_DECLARATION.GET_LAST_UPDATED_DATE(PPF.PERSON_ID
, SYSDATE
, 'ALL')
, HOU.ORGANIZATION_ID
, HOU.BUSINESS_GROUP_ID
, PPF.START_DATE
, PAF.GRADE_ID
, PAF.JOB_ID
, PAF.POSITION_ID
, ITAX.ORG_INFORMATION1
, PAE.AEI_INFORMATION2
, PAE.AEI_INFORMATION1 /*HOUSE RENT INFORMATION*/
, PAY_IN_TAX_DECLARATION.GET_NUMERIC_VALUE (PAF.ASSIGNMENT_ID
, 'HOUSE RENT INFORMATION'
, 'APR'
, SYSDATE
, 'FALSE') APRIL
, PAY_IN_TAX_DECLARATION.GET_NUMERIC_VALUE (PAF.ASSIGNMENT_ID
, 'HOUSE RENT INFORMATION'
, 'MAY'
, SYSDATE
, 'FALSE') MAY
, PAY_IN_TAX_DECLARATION.GET_NUMERIC_VALUE (PAF.ASSIGNMENT_ID
, 'HOUSE RENT INFORMATION'
, 'JUN'
, SYSDATE
, 'FALSE') JUNE
, PAY_IN_TAX_DECLARATION.GET_NUMERIC_VALUE (PAF.ASSIGNMENT_ID
, 'HOUSE RENT INFORMATION'
, 'JUL'
, SYSDATE
, 'FALSE') JULY
, PAY_IN_TAX_DECLARATION.GET_NUMERIC_VALUE (PAF.ASSIGNMENT_ID
, 'HOUSE RENT INFORMATION'
, 'AUG'
, SYSDATE
, 'FALSE') AUGUST
, PAY_IN_TAX_DECLARATION.GET_NUMERIC_VALUE (PAF.ASSIGNMENT_ID
, 'HOUSE RENT INFORMATION'
, 'SEP'
, SYSDATE
, 'FALSE') SEPTEMBER
, PAY_IN_TAX_DECLARATION.GET_NUMERIC_VALUE (PAF.ASSIGNMENT_ID
, 'HOUSE RENT INFORMATION'
, 'OCT'
, SYSDATE
, 'FALSE') OCTOBER
, PAY_IN_TAX_DECLARATION.GET_NUMERIC_VALUE (PAF.ASSIGNMENT_ID
, 'HOUSE RENT INFORMATION'
, 'NOV'
, SYSDATE
, 'FALSE') NOVEMBER
, PAY_IN_TAX_DECLARATION.GET_NUMERIC_VALUE (PAF.ASSIGNMENT_ID
, 'HOUSE RENT INFORMATION'
, 'DEC'
, SYSDATE
, 'FALSE') DECEMBER
, PAY_IN_TAX_DECLARATION.GET_NUMERIC_VALUE (PAF.ASSIGNMENT_ID
, 'HOUSE RENT INFORMATION'
, 'JAN'
, SYSDATE
, 'FALSE') JANUARY
, PAY_IN_TAX_DECLARATION.GET_NUMERIC_VALUE (PAF.ASSIGNMENT_ID
, 'HOUSE RENT INFORMATION'
, 'FEB'
, SYSDATE
, 'FALSE') FEBRUARY
, PAY_IN_TAX_DECLARATION.GET_NUMERIC_VALUE (PAF.ASSIGNMENT_ID
, 'HOUSE RENT INFORMATION'
, 'MAR'
, SYSDATE
, 'FALSE') MARCH /*SECTION 80CCE DETAILS*/
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 1
, 'DEDUCTION UNDER SECTION 80CCE'
, 'ELEMENT ENTRY ID'
, SYSDATE) EE_ID1
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 1
, 'DEDUCTION UNDER SECTION 80CCE'
, 'COMPONENT NAME'
, SYSDATE) COMP1
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 1
, 'DEDUCTION UNDER SECTION 80CCE'
, 'INVESTMENT AMOUNT'
, SYSDATE) INV1
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 2
, 'DEDUCTION UNDER SECTION 80CCE'
, 'ELEMENT ENTRY ID'
, SYSDATE) EE_ID2
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 2
, 'DEDUCTION UNDER SECTION 80CCE'
, 'COMPONENT NAME'
, SYSDATE) COMP2
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 2
, 'DEDUCTION UNDER SECTION 80CCE'
, 'INVESTMENT AMOUNT'
, SYSDATE) INV2
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 3
, 'DEDUCTION UNDER SECTION 80CCE'
, 'ELEMENT ENTRY ID'
, SYSDATE) EE_ID3
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 3
, 'DEDUCTION UNDER SECTION 80CCE'
, 'COMPONENT NAME'
, SYSDATE) COMP3
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 3
, 'DEDUCTION UNDER SECTION 80CCE'
, 'INVESTMENT AMOUNT'
, SYSDATE) INV3
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 4
, 'DEDUCTION UNDER SECTION 80CCE'
, 'ELEMENT ENTRY ID'
, SYSDATE) EE_ID4
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 4
, 'DEDUCTION UNDER SECTION 80CCE'
, 'COMPONENT NAME'
, SYSDATE) COMP4
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 4
, 'DEDUCTION UNDER SECTION 80CCE'
, 'INVESTMENT AMOUNT'
, SYSDATE) INV4
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 5
, 'DEDUCTION UNDER SECTION 80CCE'
, 'ELEMENT ENTRY ID'
, SYSDATE) EE_ID5
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 5
, 'DEDUCTION UNDER SECTION 80CCE'
, 'COMPONENT NAME'
, SYSDATE) COMP5
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 5
, 'DEDUCTION UNDER SECTION 80CCE'
, 'INVESTMENT AMOUNT'
, SYSDATE) INV5
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 6
, 'DEDUCTION UNDER SECTION 80CCE'
, 'ELEMENT ENTRY ID'
, SYSDATE) EE_ID6
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 6
, 'DEDUCTION UNDER SECTION 80CCE'
, 'COMPONENT NAME'
, SYSDATE) COMP6
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 6
, 'DEDUCTION UNDER SECTION 80CCE'
, 'INVESTMENT AMOUNT'
, SYSDATE) INV6
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 7
, 'DEDUCTION UNDER SECTION 80CCE'
, 'ELEMENT ENTRY ID'
, SYSDATE) EE_ID7
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 7
, 'DEDUCTION UNDER SECTION 80CCE'
, 'COMPONENT NAME'
, SYSDATE) COMP7
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 7
, 'DEDUCTION UNDER SECTION 80CCE'
, 'INVESTMENT AMOUNT'
, SYSDATE) INV7
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 8
, 'DEDUCTION UNDER SECTION 80CCE'
, 'ELEMENT ENTRY ID'
, SYSDATE) EE_ID8
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 8
, 'DEDUCTION UNDER SECTION 80CCE'
, 'COMPONENT NAME'
, SYSDATE) COMP8
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 8
, 'DEDUCTION UNDER SECTION 80CCE'
, 'INVESTMENT AMOUNT'
, SYSDATE) INV8
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 9
, 'DEDUCTION UNDER SECTION 80CCE'
, 'ELEMENT ENTRY ID'
, SYSDATE) EE_ID9
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 9
, 'DEDUCTION UNDER SECTION 80CCE'
, 'COMPONENT NAME'
, SYSDATE) COMP9
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 9
, 'DEDUCTION UNDER SECTION 80CCE'
, 'INVESTMENT AMOUNT'
, SYSDATE) INV9
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 10
, 'DEDUCTION UNDER SECTION 80CCE'
, 'ELEMENT ENTRY ID'
, SYSDATE) EE_ID10
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 10
, 'DEDUCTION UNDER SECTION 80CCE'
, 'COMPONENT NAME'
, SYSDATE) COMP10
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 10
, 'DEDUCTION UNDER SECTION 80CCE'
, 'INVESTMENT AMOUNT'
, SYSDATE) INV10
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 11
, 'DEDUCTION UNDER SECTION 80CCE'
, 'ELEMENT ENTRY ID'
, SYSDATE) EE_ID11
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 11
, 'DEDUCTION UNDER SECTION 80CCE'
, 'COMPONENT NAME'
, SYSDATE) COMP11
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 11
, 'DEDUCTION UNDER SECTION 80CCE'
, 'INVESTMENT AMOUNT'
, SYSDATE) INV11
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 12
, 'DEDUCTION UNDER SECTION 80CCE'
, 'ELEMENT ENTRY ID'
, SYSDATE) EE_ID12
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 12
, 'DEDUCTION UNDER SECTION 80CCE'
, 'COMPONENT NAME'
, SYSDATE) COMP12
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 12
, 'DEDUCTION UNDER SECTION 80CCE'
, 'INVESTMENT AMOUNT'
, SYSDATE) INV12
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 13
, 'DEDUCTION UNDER SECTION 80CCE'
, 'ELEMENT ENTRY ID'
, SYSDATE) EE_ID13
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 13
, 'DEDUCTION UNDER SECTION 80CCE'
, 'COMPONENT NAME'
, SYSDATE) COMP13
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 13
, 'DEDUCTION UNDER SECTION 80CCE'
, 'INVESTMENT AMOUNT'
, SYSDATE) INV13
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 14
, 'DEDUCTION UNDER SECTION 80CCE'
, 'ELEMENT ENTRY ID'
, SYSDATE) EE_ID14
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 14
, 'DEDUCTION UNDER SECTION 80CCE'
, 'COMPONENT NAME'
, SYSDATE) COMP14
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 14
, 'DEDUCTION UNDER SECTION 80CCE'
, 'INVESTMENT AMOUNT'
, SYSDATE) INV14
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 15
, 'DEDUCTION UNDER SECTION 80CCE'
, 'ELEMENT ENTRY ID'
, SYSDATE) EE_ID15
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 15
, 'DEDUCTION UNDER SECTION 80CCE'
, 'COMPONENT NAME'
, SYSDATE) COMP15
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 15
, 'DEDUCTION UNDER SECTION 80CCE'
, 'INVESTMENT AMOUNT'
, SYSDATE) INV15
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 16
, 'DEDUCTION UNDER SECTION 80CCE'
, 'ELEMENT ENTRY ID'
, SYSDATE) EE_ID16
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 16
, 'DEDUCTION UNDER SECTION 80CCE'
, 'COMPONENT NAME'
, SYSDATE) COMP16
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 16
, 'DEDUCTION UNDER SECTION 80CCE'
, 'INVESTMENT AMOUNT'
, SYSDATE) INV16
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 17
, 'DEDUCTION UNDER SECTION 80CCE'
, 'ELEMENT ENTRY ID'
, SYSDATE) EE_ID17
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 17
, 'DEDUCTION UNDER SECTION 80CCE'
, 'COMPONENT NAME'
, SYSDATE) COMP17
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 17
, 'DEDUCTION UNDER SECTION 80CCE'
, 'INVESTMENT AMOUNT'
, SYSDATE) INV17
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 18
, 'DEDUCTION UNDER SECTION 80CCE'
, 'ELEMENT ENTRY ID'
, SYSDATE) EE_ID18
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 18
, 'DEDUCTION UNDER SECTION 80CCE'
, 'COMPONENT NAME'
, SYSDATE) COMP18
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 18
, 'DEDUCTION UNDER SECTION 80CCE'
, 'INVESTMENT AMOUNT'
, SYSDATE) INV18
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 19
, 'DEDUCTION UNDER SECTION 80CCE'
, 'ELEMENT ENTRY ID'
, SYSDATE) EE_ID19
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 19
, 'DEDUCTION UNDER SECTION 80CCE'
, 'COMPONENT NAME'
, SYSDATE) COMP19
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 19
, 'DEDUCTION UNDER SECTION 80CCE'
, 'INVESTMENT AMOUNT'
, SYSDATE) INV19
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 20
, 'DEDUCTION UNDER SECTION 80CCE'
, 'ELEMENT ENTRY ID'
, SYSDATE) EE_ID20
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 20
, 'DEDUCTION UNDER SECTION 80CCE'
, 'COMPONENT NAME'
, SYSDATE) COMP20
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 20
, 'DEDUCTION UNDER SECTION 80CCE'
, 'INVESTMENT AMOUNT'
, SYSDATE) INV20
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 21
, 'DEDUCTION UNDER SECTION 80CCE'
, 'ELEMENT ENTRY ID'
, SYSDATE) EE_ID21
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 21
, 'DEDUCTION UNDER SECTION 80CCE'
, 'COMPONENT NAME'
, SYSDATE) COMP21
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 21
, 'DEDUCTION UNDER SECTION 80CCE'
, 'INVESTMENT AMOUNT'
, SYSDATE) INV21 /* SECTION 80E EDUCATIN LOAN*/
, PAY_IN_TAX_DECLARATION.GET_NUMERIC_VALUE (PAF.ASSIGNMENT_ID
, 'DEDUCTION UNDER SECTION 80E'
, 'INTEREST AMOUNT'
, SYSDATE
, 'FALSE') HIGHER_EDUCATION_LOAN /* SECTION 80GGA DONATION FOR RESEARCH*/
, PAY_IN_TAX_DECLARATION.GET_NUMERIC_VALUE (PAF.ASSIGNMENT_ID
, 'DEDUCTION UNDER SECTION 80GGA'
, 'DONATION AMOUNT'
, SYSDATE
, 'FALSE') DONATION_FOR_RESEARCH /* SECTION 80GG CLAIM EXEMPTION*/
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, PAY_IN_TAX_DECLARATION.GET_VALUE (PAF.ASSIGNMENT_ID
, 'DEDUCTION UNDER SECTION 80GG'
, 'CLAIM EXEMPTION'
, SYSDATE
, 'FALSE')) CLAIM_EXEMPTION_SEC_80GG /* SECTION 80D MEDICAL INSURANCE PREMIUM*/
, PAY_IN_TAX_DECLARATION.GET_NUMERIC_VALUE (PAF.ASSIGNMENT_ID
, 'DEDUCTION UNDER SECTION 80D'
, 'MEDICAL INSURANCE PREMIUM'
, SYSDATE
, 'FALSE') PREMIUM_AMOUNT
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, PAY_IN_TAX_DECLARATION.GET_VALUE (PAF.ASSIGNMENT_ID
, 'DEDUCTION UNDER SECTION 80D'
, 'SENIOR CITIZEN'
, SYSDATE
, 'FALSE')) PREMIUM_COVERS_SC /* SECTION 80DDB TREATMENT*/
, PAY_IN_TAX_DECLARATION.GET_NUMERIC_VALUE (PAF.ASSIGNMENT_ID
, 'DEDUCTION UNDER SECTION 80DDB'
, 'TREATMENT AMOUNT'
, SYSDATE
, 'FALSE') TREATMENT_AMOUNT
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, PAY_IN_TAX_DECLARATION.GET_VALUE (PAF.ASSIGNMENT_ID
, 'DEDUCTION UNDER SECTION 80DDB'
, 'SENIOR CITIZEN'
, SYSDATE
, 'FALSE')) TREATMENT_COVERS_SC /*OTHER INCOME DETAILS*/
, PAY_IN_TAX_DECLARATION.GET_NUMERIC_VALUE (PAF.ASSIGNMENT_ID
, 'OTHER INCOME'
, 'HOUSE PROPERTY INCOME'
, SYSDATE
, 'FALSE') INCOME_FROM_HOUSE_PROPERTY
, PAY_IN_TAX_DECLARATION.GET_NUMERIC_VALUE (PAF.ASSIGNMENT_ID
, 'OTHER INCOME'
, 'PROFIT
FROM BUSINESS'
, SYSDATE
, 'FALSE') PROFIT_AND_GAIN
, PAY_IN_TAX_DECLARATION.GET_NUMERIC_VALUE (PAF.ASSIGNMENT_ID
, 'OTHER INCOME'
, 'LONG TERM CAPITAL GAIN'
, SYSDATE
, 'FALSE') LONG_TERM_CAPITAL_GAIN
, PAY_IN_TAX_DECLARATION.GET_NUMERIC_VALUE (PAF.ASSIGNMENT_ID
, 'OTHER INCOME'
, 'SHORT TERM CAPITAL GAIN'
, SYSDATE
, 'FALSE') SHORT_TERM_CAPITAL_GAIN
, PAY_IN_TAX_DECLARATION.GET_NUMERIC_VALUE (PAF.ASSIGNMENT_ID
, 'OTHER INCOME'
, 'OTHER SOURCE OF INCOME'
, SYSDATE
, 'FALSE') INCOME_FROM_OTHER_SOURCES
, PAY_IN_TAX_DECLARATION.GET_NUMERIC_VALUE (PAF.ASSIGNMENT_ID
, 'OTHER INCOME'
, 'TDS PAID ON OTHER INCOME'
, SYSDATE
, 'FALSE') TDS_PAID /*OTHERS*/
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 1
, 'DEDUCTION UNDER SECTION 80DD'
, 'ELEMENT ENTRY ID'
, SYSDATE) ELEMENT_ENTRY_ID1
, HR_GENERAL.DECODE_LOOKUP('DISABILITY_CATEGORY'
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 1
, 'DEDUCTION UNDER SECTION 80DD'
, 'DISABILITY TYPE'
, SYSDATE)) DISABILITY_TYPE1
, HR_GENERAL.DECODE_LOOKUP('IN_DISABLE_PERCENTAGE'
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 1
, 'DEDUCTION UNDER SECTION 80DD'
, 'DISABILITY PERCENTAGE'
, SYSDATE)) DISABILITY_PERCENTAGE1
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 1
, 'DEDUCTION UNDER SECTION 80DD'
, 'TREATMENT AMOUNT'
, SYSDATE) TREATMENT_AMOUNT1
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 2
, 'DEDUCTION UNDER SECTION 80DD'
, 'ELEMENT ENTRY ID'
, SYSDATE) ELEMENT_ENTRY_ID2
, HR_GENERAL.DECODE_LOOKUP('DISABILITY_CATEGORY'
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 2
, 'DEDUCTION UNDER SECTION 80DD'
, 'DISABILITY TYPE'
, SYSDATE)) DISABILITY_TYPE2
, HR_GENERAL.DECODE_LOOKUP('IN_DISABLE_PERCENTAGE'
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 2
, 'DEDUCTION UNDER SECTION 80DD'
, 'DISABILITY PERCENTAGE'
, SYSDATE)) DISABILITY_PERCENTAGE2
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 2
, 'DEDUCTION UNDER SECTION 80DD'
, 'TREATMENT AMOUNT'
, SYSDATE) TREATMENT_AMOUNT2
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 1
, 'DEDUCTION UNDER SECTION 80G'
, 'ELEMENT ENTRY ID'
, SYSDATE) ELEMENT_ENTRY_ID1
, PAY_IN_TAX_DECLARATION.GET_DONATION_TYPE( PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 1
, 'DEDUCTION UNDER SECTION 80G'
, 'DONATION TYPE'
, SYSDATE)) DONATION_TYPE1
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 1
, 'DEDUCTION UNDER SECTION 80G'
, 'DONATION AMOUNT'
, SYSDATE) DONATION_AMOUNT1
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 2
, 'DEDUCTION UNDER SECTION 80G'
, 'ELEMENT ENTRY ID'
, SYSDATE) ELEMENT_ENTRY_ID2
, PAY_IN_TAX_DECLARATION.GET_DONATION_TYPE( PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 2
, 'DEDUCTION UNDER SECTION 80G'
, 'DONATION TYPE'
, SYSDATE)) DONATION_TYPE2
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 2
, 'DEDUCTION UNDER SECTION 80G'
, 'DONATION AMOUNT'
, SYSDATE) DONATION_AMOUNT2
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 1
, 'LIFE INSURANCE PREMIUM'
, 'ELEMENT ENTRY ID'
, SYSDATE) ELEMENT_ENTRY_ID1
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 1
, 'LIFE INSURANCE PREMIUM'
, 'PREMIUM PAID'
, SYSDATE) PREMIUM_PAID1
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 1
, 'LIFE INSURANCE PREMIUM'
, 'SUM ASSURED'
, SYSDATE) SUM_ASSURED1
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 2
, 'LIFE INSURANCE PREMIUM'
, 'ELEMENT ENTRY ID'
, SYSDATE) ELEMENT_ENTRY_ID2
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 2
, 'LIFE INSURANCE PREMIUM'
, 'PREMIUM PAID'
, SYSDATE) PREMIUM_PAID2
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 2
, 'LIFE INSURANCE PREMIUM'
, 'SUM ASSURED'
, SYSDATE) SUM_ASSURED2
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 3
, 'LIFE INSURANCE PREMIUM'
, 'ELEMENT ENTRY ID'
, SYSDATE) ELEMENT_ENTRY_ID3
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 3
, 'LIFE INSURANCE PREMIUM'
, 'PREMIUM PAID'
, SYSDATE) PREMIUM_PAID3
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 3
, 'LIFE INSURANCE PREMIUM'
, 'SUM ASSURED'
, SYSDATE) SUM_ASSURED3
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 4
, 'LIFE INSURANCE PREMIUM'
, 'ELEMENT ENTRY ID'
, SYSDATE) ELEMENT_ENTRY_ID4
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 4
, 'LIFE INSURANCE PREMIUM'
, 'PREMIUM PAID'
, SYSDATE) PREMIUM_PAID4
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 4
, 'LIFE INSURANCE PREMIUM'
, 'SUM ASSURED'
, SYSDATE) SUM_ASSURED4
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 5
, 'LIFE INSURANCE PREMIUM'
, 'ELEMENT ENTRY ID'
, SYSDATE) ELEMENT_ENTRY_ID5
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 5
, 'LIFE INSURANCE PREMIUM'
, 'PREMIUM PAID'
, SYSDATE) PREMIUM_PAID5
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 5
, 'LIFE INSURANCE PREMIUM'
, 'SUM ASSURED'
, SYSDATE) SUM_ASSURED5
, PAE.AEI_INFORMATION3
FROM PER_PEOPLE_F PPF
, PER_PERSON_TYPES PTYPES
, PER_ASSIGNMENTS_F PAF
, HR_ORGANIZATION_UNITS HOU
, HR_ORGANIZATION_INFORMATION HOI
, HR_ORGANIZATION_UNITS ITAX_ORG
, HR_ORGANIZATION_INFORMATION ITAX
, HR_SOFT_CODING_KEYFLEX SCL
, PER_ASSIGNMENT_EXTRA_INFO PAE
WHERE PPF.PERSON_ID = PAF.PERSON_ID
AND PTYPES.SYSTEM_PERSON_TYPE IN ('EMP'
, 'EX_EMP'
, 'APL_EX_EMP'
, 'EMP_APL'
, 'EX_EMP_APL')
AND PTYPES.PERSON_TYPE_ID = PPF.PERSON_TYPE_ID
AND PAF.ASSIGNMENT_ID = PAE.ASSIGNMENT_ID(+)
AND HOU.ORGANIZATION_ID = PAF.ORGANIZATION_ID
AND PPF.BUSINESS_GROUP_ID = PAF.BUSINESS_GROUP_ID
AND HOU.ORGANIZATION_ID = HOI.ORGANIZATION_ID
AND HOI.ORG_INFORMATION1 IN ( 'HR_ORG'
, 'HR_BG')
AND HOI.ORG_INFORMATION2 = 'Y'
AND SCL.SOFT_CODING_KEYFLEX_ID = PAF.SOFT_CODING_KEYFLEX_ID
AND TO_CHAR(ITAX_ORG.ORGANIZATION_ID) = SCL.SEGMENT1
AND ITAX_ORG.BUSINESS_GROUP_ID = PPF.BUSINESS_GROUP_ID
AND ITAX_ORG.ORGANIZATION_ID = ITAX.ORGANIZATION_ID
AND ITAX.ORG_INFORMATION_CONTEXT = 'PER_IN_INCOME_TAX_DF'
AND SYSDATE BETWEEN PPF.EFFECTIVE_START_DATE
AND PPF.EFFECTIVE_END_DATE
AND SYSDATE BETWEEN PAF.EFFECTIVE_START_DATE
AND PAF.EFFECTIVE_END_DATE
AND 'PER_IN_TAX_DECL_DETAILS' = PAE.AEI_INFORMATION_CATEGORY(+)
AND (NVL(PAE.ASSIGNMENT_EXTRA_INFO_ID
, 1)) = NVL((SELECT MAX(ASSIGNMENT_EXTRA_INFO_ID)
FROM PER_ASSIGNMENT_EXTRA_INFO
WHERE ASSIGNMENT_ID=PAF.ASSIGNMENT_ID)
, 1)

Columns

Name
PERSON_ID
FULL_NAME
EMPLOYEE_NUMBER
ASSIGNMENT_ID
ASSIGNMENT_NUMBER
EFFECTIVE_DATE
DEPARTMENT
LAST_UPDATED_DATE
ORGANIZATION_ID
BUSINESS_GROUP_ID
START_DATE
GRADE_ID
JOB_ID
POSITION_ID
TAX_AREA_NUMBER
APPROVAL_STATUS
TAX_YEAR
APRIL
MAY
JUNE
JULY
AUGUST
SEPTEMBER
OCTOBER
NOVEMBER
DECEMBER
JANUARY
FEBRUARY
MARCH
CCE_EE_ID1
COMPONENT1
INVESTMENT_AMOUNT1
CCE_EE_ID2
COMPONENT2
INVESTMENT_AMOUNT2
CCE_EE_ID3
COMPONENT3
INVESTMENT_AMOUNT3
CCE_EE_ID4
COMPONENT4
INVESTMENT_AMOUNT4
CCE_EE_ID5
COMPONENT5
INVESTMENT_AMOUNT5
CCE_EE_ID6
COMPONENT6
INVESTMENT_AMOUNT6
CCE_EE_ID7
COMPONENT7
INVESTMENT_AMOUNT7
CCE_EE_ID8
COMPONENT8
INVESTMENT_AMOUNT8
CCE_EE_ID9
COMPONENT9
INVESTMENT_AMOUNT9
CCE_EE_ID10
COMPONENT10
INVESTMENT_AMOUNT10
CCE_EE_ID11
COMPONENT11
INVESTMENT_AMOUNT11
CCE_EE_ID12
COMPONENT12
INVESTMENT_AMOUNT12
CCE_EE_ID13
COMPONENT13
INVESTMENT_AMOUNT13
CCE_EE_ID14
COMPONENT14
INVESTMENT_AMOUNT14
CCE_EE_ID15
COMPONENT15
INVESTMENT_AMOUNT15
CCE_EE_ID16
COMPONENT16
INVESTMENT_AMOUNT16
CCE_EE_ID17
COMPONENT17
INVESTMENT_AMOUNT17
CCE_EE_ID18
COMPONENT18
INVESTMENT_AMOUNT18
CCE_EE_ID19
COMPONENT19
INVESTMENT_AMOUNT19
CCE_EE_ID20
COMPONENT20
INVESTMENT_AMOUNT20
CCE_EE_ID21
COMPONENT21
INVESTMENT_AMOUNT21
HIGHER_EDUCATION_LOAN
DONATION_FOR_RESEARCH
CLAIM_EXEMPTION_SEC_80GG
PREMIUM_AMOUNT
PREMIUM_COVERS_SC
TREATMENT_AMOUNT
TREATMENT_COVERS_SC
INCOME_FROM_HOUSE_PROPERTY
PROFIT_AND_GAIN
LONG_TERM_CAPITAL_GAIN
SHORT_TERM_CAPITAL_GAIN
INCOME_FROM_OTHER_SOURCES
TDS_PAID
DISEASE_ENTRY_ID1
DISABILITY_TYPE1
DISABILITY_PERCENTAGE1
TREATMENT_AMOUNT1
DISEASE_ENTRY_ID2
DISABILITY_TYPE2
DISABILITY_PERCENTAGE2
TREATMENT_AMOUNT2
DONATION_ENTRY_ID1
DONATION_TYPE1
DONATION_AMOUNT1
DONATION_ENTRY_ID2
DONATION_TYPE2
DONATION_AMOUNT2
LIC_ENTRY_ID1
PREMIUM_PAID1
SUM_ASSURED1
LIC_ENTRY_ID2
PREMIUM_PAID2
SUM_ASSURED2
LIC_ENTRY_ID3
PREMIUM_PAID3
SUM_ASSURED3
LIC_ENTRY_ID4
PREMIUM_PAID4
SUM_ASSURED4
LIC_ENTRY_ID5
PREMIUM_PAID5
SUM_ASSURED5
COMMENT_TEXT