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.

VIEW: APPS.PAY_IN_TAX_DECLARATIONS_V

Source

View Text - Preformatted


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 , PAY_IN_TAX_DECLARATION.get_numeric_value (paf.assignment_id, 'Deduction under Section 80D', 'Premium for Parents', sysdate, 'FALSE') Parent_Premium , hr_general.decode_lookup('YES_NO', PAY_IN_TAX_DECLARATION.get_value (paf.assignment_id, 'Deduction under Section 80D', 'Parent Senior Citizen', sysdate, 'FALSE')) Parent_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)

View Text - HTML Formatted

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
, PAY_IN_TAX_DECLARATION.GET_NUMERIC_VALUE (PAF.ASSIGNMENT_ID
, 'DEDUCTION UNDER SECTION 80D'
, 'PREMIUM FOR PARENTS'
, SYSDATE
, 'FALSE') PARENT_PREMIUM
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, PAY_IN_TAX_DECLARATION.GET_VALUE (PAF.ASSIGNMENT_ID
, 'DEDUCTION UNDER SECTION 80D'
, 'PARENT SENIOR CITIZEN'
, SYSDATE
, 'FALSE')) PARENT_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)