VIEW: APPS.PAY_IN_TAX_DECLARATIONS_V

Source

View Text - Preformatted

SELECT 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, 1, 'Life Insurance Premium', 'Policy Number', sysdate) Policy_Number1 , 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, 2, 'Life Insurance Premium', 'Policy Number', sysdate) Policy_Number2 , 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, 3, 'Life Insurance Premium', 'Policy Number', sysdate) Policy_Number3 , 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, 4, 'Life Insurance Premium', 'Policy Number', sysdate) Policy_Number4 , 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 , PAY_IN_TAX_DECLARATION.get_value(paf.assignment_id, 5, 'Life Insurance Premium', 'Policy Number', sysdate) Policy_Number5 , PAY_IN_TAX_DECLARATION.get_value(paf.assignment_id, 6, 'Life Insurance Premium', 'Element Entry Id', sysdate) Element_Entry_ID6 , PAY_IN_TAX_DECLARATION.get_value(paf.assignment_id, 6, 'Life Insurance Premium', 'Premium Paid', sysdate) Premium_Paid6 , PAY_IN_TAX_DECLARATION.get_value(paf.assignment_id, 6, 'Life Insurance Premium', 'Sum Assured', sysdate) Sum_Assured6 , PAY_IN_TAX_DECLARATION.get_value(paf.assignment_id, 6, 'Life Insurance Premium', 'Policy Number', sysdate) Policy_Number6 , PAY_IN_TAX_DECLARATION.get_value(paf.assignment_id, 7, 'Life Insurance Premium', 'Element Entry Id', sysdate) Element_Entry_ID7 , PAY_IN_TAX_DECLARATION.get_value(paf.assignment_id, 7, 'Life Insurance Premium', 'Premium Paid', sysdate) Premium_Paid7 , PAY_IN_TAX_DECLARATION.get_value(paf.assignment_id, 7, 'Life Insurance Premium', 'Sum Assured', sysdate) Sum_Assured7 , PAY_IN_TAX_DECLARATION.get_value(paf.assignment_id, 7, 'Life Insurance Premium', 'Policy Number', sysdate) Policy_Number7 , PAY_IN_TAX_DECLARATION.get_value(paf.assignment_id, 8, 'Life Insurance Premium', 'Element Entry Id', sysdate) Element_Entry_ID8 , PAY_IN_TAX_DECLARATION.get_value(paf.assignment_id, 8, 'Life Insurance Premium', 'Premium Paid', sysdate) Premium_Paid8 , PAY_IN_TAX_DECLARATION.get_value(paf.assignment_id, 8, 'Life Insurance Premium', 'Sum Assured', sysdate) Sum_Assured8 , PAY_IN_TAX_DECLARATION.get_value(paf.assignment_id, 8, 'Life Insurance Premium', 'Policy Number', sysdate) Policy_Number8 , PAY_IN_TAX_DECLARATION.get_value(paf.assignment_id, 9, 'Life Insurance Premium', 'Element Entry Id', sysdate) Element_Entry_ID9 , PAY_IN_TAX_DECLARATION.get_value(paf.assignment_id, 9, 'Life Insurance Premium', 'Premium Paid', sysdate) Premium_Paid9 , PAY_IN_TAX_DECLARATION.get_value(paf.assignment_id, 9, 'Life Insurance Premium', 'Sum Assured', sysdate) Sum_Assured9 , PAY_IN_TAX_DECLARATION.get_value(paf.assignment_id, 9, 'Life Insurance Premium', 'Policy Number', sysdate) Policy_Number9 , PAY_IN_TAX_DECLARATION.get_value(paf.assignment_id, 10, 'Life Insurance Premium', 'Element Entry Id', sysdate) Element_Entry_ID10 , PAY_IN_TAX_DECLARATION.get_value(paf.assignment_id, 10, 'Life Insurance Premium', 'Premium Paid', sysdate) Premium_Paid10 , PAY_IN_TAX_DECLARATION.get_value(paf.assignment_id, 10, 'Life Insurance Premium', 'Sum Assured', sysdate) Sum_Assured10 , PAY_IN_TAX_DECLARATION.get_value(paf.assignment_id, 10, 'Life Insurance Premium', 'Policy Number', sysdate) Policy_Number10 , PAY_IN_TAX_DECLARATION.get_value(paf.assignment_id, 11, 'Life Insurance Premium', 'Element Entry Id', sysdate) Element_Entry_ID11 , PAY_IN_TAX_DECLARATION.get_value(paf.assignment_id, 11, 'Life Insurance Premium', 'Premium Paid', sysdate) Premium_Paid11 , PAY_IN_TAX_DECLARATION.get_value(paf.assignment_id, 11, 'Life Insurance Premium', 'Sum Assured', sysdate) Sum_Assured11 , PAY_IN_TAX_DECLARATION.get_value(paf.assignment_id, 11, 'Life Insurance Premium', 'Policy Number', sysdate) Policy_Number11 , PAY_IN_TAX_DECLARATION.get_value(paf.assignment_id, 12, 'Life Insurance Premium', 'Element Entry Id', sysdate) Element_Entry_ID12 , PAY_IN_TAX_DECLARATION.get_value(paf.assignment_id, 12, 'Life Insurance Premium', 'Premium Paid', sysdate) Premium_Paid12 , PAY_IN_TAX_DECLARATION.get_value(paf.assignment_id, 12, 'Life Insurance Premium', 'Sum Assured', sysdate) Sum_Assured12 , PAY_IN_TAX_DECLARATION.get_value(paf.assignment_id, 12, 'Life Insurance Premium', 'Policy Number', sysdate) Policy_Number12 , pae.aei_information3 , PAY_IN_TAX_DECLARATION.get_numeric_value (paf.assignment_id, 'Deduction under Section 80CCF', 'Investment Amount', sysdate, 'FALSE') ISB_Amount , PAY_IN_TAX_DECLARATION.get_numeric_value (paf.assignment_id, 'PF Information', 'EE Voluntary PF Amount', sysdate, 'FALSE') VPF_Amount , PAY_IN_TAX_DECLARATION.get_numeric_value (paf.assignment_id, 'PF Information', 'EE Voluntary PF Percent', sysdate, 'FALSE') VPF_Percent , PAY_IN_TAX_DECLARATION.get_value(paf.assignment_id, 22, 'Deduction under Section 80CCE', 'Element Entry Id', sysdate) EE_ID22 , PAY_IN_TAX_DECLARATION.get_value(paf.assignment_id, 22, 'Deduction under Section 80CCE', 'Component Name', sysdate) Comp22 , PAY_IN_TAX_DECLARATION.get_value(paf.assignment_id, 22, 'Deduction under Section 80CCE', 'Investment Amount', sysdate) Inv22 , PAY_IN_TAX_DECLARATION.get_value(paf.assignment_id, 23, 'Deduction under Section 80CCE', 'Element Entry Id', sysdate) EE_ID23 , PAY_IN_TAX_DECLARATION.get_value(paf.assignment_id, 23, 'Deduction under Section 80CCE', 'Component Name', sysdate) Comp23 , PAY_IN_TAX_DECLARATION.get_value(paf.assignment_id, 23, 'Deduction under Section 80CCE', 'Investment Amount', sysdate) Inv23 ,PAY_IN_TAX_DECLARATION.get_value(paf.assignment_id, 1, 'Life Insurance Premium', 'Policy Start Date', sysdate) Policy_Start_Date1 ,PAY_IN_TAX_DECLARATION.get_value(paf.assignment_id, 2, 'Life Insurance Premium', 'Policy Start Date', sysdate) Policy_Start_Date2 ,PAY_IN_TAX_DECLARATION.get_value(paf.assignment_id, 3, 'Life Insurance Premium', 'Policy Start Date', sysdate) Policy_Start_Date3 ,PAY_IN_TAX_DECLARATION.get_value(paf.assignment_id, 4, 'Life Insurance Premium', 'Policy Start Date', sysdate) Policy_Start_Date4 ,PAY_IN_TAX_DECLARATION.get_value(paf.assignment_id, 5, 'Life Insurance Premium', 'Policy Start Date', sysdate) Policy_Start_Date5 ,PAY_IN_TAX_DECLARATION.get_value(paf.assignment_id, 6, 'Life Insurance Premium', 'Policy Start Date', sysdate) Policy_Start_Date6 ,PAY_IN_TAX_DECLARATION.get_value(paf.assignment_id, 7, 'Life Insurance Premium', 'Policy Start Date', sysdate) Policy_Start_Date7 ,PAY_IN_TAX_DECLARATION.get_value(paf.assignment_id, 8, 'Life Insurance Premium', 'Policy Start Date', sysdate) Policy_Start_Date8 ,PAY_IN_TAX_DECLARATION.get_value(paf.assignment_id, 9, 'Life Insurance Premium', 'Policy Start Date', sysdate) Policy_Start_Date9 ,PAY_IN_TAX_DECLARATION.get_value(paf.assignment_id, 10, 'Life Insurance Premium', 'Policy Start Date', sysdate) Policy_Start_Date10 ,PAY_IN_TAX_DECLARATION.get_value(paf.assignment_id, 11, 'Life Insurance Premium', 'Policy Start Date', sysdate) Policy_Start_Date11 ,PAY_IN_TAX_DECLARATION.get_value(paf.assignment_id, 12, 'Life Insurance Premium', 'Policy Start Date', sysdate) Policy_Start_Date12 ,PAY_IN_TAX_DECLARATION.get_numeric_value (paf.assignment_id, 'Deduction under Section 80D', 'Health Checkup for Self', sysdate, 'FALSE') Health_checkup ,PAY_IN_TAX_DECLARATION.get_numeric_value (paf.assignment_id, 'Deduction under Section 80D', 'Health Checkup for Parents', sysdate, 'FALSE')Health_Checkup_For_Parents ,PAY_IN_TAX_DECLARATION.get_numeric_value (paf.assignment_id, 'Other Income', 'Interest On Deposits', sysdate, 'FALSE') INTEREST_ON_DEPOSIT ,TO_CHAR(fnd_date.canonical_to_date(PAY_IN_TAX_DECLARATION.get_value(paf.assignment_id,'Deduction under Section 80CCG', 'Date of Investment', sysdate,'FALSE')),'MM/DD/YYYY') SEC_80CCG_DATE_OF_INVESTMENT ,PAY_IN_TAX_DECLARATION.get_numeric_value(paf.assignment_id,'Deduction under Section 80CCG', 'Investment Amount', sysdate,'FALSE') SEC_80CCG_INVESTMENT_AMOUNT FROM per_people_f ppf , per_person_types ptypes , per_assignments_f paf , hr_organization_units hou , 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 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 SYSDATE between hou.date_from and nvl(hou.date_to,to_date('31-12-4712','DD-MM-YYYY')) AND SYSDATE between itax_org.date_from and nvl(itax_org.date_to,to_date('31-12-4712','DD-MM-YYYY')) AND itax_org.organization_id = itax.organization_id AND hou.business_group_id = itax_org.business_group_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 AND aei_information_category ='PER_IN_TAX_DECL_DETAILS'),1)

View Text - HTML Formatted

SELECT 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
, 1
, 'LIFE INSURANCE PREMIUM'
, 'POLICY NUMBER'
, SYSDATE) POLICY_NUMBER1
, 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
, 2
, 'LIFE INSURANCE PREMIUM'
, 'POLICY NUMBER'
, SYSDATE) POLICY_NUMBER2
, 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
, 3
, 'LIFE INSURANCE PREMIUM'
, 'POLICY NUMBER'
, SYSDATE) POLICY_NUMBER3
, 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
, 4
, 'LIFE INSURANCE PREMIUM'
, 'POLICY NUMBER'
, SYSDATE) POLICY_NUMBER4
, 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
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 5
, 'LIFE INSURANCE PREMIUM'
, 'POLICY NUMBER'
, SYSDATE) POLICY_NUMBER5
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 6
, 'LIFE INSURANCE PREMIUM'
, 'ELEMENT ENTRY ID'
, SYSDATE) ELEMENT_ENTRY_ID6
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 6
, 'LIFE INSURANCE PREMIUM'
, 'PREMIUM PAID'
, SYSDATE) PREMIUM_PAID6
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 6
, 'LIFE INSURANCE PREMIUM'
, 'SUM ASSURED'
, SYSDATE) SUM_ASSURED6
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 6
, 'LIFE INSURANCE PREMIUM'
, 'POLICY NUMBER'
, SYSDATE) POLICY_NUMBER6
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 7
, 'LIFE INSURANCE PREMIUM'
, 'ELEMENT ENTRY ID'
, SYSDATE) ELEMENT_ENTRY_ID7
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 7
, 'LIFE INSURANCE PREMIUM'
, 'PREMIUM PAID'
, SYSDATE) PREMIUM_PAID7
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 7
, 'LIFE INSURANCE PREMIUM'
, 'SUM ASSURED'
, SYSDATE) SUM_ASSURED7
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 7
, 'LIFE INSURANCE PREMIUM'
, 'POLICY NUMBER'
, SYSDATE) POLICY_NUMBER7
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 8
, 'LIFE INSURANCE PREMIUM'
, 'ELEMENT ENTRY ID'
, SYSDATE) ELEMENT_ENTRY_ID8
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 8
, 'LIFE INSURANCE PREMIUM'
, 'PREMIUM PAID'
, SYSDATE) PREMIUM_PAID8
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 8
, 'LIFE INSURANCE PREMIUM'
, 'SUM ASSURED'
, SYSDATE) SUM_ASSURED8
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 8
, 'LIFE INSURANCE PREMIUM'
, 'POLICY NUMBER'
, SYSDATE) POLICY_NUMBER8
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 9
, 'LIFE INSURANCE PREMIUM'
, 'ELEMENT ENTRY ID'
, SYSDATE) ELEMENT_ENTRY_ID9
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 9
, 'LIFE INSURANCE PREMIUM'
, 'PREMIUM PAID'
, SYSDATE) PREMIUM_PAID9
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 9
, 'LIFE INSURANCE PREMIUM'
, 'SUM ASSURED'
, SYSDATE) SUM_ASSURED9
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 9
, 'LIFE INSURANCE PREMIUM'
, 'POLICY NUMBER'
, SYSDATE) POLICY_NUMBER9
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 10
, 'LIFE INSURANCE PREMIUM'
, 'ELEMENT ENTRY ID'
, SYSDATE) ELEMENT_ENTRY_ID10
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 10
, 'LIFE INSURANCE PREMIUM'
, 'PREMIUM PAID'
, SYSDATE) PREMIUM_PAID10
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 10
, 'LIFE INSURANCE PREMIUM'
, 'SUM ASSURED'
, SYSDATE) SUM_ASSURED10
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 10
, 'LIFE INSURANCE PREMIUM'
, 'POLICY NUMBER'
, SYSDATE) POLICY_NUMBER10
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 11
, 'LIFE INSURANCE PREMIUM'
, 'ELEMENT ENTRY ID'
, SYSDATE) ELEMENT_ENTRY_ID11
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 11
, 'LIFE INSURANCE PREMIUM'
, 'PREMIUM PAID'
, SYSDATE) PREMIUM_PAID11
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 11
, 'LIFE INSURANCE PREMIUM'
, 'SUM ASSURED'
, SYSDATE) SUM_ASSURED11
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 11
, 'LIFE INSURANCE PREMIUM'
, 'POLICY NUMBER'
, SYSDATE) POLICY_NUMBER11
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 12
, 'LIFE INSURANCE PREMIUM'
, 'ELEMENT ENTRY ID'
, SYSDATE) ELEMENT_ENTRY_ID12
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 12
, 'LIFE INSURANCE PREMIUM'
, 'PREMIUM PAID'
, SYSDATE) PREMIUM_PAID12
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 12
, 'LIFE INSURANCE PREMIUM'
, 'SUM ASSURED'
, SYSDATE) SUM_ASSURED12
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 12
, 'LIFE INSURANCE PREMIUM'
, 'POLICY NUMBER'
, SYSDATE) POLICY_NUMBER12
, PAE.AEI_INFORMATION3
, PAY_IN_TAX_DECLARATION.GET_NUMERIC_VALUE (PAF.ASSIGNMENT_ID
, 'DEDUCTION UNDER SECTION 80CCF'
, 'INVESTMENT AMOUNT'
, SYSDATE
, 'FALSE') ISB_AMOUNT
, PAY_IN_TAX_DECLARATION.GET_NUMERIC_VALUE (PAF.ASSIGNMENT_ID
, 'PF INFORMATION'
, 'EE VOLUNTARY PF AMOUNT'
, SYSDATE
, 'FALSE') VPF_AMOUNT
, PAY_IN_TAX_DECLARATION.GET_NUMERIC_VALUE (PAF.ASSIGNMENT_ID
, 'PF INFORMATION'
, 'EE VOLUNTARY PF PERCENT'
, SYSDATE
, 'FALSE') VPF_PERCENT
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 22
, 'DEDUCTION UNDER SECTION 80CCE'
, 'ELEMENT ENTRY ID'
, SYSDATE) EE_ID22
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 22
, 'DEDUCTION UNDER SECTION 80CCE'
, 'COMPONENT NAME'
, SYSDATE) COMP22
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 22
, 'DEDUCTION UNDER SECTION 80CCE'
, 'INVESTMENT AMOUNT'
, SYSDATE) INV22
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 23
, 'DEDUCTION UNDER SECTION 80CCE'
, 'ELEMENT ENTRY ID'
, SYSDATE) EE_ID23
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 23
, 'DEDUCTION UNDER SECTION 80CCE'
, 'COMPONENT NAME'
, SYSDATE) COMP23
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 23
, 'DEDUCTION UNDER SECTION 80CCE'
, 'INVESTMENT AMOUNT'
, SYSDATE) INV23
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 1
, 'LIFE INSURANCE PREMIUM'
, 'POLICY START DATE'
, SYSDATE) POLICY_START_DATE1
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 2
, 'LIFE INSURANCE PREMIUM'
, 'POLICY START DATE'
, SYSDATE) POLICY_START_DATE2
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 3
, 'LIFE INSURANCE PREMIUM'
, 'POLICY START DATE'
, SYSDATE) POLICY_START_DATE3
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 4
, 'LIFE INSURANCE PREMIUM'
, 'POLICY START DATE'
, SYSDATE) POLICY_START_DATE4
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 5
, 'LIFE INSURANCE PREMIUM'
, 'POLICY START DATE'
, SYSDATE) POLICY_START_DATE5
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 6
, 'LIFE INSURANCE PREMIUM'
, 'POLICY START DATE'
, SYSDATE) POLICY_START_DATE6
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 7
, 'LIFE INSURANCE PREMIUM'
, 'POLICY START DATE'
, SYSDATE) POLICY_START_DATE7
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 8
, 'LIFE INSURANCE PREMIUM'
, 'POLICY START DATE'
, SYSDATE) POLICY_START_DATE8
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 9
, 'LIFE INSURANCE PREMIUM'
, 'POLICY START DATE'
, SYSDATE) POLICY_START_DATE9
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 10
, 'LIFE INSURANCE PREMIUM'
, 'POLICY START DATE'
, SYSDATE) POLICY_START_DATE10
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 11
, 'LIFE INSURANCE PREMIUM'
, 'POLICY START DATE'
, SYSDATE) POLICY_START_DATE11
, PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 12
, 'LIFE INSURANCE PREMIUM'
, 'POLICY START DATE'
, SYSDATE) POLICY_START_DATE12
, PAY_IN_TAX_DECLARATION.GET_NUMERIC_VALUE (PAF.ASSIGNMENT_ID
, 'DEDUCTION UNDER SECTION 80D'
, 'HEALTH CHECKUP FOR SELF'
, SYSDATE
, 'FALSE') HEALTH_CHECKUP
, PAY_IN_TAX_DECLARATION.GET_NUMERIC_VALUE (PAF.ASSIGNMENT_ID
, 'DEDUCTION UNDER SECTION 80D'
, 'HEALTH CHECKUP FOR PARENTS'
, SYSDATE
, 'FALSE')HEALTH_CHECKUP_FOR_PARENTS
, PAY_IN_TAX_DECLARATION.GET_NUMERIC_VALUE (PAF.ASSIGNMENT_ID
, 'OTHER INCOME'
, 'INTEREST ON DEPOSITS'
, SYSDATE
, 'FALSE') INTEREST_ON_DEPOSIT
, TO_CHAR(FND_DATE.CANONICAL_TO_DATE(PAY_IN_TAX_DECLARATION.GET_VALUE(PAF.ASSIGNMENT_ID
, 'DEDUCTION UNDER SECTION 80CCG'
, 'DATE OF INVESTMENT'
, SYSDATE
, 'FALSE'))
, 'MM/DD/YYYY') SEC_80CCG_DATE_OF_INVESTMENT
, PAY_IN_TAX_DECLARATION.GET_NUMERIC_VALUE(PAF.ASSIGNMENT_ID
, 'DEDUCTION UNDER SECTION 80CCG'
, 'INVESTMENT AMOUNT'
, SYSDATE
, 'FALSE') SEC_80CCG_INVESTMENT_AMOUNT
FROM PER_PEOPLE_F PPF
, PER_PERSON_TYPES PTYPES
, PER_ASSIGNMENTS_F PAF
, HR_ORGANIZATION_UNITS HOU
, 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 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 SYSDATE BETWEEN HOU.DATE_FROM
AND NVL(HOU.DATE_TO
, TO_DATE('31-12-4712'
, 'DD-MM-YYYY'))
AND SYSDATE BETWEEN ITAX_ORG.DATE_FROM
AND NVL(ITAX_ORG.DATE_TO
, TO_DATE('31-12-4712'
, 'DD-MM-YYYY'))
AND ITAX_ORG.ORGANIZATION_ID = ITAX.ORGANIZATION_ID
AND HOU.BUSINESS_GROUP_ID = ITAX_ORG.BUSINESS_GROUP_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
AND AEI_INFORMATION_CATEGORY ='PER_IN_TAX_DECL_DETAILS')
, 1)