132: pai.action_information8 Declaration_Due_Date,
133: pai.action_information6 Administrative_Code,
134: pai.action_information7 Information,
135: pai1.action_information3 Organization_Number,
136: fnd_number.canonical_to_number(pai1.action_information4) Reduction,
137: fnd_number.canonical_to_number(pai1.action_information7) Code,
138: fnd_number.canonical_to_number(pai1.action_information8) Canada,
139: fnd_number.canonical_to_number(pai1.action_information9) Special_Canada,
140: -- fnd_number.canonical_to_number(pai1.action_information10) Comp_Support, -- EOY 2008
133: pai.action_information6 Administrative_Code,
134: pai.action_information7 Information,
135: pai1.action_information3 Organization_Number,
136: fnd_number.canonical_to_number(pai1.action_information4) Reduction,
137: fnd_number.canonical_to_number(pai1.action_information7) Code,
138: fnd_number.canonical_to_number(pai1.action_information8) Canada,
139: fnd_number.canonical_to_number(pai1.action_information9) Special_Canada,
140: -- fnd_number.canonical_to_number(pai1.action_information10) Comp_Support, -- EOY 2008
141: -- fnd_number.canonical_to_number(pai1.action_information11) Comp_Support_5, -- EOY 2008
134: pai.action_information7 Information,
135: pai1.action_information3 Organization_Number,
136: fnd_number.canonical_to_number(pai1.action_information4) Reduction,
137: fnd_number.canonical_to_number(pai1.action_information7) Code,
138: fnd_number.canonical_to_number(pai1.action_information8) Canada,
139: fnd_number.canonical_to_number(pai1.action_information9) Special_Canada,
140: -- fnd_number.canonical_to_number(pai1.action_information10) Comp_Support, -- EOY 2008
141: -- fnd_number.canonical_to_number(pai1.action_information11) Comp_Support_5, -- EOY 2008
142: fnd_number.canonical_to_number(pai1.action_information12) Ext_Comp_Support,
135: pai1.action_information3 Organization_Number,
136: fnd_number.canonical_to_number(pai1.action_information4) Reduction,
137: fnd_number.canonical_to_number(pai1.action_information7) Code,
138: fnd_number.canonical_to_number(pai1.action_information8) Canada,
139: fnd_number.canonical_to_number(pai1.action_information9) Special_Canada,
140: -- fnd_number.canonical_to_number(pai1.action_information10) Comp_Support, -- EOY 2008
141: -- fnd_number.canonical_to_number(pai1.action_information11) Comp_Support_5, -- EOY 2008
142: fnd_number.canonical_to_number(pai1.action_information12) Ext_Comp_Support,
143: fnd_number.canonical_to_number(pai1.action_information13) Ext_Comp_Support_10,
136: fnd_number.canonical_to_number(pai1.action_information4) Reduction,
137: fnd_number.canonical_to_number(pai1.action_information7) Code,
138: fnd_number.canonical_to_number(pai1.action_information8) Canada,
139: fnd_number.canonical_to_number(pai1.action_information9) Special_Canada,
140: -- fnd_number.canonical_to_number(pai1.action_information10) Comp_Support, -- EOY 2008
141: -- fnd_number.canonical_to_number(pai1.action_information11) Comp_Support_5, -- EOY 2008
142: fnd_number.canonical_to_number(pai1.action_information12) Ext_Comp_Support,
143: fnd_number.canonical_to_number(pai1.action_information13) Ext_Comp_Support_10,
144: fnd_number.canonical_to_number(pai1.action_information14) Pension,
137: fnd_number.canonical_to_number(pai1.action_information7) Code,
138: fnd_number.canonical_to_number(pai1.action_information8) Canada,
139: fnd_number.canonical_to_number(pai1.action_information9) Special_Canada,
140: -- fnd_number.canonical_to_number(pai1.action_information10) Comp_Support, -- EOY 2008
141: -- fnd_number.canonical_to_number(pai1.action_information11) Comp_Support_5, -- EOY 2008
142: fnd_number.canonical_to_number(pai1.action_information12) Ext_Comp_Support,
143: fnd_number.canonical_to_number(pai1.action_information13) Ext_Comp_Support_10,
144: fnd_number.canonical_to_number(pai1.action_information14) Pension,
145: fnd_number.canonical_to_number(pai1.action_information15) Ded_Pension,
138: fnd_number.canonical_to_number(pai1.action_information8) Canada,
139: fnd_number.canonical_to_number(pai1.action_information9) Special_Canada,
140: -- fnd_number.canonical_to_number(pai1.action_information10) Comp_Support, -- EOY 2008
141: -- fnd_number.canonical_to_number(pai1.action_information11) Comp_Support_5, -- EOY 2008
142: fnd_number.canonical_to_number(pai1.action_information12) Ext_Comp_Support,
143: fnd_number.canonical_to_number(pai1.action_information13) Ext_Comp_Support_10,
144: fnd_number.canonical_to_number(pai1.action_information14) Pension,
145: fnd_number.canonical_to_number(pai1.action_information15) Ded_Pension,
146: fnd_number.canonical_to_number(pai1.action_information16) Interest,
139: fnd_number.canonical_to_number(pai1.action_information9) Special_Canada,
140: -- fnd_number.canonical_to_number(pai1.action_information10) Comp_Support, -- EOY 2008
141: -- fnd_number.canonical_to_number(pai1.action_information11) Comp_Support_5, -- EOY 2008
142: fnd_number.canonical_to_number(pai1.action_information12) Ext_Comp_Support,
143: fnd_number.canonical_to_number(pai1.action_information13) Ext_Comp_Support_10,
144: fnd_number.canonical_to_number(pai1.action_information14) Pension,
145: fnd_number.canonical_to_number(pai1.action_information15) Ded_Pension,
146: fnd_number.canonical_to_number(pai1.action_information16) Interest,
147: fnd_number.canonical_to_number(pai1.action_information17) Ded_Interest,
140: -- fnd_number.canonical_to_number(pai1.action_information10) Comp_Support, -- EOY 2008
141: -- fnd_number.canonical_to_number(pai1.action_information11) Comp_Support_5, -- EOY 2008
142: fnd_number.canonical_to_number(pai1.action_information12) Ext_Comp_Support,
143: fnd_number.canonical_to_number(pai1.action_information13) Ext_Comp_Support_10,
144: fnd_number.canonical_to_number(pai1.action_information14) Pension,
145: fnd_number.canonical_to_number(pai1.action_information15) Ded_Pension,
146: fnd_number.canonical_to_number(pai1.action_information16) Interest,
147: fnd_number.canonical_to_number(pai1.action_information17) Ded_Interest,
148: pai1.action_information18 Contact,
141: -- fnd_number.canonical_to_number(pai1.action_information11) Comp_Support_5, -- EOY 2008
142: fnd_number.canonical_to_number(pai1.action_information12) Ext_Comp_Support,
143: fnd_number.canonical_to_number(pai1.action_information13) Ext_Comp_Support_10,
144: fnd_number.canonical_to_number(pai1.action_information14) Pension,
145: fnd_number.canonical_to_number(pai1.action_information15) Ded_Pension,
146: fnd_number.canonical_to_number(pai1.action_information16) Interest,
147: fnd_number.canonical_to_number(pai1.action_information17) Ded_Interest,
148: pai1.action_information18 Contact,
149: pai1.action_information19 Phone,
142: fnd_number.canonical_to_number(pai1.action_information12) Ext_Comp_Support,
143: fnd_number.canonical_to_number(pai1.action_information13) Ext_Comp_Support_10,
144: fnd_number.canonical_to_number(pai1.action_information14) Pension,
145: fnd_number.canonical_to_number(pai1.action_information15) Ded_Pension,
146: fnd_number.canonical_to_number(pai1.action_information16) Interest,
147: fnd_number.canonical_to_number(pai1.action_information17) Ded_Interest,
148: pai1.action_information18 Contact,
149: pai1.action_information19 Phone,
150: fnd_number.canonical_to_number(pai1.action_information20) Certain_Insurances, --EOY 2008
143: fnd_number.canonical_to_number(pai1.action_information13) Ext_Comp_Support_10,
144: fnd_number.canonical_to_number(pai1.action_information14) Pension,
145: fnd_number.canonical_to_number(pai1.action_information15) Ded_Pension,
146: fnd_number.canonical_to_number(pai1.action_information16) Interest,
147: fnd_number.canonical_to_number(pai1.action_information17) Ded_Interest,
148: pai1.action_information18 Contact,
149: pai1.action_information19 Phone,
150: fnd_number.canonical_to_number(pai1.action_information20) Certain_Insurances, --EOY 2008
151: fnd_number.canonical_to_number(pai1.action_information21) Certain_Insurances_29, --EOY 2008
146: fnd_number.canonical_to_number(pai1.action_information16) Interest,
147: fnd_number.canonical_to_number(pai1.action_information17) Ded_Interest,
148: pai1.action_information18 Contact,
149: pai1.action_information19 Phone,
150: fnd_number.canonical_to_number(pai1.action_information20) Certain_Insurances, --EOY 2008
151: fnd_number.canonical_to_number(pai1.action_information21) Certain_Insurances_29, --EOY 2008
152: fnd_number.canonical_to_number(pai2.action_information3) Gross_Pay,
153: fnd_number.canonical_to_number(pai2.action_information4) Benefit,
154: fnd_number.canonical_to_number(pai2.action_information5) Total_Basis_Employer_Tax,
147: fnd_number.canonical_to_number(pai1.action_information17) Ded_Interest,
148: pai1.action_information18 Contact,
149: pai1.action_information19 Phone,
150: fnd_number.canonical_to_number(pai1.action_information20) Certain_Insurances, --EOY 2008
151: fnd_number.canonical_to_number(pai1.action_information21) Certain_Insurances_29, --EOY 2008
152: fnd_number.canonical_to_number(pai2.action_information3) Gross_Pay,
153: fnd_number.canonical_to_number(pai2.action_information4) Benefit,
154: fnd_number.canonical_to_number(pai2.action_information5) Total_Basis_Employer_Tax,
155: fnd_number.canonical_to_number(pai2.action_information6) Regular_Taxable_Base,
148: pai1.action_information18 Contact,
149: pai1.action_information19 Phone,
150: fnd_number.canonical_to_number(pai1.action_information20) Certain_Insurances, --EOY 2008
151: fnd_number.canonical_to_number(pai1.action_information21) Certain_Insurances_29, --EOY 2008
152: fnd_number.canonical_to_number(pai2.action_information3) Gross_Pay,
153: fnd_number.canonical_to_number(pai2.action_information4) Benefit,
154: fnd_number.canonical_to_number(pai2.action_information5) Total_Basis_Employer_Tax,
155: fnd_number.canonical_to_number(pai2.action_information6) Regular_Taxable_Base,
156: fnd_number.canonical_to_number(pai2.action_information7) Regular_Tax,
149: pai1.action_information19 Phone,
150: fnd_number.canonical_to_number(pai1.action_information20) Certain_Insurances, --EOY 2008
151: fnd_number.canonical_to_number(pai1.action_information21) Certain_Insurances_29, --EOY 2008
152: fnd_number.canonical_to_number(pai2.action_information3) Gross_Pay,
153: fnd_number.canonical_to_number(pai2.action_information4) Benefit,
154: fnd_number.canonical_to_number(pai2.action_information5) Total_Basis_Employer_Tax,
155: fnd_number.canonical_to_number(pai2.action_information6) Regular_Taxable_Base,
156: fnd_number.canonical_to_number(pai2.action_information7) Regular_Tax,
157: fnd_number.canonical_to_number(pai2.action_information8) Special_65_Taxable_Base,
150: fnd_number.canonical_to_number(pai1.action_information20) Certain_Insurances, --EOY 2008
151: fnd_number.canonical_to_number(pai1.action_information21) Certain_Insurances_29, --EOY 2008
152: fnd_number.canonical_to_number(pai2.action_information3) Gross_Pay,
153: fnd_number.canonical_to_number(pai2.action_information4) Benefit,
154: fnd_number.canonical_to_number(pai2.action_information5) Total_Basis_Employer_Tax,
155: fnd_number.canonical_to_number(pai2.action_information6) Regular_Taxable_Base,
156: fnd_number.canonical_to_number(pai2.action_information7) Regular_Tax,
157: fnd_number.canonical_to_number(pai2.action_information8) Special_65_Taxable_Base,
158: fnd_number.canonical_to_number(pai2.action_information9) Special_65_Tax,
151: fnd_number.canonical_to_number(pai1.action_information21) Certain_Insurances_29, --EOY 2008
152: fnd_number.canonical_to_number(pai2.action_information3) Gross_Pay,
153: fnd_number.canonical_to_number(pai2.action_information4) Benefit,
154: fnd_number.canonical_to_number(pai2.action_information5) Total_Basis_Employer_Tax,
155: fnd_number.canonical_to_number(pai2.action_information6) Regular_Taxable_Base,
156: fnd_number.canonical_to_number(pai2.action_information7) Regular_Tax,
157: fnd_number.canonical_to_number(pai2.action_information8) Special_65_Taxable_Base,
158: fnd_number.canonical_to_number(pai2.action_information9) Special_65_Tax,
159: fnd_number.canonical_to_number(pai2.action_information10) Special_1937_Taxable_Base,
152: fnd_number.canonical_to_number(pai2.action_information3) Gross_Pay,
153: fnd_number.canonical_to_number(pai2.action_information4) Benefit,
154: fnd_number.canonical_to_number(pai2.action_information5) Total_Basis_Employer_Tax,
155: fnd_number.canonical_to_number(pai2.action_information6) Regular_Taxable_Base,
156: fnd_number.canonical_to_number(pai2.action_information7) Regular_Tax,
157: fnd_number.canonical_to_number(pai2.action_information8) Special_65_Taxable_Base,
158: fnd_number.canonical_to_number(pai2.action_information9) Special_65_Tax,
159: fnd_number.canonical_to_number(pai2.action_information10) Special_1937_Taxable_Base,
160: fnd_number.canonical_to_number(pai2.action_information11) Special_1937_Tax,
153: fnd_number.canonical_to_number(pai2.action_information4) Benefit,
154: fnd_number.canonical_to_number(pai2.action_information5) Total_Basis_Employer_Tax,
155: fnd_number.canonical_to_number(pai2.action_information6) Regular_Taxable_Base,
156: fnd_number.canonical_to_number(pai2.action_information7) Regular_Tax,
157: fnd_number.canonical_to_number(pai2.action_information8) Special_65_Taxable_Base,
158: fnd_number.canonical_to_number(pai2.action_information9) Special_65_Tax,
159: fnd_number.canonical_to_number(pai2.action_information10) Special_1937_Taxable_Base,
160: fnd_number.canonical_to_number(pai2.action_information11) Special_1937_Tax,
161: fnd_number.canonical_to_number(pai2.action_information12) Total_Employer_Tax,
154: fnd_number.canonical_to_number(pai2.action_information5) Total_Basis_Employer_Tax,
155: fnd_number.canonical_to_number(pai2.action_information6) Regular_Taxable_Base,
156: fnd_number.canonical_to_number(pai2.action_information7) Regular_Tax,
157: fnd_number.canonical_to_number(pai2.action_information8) Special_65_Taxable_Base,
158: fnd_number.canonical_to_number(pai2.action_information9) Special_65_Tax,
159: fnd_number.canonical_to_number(pai2.action_information10) Special_1937_Taxable_Base,
160: fnd_number.canonical_to_number(pai2.action_information11) Special_1937_Tax,
161: fnd_number.canonical_to_number(pai2.action_information12) Total_Employer_Tax,
162: fnd_number.canonical_to_number(pai2.action_information13) Taxable_Base,
155: fnd_number.canonical_to_number(pai2.action_information6) Regular_Taxable_Base,
156: fnd_number.canonical_to_number(pai2.action_information7) Regular_Tax,
157: fnd_number.canonical_to_number(pai2.action_information8) Special_65_Taxable_Base,
158: fnd_number.canonical_to_number(pai2.action_information9) Special_65_Tax,
159: fnd_number.canonical_to_number(pai2.action_information10) Special_1937_Taxable_Base,
160: fnd_number.canonical_to_number(pai2.action_information11) Special_1937_Tax,
161: fnd_number.canonical_to_number(pai2.action_information12) Total_Employer_Tax,
162: fnd_number.canonical_to_number(pai2.action_information13) Taxable_Base,
163: fnd_number.canonical_to_number(pai2.action_information14) Employee_Tax,
156: fnd_number.canonical_to_number(pai2.action_information7) Regular_Tax,
157: fnd_number.canonical_to_number(pai2.action_information8) Special_65_Taxable_Base,
158: fnd_number.canonical_to_number(pai2.action_information9) Special_65_Tax,
159: fnd_number.canonical_to_number(pai2.action_information10) Special_1937_Taxable_Base,
160: fnd_number.canonical_to_number(pai2.action_information11) Special_1937_Tax,
161: fnd_number.canonical_to_number(pai2.action_information12) Total_Employer_Tax,
162: fnd_number.canonical_to_number(pai2.action_information13) Taxable_Base,
163: fnd_number.canonical_to_number(pai2.action_information14) Employee_Tax,
164: fnd_number.canonical_to_number(pai2.action_information15) Tax_Deduction,
157: fnd_number.canonical_to_number(pai2.action_information8) Special_65_Taxable_Base,
158: fnd_number.canonical_to_number(pai2.action_information9) Special_65_Tax,
159: fnd_number.canonical_to_number(pai2.action_information10) Special_1937_Taxable_Base,
160: fnd_number.canonical_to_number(pai2.action_information11) Special_1937_Tax,
161: fnd_number.canonical_to_number(pai2.action_information12) Total_Employer_Tax,
162: fnd_number.canonical_to_number(pai2.action_information13) Taxable_Base,
163: fnd_number.canonical_to_number(pai2.action_information14) Employee_Tax,
164: fnd_number.canonical_to_number(pai2.action_information15) Tax_Deduction,
165: fnd_number.canonical_to_number(pai2.action_information16) Deducted_Tax_Pay,
158: fnd_number.canonical_to_number(pai2.action_information9) Special_65_Tax,
159: fnd_number.canonical_to_number(pai2.action_information10) Special_1937_Taxable_Base,
160: fnd_number.canonical_to_number(pai2.action_information11) Special_1937_Tax,
161: fnd_number.canonical_to_number(pai2.action_information12) Total_Employer_Tax,
162: fnd_number.canonical_to_number(pai2.action_information13) Taxable_Base,
163: fnd_number.canonical_to_number(pai2.action_information14) Employee_Tax,
164: fnd_number.canonical_to_number(pai2.action_information15) Tax_Deduction,
165: fnd_number.canonical_to_number(pai2.action_information16) Deducted_Tax_Pay,
166: fnd_number.canonical_to_number(pai2.action_information17) Comp_Without_LU,
159: fnd_number.canonical_to_number(pai2.action_information10) Special_1937_Taxable_Base,
160: fnd_number.canonical_to_number(pai2.action_information11) Special_1937_Tax,
161: fnd_number.canonical_to_number(pai2.action_information12) Total_Employer_Tax,
162: fnd_number.canonical_to_number(pai2.action_information13) Taxable_Base,
163: fnd_number.canonical_to_number(pai2.action_information14) Employee_Tax,
164: fnd_number.canonical_to_number(pai2.action_information15) Tax_Deduction,
165: fnd_number.canonical_to_number(pai2.action_information16) Deducted_Tax_Pay,
166: fnd_number.canonical_to_number(pai2.action_information17) Comp_Without_LU,
167: fnd_number.canonical_to_number(pai2.action_information18) Comp_Without_LU_29,
160: fnd_number.canonical_to_number(pai2.action_information11) Special_1937_Tax,
161: fnd_number.canonical_to_number(pai2.action_information12) Total_Employer_Tax,
162: fnd_number.canonical_to_number(pai2.action_information13) Taxable_Base,
163: fnd_number.canonical_to_number(pai2.action_information14) Employee_Tax,
164: fnd_number.canonical_to_number(pai2.action_information15) Tax_Deduction,
165: fnd_number.canonical_to_number(pai2.action_information16) Deducted_Tax_Pay,
166: fnd_number.canonical_to_number(pai2.action_information17) Comp_Without_LU,
167: fnd_number.canonical_to_number(pai2.action_information18) Comp_Without_LU_29,
168: fnd_number.canonical_to_number(pai2.action_information19) Comp_Without_LU_65_above,
161: fnd_number.canonical_to_number(pai2.action_information12) Total_Employer_Tax,
162: fnd_number.canonical_to_number(pai2.action_information13) Taxable_Base,
163: fnd_number.canonical_to_number(pai2.action_information14) Employee_Tax,
164: fnd_number.canonical_to_number(pai2.action_information15) Tax_Deduction,
165: fnd_number.canonical_to_number(pai2.action_information16) Deducted_Tax_Pay,
166: fnd_number.canonical_to_number(pai2.action_information17) Comp_Without_LU,
167: fnd_number.canonical_to_number(pai2.action_information18) Comp_Without_LU_29,
168: fnd_number.canonical_to_number(pai2.action_information19) Comp_Without_LU_65_above,
169: fnd_number.canonical_to_number(pai2.action_information20) Comp_Without_LU_29_65_above,
162: fnd_number.canonical_to_number(pai2.action_information13) Taxable_Base,
163: fnd_number.canonical_to_number(pai2.action_information14) Employee_Tax,
164: fnd_number.canonical_to_number(pai2.action_information15) Tax_Deduction,
165: fnd_number.canonical_to_number(pai2.action_information16) Deducted_Tax_Pay,
166: fnd_number.canonical_to_number(pai2.action_information17) Comp_Without_LU,
167: fnd_number.canonical_to_number(pai2.action_information18) Comp_Without_LU_29,
168: fnd_number.canonical_to_number(pai2.action_information19) Comp_Without_LU_65_above,
169: fnd_number.canonical_to_number(pai2.action_information20) Comp_Without_LU_29_65_above,
170: fnd_number.canonical_to_number(pai2.action_information21) Special_25_below_Taxable_Base,
163: fnd_number.canonical_to_number(pai2.action_information14) Employee_Tax,
164: fnd_number.canonical_to_number(pai2.action_information15) Tax_Deduction,
165: fnd_number.canonical_to_number(pai2.action_information16) Deducted_Tax_Pay,
166: fnd_number.canonical_to_number(pai2.action_information17) Comp_Without_LU,
167: fnd_number.canonical_to_number(pai2.action_information18) Comp_Without_LU_29,
168: fnd_number.canonical_to_number(pai2.action_information19) Comp_Without_LU_65_above,
169: fnd_number.canonical_to_number(pai2.action_information20) Comp_Without_LU_29_65_above,
170: fnd_number.canonical_to_number(pai2.action_information21) Special_25_below_Taxable_Base,
171: fnd_number.canonical_to_number(pai2.action_information22) Special_25_below_Tax,
164: fnd_number.canonical_to_number(pai2.action_information15) Tax_Deduction,
165: fnd_number.canonical_to_number(pai2.action_information16) Deducted_Tax_Pay,
166: fnd_number.canonical_to_number(pai2.action_information17) Comp_Without_LU,
167: fnd_number.canonical_to_number(pai2.action_information18) Comp_Without_LU_29,
168: fnd_number.canonical_to_number(pai2.action_information19) Comp_Without_LU_65_above,
169: fnd_number.canonical_to_number(pai2.action_information20) Comp_Without_LU_29_65_above,
170: fnd_number.canonical_to_number(pai2.action_information21) Special_25_below_Taxable_Base,
171: fnd_number.canonical_to_number(pai2.action_information22) Special_25_below_Tax,
172: fnd_number.canonical_to_number(pai2.action_information23) Comp_Without_LU_25_below, -- EOY 2008
165: fnd_number.canonical_to_number(pai2.action_information16) Deducted_Tax_Pay,
166: fnd_number.canonical_to_number(pai2.action_information17) Comp_Without_LU,
167: fnd_number.canonical_to_number(pai2.action_information18) Comp_Without_LU_29,
168: fnd_number.canonical_to_number(pai2.action_information19) Comp_Without_LU_65_above,
169: fnd_number.canonical_to_number(pai2.action_information20) Comp_Without_LU_29_65_above,
170: fnd_number.canonical_to_number(pai2.action_information21) Special_25_below_Taxable_Base,
171: fnd_number.canonical_to_number(pai2.action_information22) Special_25_below_Tax,
172: fnd_number.canonical_to_number(pai2.action_information23) Comp_Without_LU_25_below, -- EOY 2008
173: fnd_number.canonical_to_number(pai2.action_information24) Comp_Without_LU_29_25_below -- EOY 2008
166: fnd_number.canonical_to_number(pai2.action_information17) Comp_Without_LU,
167: fnd_number.canonical_to_number(pai2.action_information18) Comp_Without_LU_29,
168: fnd_number.canonical_to_number(pai2.action_information19) Comp_Without_LU_65_above,
169: fnd_number.canonical_to_number(pai2.action_information20) Comp_Without_LU_29_65_above,
170: fnd_number.canonical_to_number(pai2.action_information21) Special_25_below_Taxable_Base,
171: fnd_number.canonical_to_number(pai2.action_information22) Special_25_below_Tax,
172: fnd_number.canonical_to_number(pai2.action_information23) Comp_Without_LU_25_below, -- EOY 2008
173: fnd_number.canonical_to_number(pai2.action_information24) Comp_Without_LU_29_25_below -- EOY 2008
174: FROM
167: fnd_number.canonical_to_number(pai2.action_information18) Comp_Without_LU_29,
168: fnd_number.canonical_to_number(pai2.action_information19) Comp_Without_LU_65_above,
169: fnd_number.canonical_to_number(pai2.action_information20) Comp_Without_LU_29_65_above,
170: fnd_number.canonical_to_number(pai2.action_information21) Special_25_below_Taxable_Base,
171: fnd_number.canonical_to_number(pai2.action_information22) Special_25_below_Tax,
172: fnd_number.canonical_to_number(pai2.action_information23) Comp_Without_LU_25_below, -- EOY 2008
173: fnd_number.canonical_to_number(pai2.action_information24) Comp_Without_LU_29_25_below -- EOY 2008
174: FROM
175: pay_action_information pai,
168: fnd_number.canonical_to_number(pai2.action_information19) Comp_Without_LU_65_above,
169: fnd_number.canonical_to_number(pai2.action_information20) Comp_Without_LU_29_65_above,
170: fnd_number.canonical_to_number(pai2.action_information21) Special_25_below_Taxable_Base,
171: fnd_number.canonical_to_number(pai2.action_information22) Special_25_below_Tax,
172: fnd_number.canonical_to_number(pai2.action_information23) Comp_Without_LU_25_below, -- EOY 2008
173: fnd_number.canonical_to_number(pai2.action_information24) Comp_Without_LU_29_25_below -- EOY 2008
174: FROM
175: pay_action_information pai,
176: pay_payroll_actions ppa,
169: fnd_number.canonical_to_number(pai2.action_information20) Comp_Without_LU_29_65_above,
170: fnd_number.canonical_to_number(pai2.action_information21) Special_25_below_Taxable_Base,
171: fnd_number.canonical_to_number(pai2.action_information22) Special_25_below_Tax,
172: fnd_number.canonical_to_number(pai2.action_information23) Comp_Without_LU_25_below, -- EOY 2008
173: fnd_number.canonical_to_number(pai2.action_information24) Comp_Without_LU_29_25_below -- EOY 2008
174: FROM
175: pay_action_information pai,
176: pay_payroll_actions ppa,
177: pay_action_information pai1,
195: AND pai2.action_information2 = 'BAL';
196:
197: rg_Tax_Decl csr_Tax_Decl%rowtype;
198: CURSOR csr_global(csr_v_global VARCHAR2,csr_v_effective_date DATE )IS
199: SELECT nvl(fnd_number.canonical_to_number(global_value),0) FROM ff_globals_f WHERE GLOBAL_NAME=csr_v_global --'SE_EMPLOYER_TAX_PERC'
200: and csr_v_effective_date --p_effective_date
201: BETWEEN effective_start_date AND
202: effective_end_date;
203:
1794: pai.action_information8 Declaration_Due_Date,
1795: pai.action_information6 Administrative_Code,
1796: pai.action_information7 Information,
1797: pai1.action_information3 Organization_Number,
1798: fnd_number.canonical_to_number(pai1.action_information4) Reduction,
1799: pai1.action_information7 Code,
1800: fnd_number.canonical_to_number(pai1.action_information8) Canada,
1801: fnd_number.canonical_to_number(pai1.action_information9) Special_Canada,
1802: -- fnd_number.canonical_to_number(pai1.action_information10) Comp_Support, -- EOY 2008
1796: pai.action_information7 Information,
1797: pai1.action_information3 Organization_Number,
1798: fnd_number.canonical_to_number(pai1.action_information4) Reduction,
1799: pai1.action_information7 Code,
1800: fnd_number.canonical_to_number(pai1.action_information8) Canada,
1801: fnd_number.canonical_to_number(pai1.action_information9) Special_Canada,
1802: -- fnd_number.canonical_to_number(pai1.action_information10) Comp_Support, -- EOY 2008
1803: -- fnd_number.canonical_to_number(pai1.action_information11) Comp_Support_5, -- EOY 2008
1804: fnd_number.canonical_to_number(pai1.action_information12) Ext_Comp_Support,
1797: pai1.action_information3 Organization_Number,
1798: fnd_number.canonical_to_number(pai1.action_information4) Reduction,
1799: pai1.action_information7 Code,
1800: fnd_number.canonical_to_number(pai1.action_information8) Canada,
1801: fnd_number.canonical_to_number(pai1.action_information9) Special_Canada,
1802: -- fnd_number.canonical_to_number(pai1.action_information10) Comp_Support, -- EOY 2008
1803: -- fnd_number.canonical_to_number(pai1.action_information11) Comp_Support_5, -- EOY 2008
1804: fnd_number.canonical_to_number(pai1.action_information12) Ext_Comp_Support,
1805: fnd_number.canonical_to_number(pai1.action_information13) Ext_Comp_Support_10,
1798: fnd_number.canonical_to_number(pai1.action_information4) Reduction,
1799: pai1.action_information7 Code,
1800: fnd_number.canonical_to_number(pai1.action_information8) Canada,
1801: fnd_number.canonical_to_number(pai1.action_information9) Special_Canada,
1802: -- fnd_number.canonical_to_number(pai1.action_information10) Comp_Support, -- EOY 2008
1803: -- fnd_number.canonical_to_number(pai1.action_information11) Comp_Support_5, -- EOY 2008
1804: fnd_number.canonical_to_number(pai1.action_information12) Ext_Comp_Support,
1805: fnd_number.canonical_to_number(pai1.action_information13) Ext_Comp_Support_10,
1806: fnd_number.canonical_to_number(pai1.action_information14) Pension,
1799: pai1.action_information7 Code,
1800: fnd_number.canonical_to_number(pai1.action_information8) Canada,
1801: fnd_number.canonical_to_number(pai1.action_information9) Special_Canada,
1802: -- fnd_number.canonical_to_number(pai1.action_information10) Comp_Support, -- EOY 2008
1803: -- fnd_number.canonical_to_number(pai1.action_information11) Comp_Support_5, -- EOY 2008
1804: fnd_number.canonical_to_number(pai1.action_information12) Ext_Comp_Support,
1805: fnd_number.canonical_to_number(pai1.action_information13) Ext_Comp_Support_10,
1806: fnd_number.canonical_to_number(pai1.action_information14) Pension,
1807: fnd_number.canonical_to_number(pai1.action_information15) Ded_Pension,
1800: fnd_number.canonical_to_number(pai1.action_information8) Canada,
1801: fnd_number.canonical_to_number(pai1.action_information9) Special_Canada,
1802: -- fnd_number.canonical_to_number(pai1.action_information10) Comp_Support, -- EOY 2008
1803: -- fnd_number.canonical_to_number(pai1.action_information11) Comp_Support_5, -- EOY 2008
1804: fnd_number.canonical_to_number(pai1.action_information12) Ext_Comp_Support,
1805: fnd_number.canonical_to_number(pai1.action_information13) Ext_Comp_Support_10,
1806: fnd_number.canonical_to_number(pai1.action_information14) Pension,
1807: fnd_number.canonical_to_number(pai1.action_information15) Ded_Pension,
1808: fnd_number.canonical_to_number(pai1.action_information16) Interest,
1801: fnd_number.canonical_to_number(pai1.action_information9) Special_Canada,
1802: -- fnd_number.canonical_to_number(pai1.action_information10) Comp_Support, -- EOY 2008
1803: -- fnd_number.canonical_to_number(pai1.action_information11) Comp_Support_5, -- EOY 2008
1804: fnd_number.canonical_to_number(pai1.action_information12) Ext_Comp_Support,
1805: fnd_number.canonical_to_number(pai1.action_information13) Ext_Comp_Support_10,
1806: fnd_number.canonical_to_number(pai1.action_information14) Pension,
1807: fnd_number.canonical_to_number(pai1.action_information15) Ded_Pension,
1808: fnd_number.canonical_to_number(pai1.action_information16) Interest,
1809: fnd_number.canonical_to_number(pai1.action_information17) Ded_Interest,
1802: -- fnd_number.canonical_to_number(pai1.action_information10) Comp_Support, -- EOY 2008
1803: -- fnd_number.canonical_to_number(pai1.action_information11) Comp_Support_5, -- EOY 2008
1804: fnd_number.canonical_to_number(pai1.action_information12) Ext_Comp_Support,
1805: fnd_number.canonical_to_number(pai1.action_information13) Ext_Comp_Support_10,
1806: fnd_number.canonical_to_number(pai1.action_information14) Pension,
1807: fnd_number.canonical_to_number(pai1.action_information15) Ded_Pension,
1808: fnd_number.canonical_to_number(pai1.action_information16) Interest,
1809: fnd_number.canonical_to_number(pai1.action_information17) Ded_Interest,
1810: pai1.action_information18 Contact,
1803: -- fnd_number.canonical_to_number(pai1.action_information11) Comp_Support_5, -- EOY 2008
1804: fnd_number.canonical_to_number(pai1.action_information12) Ext_Comp_Support,
1805: fnd_number.canonical_to_number(pai1.action_information13) Ext_Comp_Support_10,
1806: fnd_number.canonical_to_number(pai1.action_information14) Pension,
1807: fnd_number.canonical_to_number(pai1.action_information15) Ded_Pension,
1808: fnd_number.canonical_to_number(pai1.action_information16) Interest,
1809: fnd_number.canonical_to_number(pai1.action_information17) Ded_Interest,
1810: pai1.action_information18 Contact,
1811: pai1.action_information19 Phone,
1804: fnd_number.canonical_to_number(pai1.action_information12) Ext_Comp_Support,
1805: fnd_number.canonical_to_number(pai1.action_information13) Ext_Comp_Support_10,
1806: fnd_number.canonical_to_number(pai1.action_information14) Pension,
1807: fnd_number.canonical_to_number(pai1.action_information15) Ded_Pension,
1808: fnd_number.canonical_to_number(pai1.action_information16) Interest,
1809: fnd_number.canonical_to_number(pai1.action_information17) Ded_Interest,
1810: pai1.action_information18 Contact,
1811: pai1.action_information19 Phone,
1812: fnd_number.canonical_to_number(pai1.action_information20) Certain_Insurances, --EOY 2008
1805: fnd_number.canonical_to_number(pai1.action_information13) Ext_Comp_Support_10,
1806: fnd_number.canonical_to_number(pai1.action_information14) Pension,
1807: fnd_number.canonical_to_number(pai1.action_information15) Ded_Pension,
1808: fnd_number.canonical_to_number(pai1.action_information16) Interest,
1809: fnd_number.canonical_to_number(pai1.action_information17) Ded_Interest,
1810: pai1.action_information18 Contact,
1811: pai1.action_information19 Phone,
1812: fnd_number.canonical_to_number(pai1.action_information20) Certain_Insurances, --EOY 2008
1813: fnd_number.canonical_to_number(pai1.action_information21) Certain_Insurances_29, -- EOY 2008
1808: fnd_number.canonical_to_number(pai1.action_information16) Interest,
1809: fnd_number.canonical_to_number(pai1.action_information17) Ded_Interest,
1810: pai1.action_information18 Contact,
1811: pai1.action_information19 Phone,
1812: fnd_number.canonical_to_number(pai1.action_information20) Certain_Insurances, --EOY 2008
1813: fnd_number.canonical_to_number(pai1.action_information21) Certain_Insurances_29, -- EOY 2008
1814: fnd_number.canonical_to_number(pai2.action_information3) Gross_Pay,
1815: fnd_number.canonical_to_number(pai2.action_information4) Benefit,
1816: fnd_number.canonical_to_number(pai2.action_information5) Total_Basis_Employer_Tax,
1809: fnd_number.canonical_to_number(pai1.action_information17) Ded_Interest,
1810: pai1.action_information18 Contact,
1811: pai1.action_information19 Phone,
1812: fnd_number.canonical_to_number(pai1.action_information20) Certain_Insurances, --EOY 2008
1813: fnd_number.canonical_to_number(pai1.action_information21) Certain_Insurances_29, -- EOY 2008
1814: fnd_number.canonical_to_number(pai2.action_information3) Gross_Pay,
1815: fnd_number.canonical_to_number(pai2.action_information4) Benefit,
1816: fnd_number.canonical_to_number(pai2.action_information5) Total_Basis_Employer_Tax,
1817: fnd_number.canonical_to_number(pai2.action_information6) Regular_Taxable_Base,
1810: pai1.action_information18 Contact,
1811: pai1.action_information19 Phone,
1812: fnd_number.canonical_to_number(pai1.action_information20) Certain_Insurances, --EOY 2008
1813: fnd_number.canonical_to_number(pai1.action_information21) Certain_Insurances_29, -- EOY 2008
1814: fnd_number.canonical_to_number(pai2.action_information3) Gross_Pay,
1815: fnd_number.canonical_to_number(pai2.action_information4) Benefit,
1816: fnd_number.canonical_to_number(pai2.action_information5) Total_Basis_Employer_Tax,
1817: fnd_number.canonical_to_number(pai2.action_information6) Regular_Taxable_Base,
1818: fnd_number.canonical_to_number(pai2.action_information7) Regular_Tax,
1811: pai1.action_information19 Phone,
1812: fnd_number.canonical_to_number(pai1.action_information20) Certain_Insurances, --EOY 2008
1813: fnd_number.canonical_to_number(pai1.action_information21) Certain_Insurances_29, -- EOY 2008
1814: fnd_number.canonical_to_number(pai2.action_information3) Gross_Pay,
1815: fnd_number.canonical_to_number(pai2.action_information4) Benefit,
1816: fnd_number.canonical_to_number(pai2.action_information5) Total_Basis_Employer_Tax,
1817: fnd_number.canonical_to_number(pai2.action_information6) Regular_Taxable_Base,
1818: fnd_number.canonical_to_number(pai2.action_information7) Regular_Tax,
1819: fnd_number.canonical_to_number(pai2.action_information8) Special_65_Taxable_Base,
1812: fnd_number.canonical_to_number(pai1.action_information20) Certain_Insurances, --EOY 2008
1813: fnd_number.canonical_to_number(pai1.action_information21) Certain_Insurances_29, -- EOY 2008
1814: fnd_number.canonical_to_number(pai2.action_information3) Gross_Pay,
1815: fnd_number.canonical_to_number(pai2.action_information4) Benefit,
1816: fnd_number.canonical_to_number(pai2.action_information5) Total_Basis_Employer_Tax,
1817: fnd_number.canonical_to_number(pai2.action_information6) Regular_Taxable_Base,
1818: fnd_number.canonical_to_number(pai2.action_information7) Regular_Tax,
1819: fnd_number.canonical_to_number(pai2.action_information8) Special_65_Taxable_Base,
1820: fnd_number.canonical_to_number(pai2.action_information9) Special_65_Tax,
1813: fnd_number.canonical_to_number(pai1.action_information21) Certain_Insurances_29, -- EOY 2008
1814: fnd_number.canonical_to_number(pai2.action_information3) Gross_Pay,
1815: fnd_number.canonical_to_number(pai2.action_information4) Benefit,
1816: fnd_number.canonical_to_number(pai2.action_information5) Total_Basis_Employer_Tax,
1817: fnd_number.canonical_to_number(pai2.action_information6) Regular_Taxable_Base,
1818: fnd_number.canonical_to_number(pai2.action_information7) Regular_Tax,
1819: fnd_number.canonical_to_number(pai2.action_information8) Special_65_Taxable_Base,
1820: fnd_number.canonical_to_number(pai2.action_information9) Special_65_Tax,
1821: fnd_number.canonical_to_number(pai2.action_information10) Special_1937_Taxable_Base,
1814: fnd_number.canonical_to_number(pai2.action_information3) Gross_Pay,
1815: fnd_number.canonical_to_number(pai2.action_information4) Benefit,
1816: fnd_number.canonical_to_number(pai2.action_information5) Total_Basis_Employer_Tax,
1817: fnd_number.canonical_to_number(pai2.action_information6) Regular_Taxable_Base,
1818: fnd_number.canonical_to_number(pai2.action_information7) Regular_Tax,
1819: fnd_number.canonical_to_number(pai2.action_information8) Special_65_Taxable_Base,
1820: fnd_number.canonical_to_number(pai2.action_information9) Special_65_Tax,
1821: fnd_number.canonical_to_number(pai2.action_information10) Special_1937_Taxable_Base,
1822: fnd_number.canonical_to_number(pai2.action_information11) Special_1937_Tax,
1815: fnd_number.canonical_to_number(pai2.action_information4) Benefit,
1816: fnd_number.canonical_to_number(pai2.action_information5) Total_Basis_Employer_Tax,
1817: fnd_number.canonical_to_number(pai2.action_information6) Regular_Taxable_Base,
1818: fnd_number.canonical_to_number(pai2.action_information7) Regular_Tax,
1819: fnd_number.canonical_to_number(pai2.action_information8) Special_65_Taxable_Base,
1820: fnd_number.canonical_to_number(pai2.action_information9) Special_65_Tax,
1821: fnd_number.canonical_to_number(pai2.action_information10) Special_1937_Taxable_Base,
1822: fnd_number.canonical_to_number(pai2.action_information11) Special_1937_Tax,
1823: fnd_number.canonical_to_number(pai2.action_information12) Total_Employer_Tax,
1816: fnd_number.canonical_to_number(pai2.action_information5) Total_Basis_Employer_Tax,
1817: fnd_number.canonical_to_number(pai2.action_information6) Regular_Taxable_Base,
1818: fnd_number.canonical_to_number(pai2.action_information7) Regular_Tax,
1819: fnd_number.canonical_to_number(pai2.action_information8) Special_65_Taxable_Base,
1820: fnd_number.canonical_to_number(pai2.action_information9) Special_65_Tax,
1821: fnd_number.canonical_to_number(pai2.action_information10) Special_1937_Taxable_Base,
1822: fnd_number.canonical_to_number(pai2.action_information11) Special_1937_Tax,
1823: fnd_number.canonical_to_number(pai2.action_information12) Total_Employer_Tax,
1824: fnd_number.canonical_to_number(pai2.action_information13) Taxable_Base,
1817: fnd_number.canonical_to_number(pai2.action_information6) Regular_Taxable_Base,
1818: fnd_number.canonical_to_number(pai2.action_information7) Regular_Tax,
1819: fnd_number.canonical_to_number(pai2.action_information8) Special_65_Taxable_Base,
1820: fnd_number.canonical_to_number(pai2.action_information9) Special_65_Tax,
1821: fnd_number.canonical_to_number(pai2.action_information10) Special_1937_Taxable_Base,
1822: fnd_number.canonical_to_number(pai2.action_information11) Special_1937_Tax,
1823: fnd_number.canonical_to_number(pai2.action_information12) Total_Employer_Tax,
1824: fnd_number.canonical_to_number(pai2.action_information13) Taxable_Base,
1825: fnd_number.canonical_to_number(pai2.action_information14) Employee_Tax,
1818: fnd_number.canonical_to_number(pai2.action_information7) Regular_Tax,
1819: fnd_number.canonical_to_number(pai2.action_information8) Special_65_Taxable_Base,
1820: fnd_number.canonical_to_number(pai2.action_information9) Special_65_Tax,
1821: fnd_number.canonical_to_number(pai2.action_information10) Special_1937_Taxable_Base,
1822: fnd_number.canonical_to_number(pai2.action_information11) Special_1937_Tax,
1823: fnd_number.canonical_to_number(pai2.action_information12) Total_Employer_Tax,
1824: fnd_number.canonical_to_number(pai2.action_information13) Taxable_Base,
1825: fnd_number.canonical_to_number(pai2.action_information14) Employee_Tax,
1826: fnd_number.canonical_to_number(pai2.action_information15) Tax_Deduction,
1819: fnd_number.canonical_to_number(pai2.action_information8) Special_65_Taxable_Base,
1820: fnd_number.canonical_to_number(pai2.action_information9) Special_65_Tax,
1821: fnd_number.canonical_to_number(pai2.action_information10) Special_1937_Taxable_Base,
1822: fnd_number.canonical_to_number(pai2.action_information11) Special_1937_Tax,
1823: fnd_number.canonical_to_number(pai2.action_information12) Total_Employer_Tax,
1824: fnd_number.canonical_to_number(pai2.action_information13) Taxable_Base,
1825: fnd_number.canonical_to_number(pai2.action_information14) Employee_Tax,
1826: fnd_number.canonical_to_number(pai2.action_information15) Tax_Deduction,
1827: fnd_number.canonical_to_number(pai2.action_information16) Deducted_Tax_Pay,
1820: fnd_number.canonical_to_number(pai2.action_information9) Special_65_Tax,
1821: fnd_number.canonical_to_number(pai2.action_information10) Special_1937_Taxable_Base,
1822: fnd_number.canonical_to_number(pai2.action_information11) Special_1937_Tax,
1823: fnd_number.canonical_to_number(pai2.action_information12) Total_Employer_Tax,
1824: fnd_number.canonical_to_number(pai2.action_information13) Taxable_Base,
1825: fnd_number.canonical_to_number(pai2.action_information14) Employee_Tax,
1826: fnd_number.canonical_to_number(pai2.action_information15) Tax_Deduction,
1827: fnd_number.canonical_to_number(pai2.action_information16) Deducted_Tax_Pay,
1828: fnd_number.canonical_to_number(pai2.action_information17) Comp_Without_LU,
1821: fnd_number.canonical_to_number(pai2.action_information10) Special_1937_Taxable_Base,
1822: fnd_number.canonical_to_number(pai2.action_information11) Special_1937_Tax,
1823: fnd_number.canonical_to_number(pai2.action_information12) Total_Employer_Tax,
1824: fnd_number.canonical_to_number(pai2.action_information13) Taxable_Base,
1825: fnd_number.canonical_to_number(pai2.action_information14) Employee_Tax,
1826: fnd_number.canonical_to_number(pai2.action_information15) Tax_Deduction,
1827: fnd_number.canonical_to_number(pai2.action_information16) Deducted_Tax_Pay,
1828: fnd_number.canonical_to_number(pai2.action_information17) Comp_Without_LU,
1829: fnd_number.canonical_to_number(pai2.action_information18) Comp_Without_LU_29,
1822: fnd_number.canonical_to_number(pai2.action_information11) Special_1937_Tax,
1823: fnd_number.canonical_to_number(pai2.action_information12) Total_Employer_Tax,
1824: fnd_number.canonical_to_number(pai2.action_information13) Taxable_Base,
1825: fnd_number.canonical_to_number(pai2.action_information14) Employee_Tax,
1826: fnd_number.canonical_to_number(pai2.action_information15) Tax_Deduction,
1827: fnd_number.canonical_to_number(pai2.action_information16) Deducted_Tax_Pay,
1828: fnd_number.canonical_to_number(pai2.action_information17) Comp_Without_LU,
1829: fnd_number.canonical_to_number(pai2.action_information18) Comp_Without_LU_29,
1830: fnd_number.canonical_to_number(pai2.action_information19) Comp_Without_LU_65_below,
1823: fnd_number.canonical_to_number(pai2.action_information12) Total_Employer_Tax,
1824: fnd_number.canonical_to_number(pai2.action_information13) Taxable_Base,
1825: fnd_number.canonical_to_number(pai2.action_information14) Employee_Tax,
1826: fnd_number.canonical_to_number(pai2.action_information15) Tax_Deduction,
1827: fnd_number.canonical_to_number(pai2.action_information16) Deducted_Tax_Pay,
1828: fnd_number.canonical_to_number(pai2.action_information17) Comp_Without_LU,
1829: fnd_number.canonical_to_number(pai2.action_information18) Comp_Without_LU_29,
1830: fnd_number.canonical_to_number(pai2.action_information19) Comp_Without_LU_65_below,
1831: fnd_number.canonical_to_number(pai2.action_information20) Comp_Without_LU_29_65_below,
1824: fnd_number.canonical_to_number(pai2.action_information13) Taxable_Base,
1825: fnd_number.canonical_to_number(pai2.action_information14) Employee_Tax,
1826: fnd_number.canonical_to_number(pai2.action_information15) Tax_Deduction,
1827: fnd_number.canonical_to_number(pai2.action_information16) Deducted_Tax_Pay,
1828: fnd_number.canonical_to_number(pai2.action_information17) Comp_Without_LU,
1829: fnd_number.canonical_to_number(pai2.action_information18) Comp_Without_LU_29,
1830: fnd_number.canonical_to_number(pai2.action_information19) Comp_Without_LU_65_below,
1831: fnd_number.canonical_to_number(pai2.action_information20) Comp_Without_LU_29_65_below,
1832: fnd_number.canonical_to_number(pai2.action_information21) Special_25_below_Taxable_Base,
1825: fnd_number.canonical_to_number(pai2.action_information14) Employee_Tax,
1826: fnd_number.canonical_to_number(pai2.action_information15) Tax_Deduction,
1827: fnd_number.canonical_to_number(pai2.action_information16) Deducted_Tax_Pay,
1828: fnd_number.canonical_to_number(pai2.action_information17) Comp_Without_LU,
1829: fnd_number.canonical_to_number(pai2.action_information18) Comp_Without_LU_29,
1830: fnd_number.canonical_to_number(pai2.action_information19) Comp_Without_LU_65_below,
1831: fnd_number.canonical_to_number(pai2.action_information20) Comp_Without_LU_29_65_below,
1832: fnd_number.canonical_to_number(pai2.action_information21) Special_25_below_Taxable_Base,
1833: fnd_number.canonical_to_number(pai2.action_information22) Special_25_below_Tax,
1826: fnd_number.canonical_to_number(pai2.action_information15) Tax_Deduction,
1827: fnd_number.canonical_to_number(pai2.action_information16) Deducted_Tax_Pay,
1828: fnd_number.canonical_to_number(pai2.action_information17) Comp_Without_LU,
1829: fnd_number.canonical_to_number(pai2.action_information18) Comp_Without_LU_29,
1830: fnd_number.canonical_to_number(pai2.action_information19) Comp_Without_LU_65_below,
1831: fnd_number.canonical_to_number(pai2.action_information20) Comp_Without_LU_29_65_below,
1832: fnd_number.canonical_to_number(pai2.action_information21) Special_25_below_Taxable_Base,
1833: fnd_number.canonical_to_number(pai2.action_information22) Special_25_below_Tax,
1834: fnd_number.canonical_to_number(pai2.action_information23) Comp_Without_LU_25_below, -- EOY 2008
1827: fnd_number.canonical_to_number(pai2.action_information16) Deducted_Tax_Pay,
1828: fnd_number.canonical_to_number(pai2.action_information17) Comp_Without_LU,
1829: fnd_number.canonical_to_number(pai2.action_information18) Comp_Without_LU_29,
1830: fnd_number.canonical_to_number(pai2.action_information19) Comp_Without_LU_65_below,
1831: fnd_number.canonical_to_number(pai2.action_information20) Comp_Without_LU_29_65_below,
1832: fnd_number.canonical_to_number(pai2.action_information21) Special_25_below_Taxable_Base,
1833: fnd_number.canonical_to_number(pai2.action_information22) Special_25_below_Tax,
1834: fnd_number.canonical_to_number(pai2.action_information23) Comp_Without_LU_25_below, -- EOY 2008
1835: fnd_number.canonical_to_number(pai2.action_information24) Comp_Without_LU_29_25_below -- EOY 2008
1828: fnd_number.canonical_to_number(pai2.action_information17) Comp_Without_LU,
1829: fnd_number.canonical_to_number(pai2.action_information18) Comp_Without_LU_29,
1830: fnd_number.canonical_to_number(pai2.action_information19) Comp_Without_LU_65_below,
1831: fnd_number.canonical_to_number(pai2.action_information20) Comp_Without_LU_29_65_below,
1832: fnd_number.canonical_to_number(pai2.action_information21) Special_25_below_Taxable_Base,
1833: fnd_number.canonical_to_number(pai2.action_information22) Special_25_below_Tax,
1834: fnd_number.canonical_to_number(pai2.action_information23) Comp_Without_LU_25_below, -- EOY 2008
1835: fnd_number.canonical_to_number(pai2.action_information24) Comp_Without_LU_29_25_below -- EOY 2008
1836: FROM
1829: fnd_number.canonical_to_number(pai2.action_information18) Comp_Without_LU_29,
1830: fnd_number.canonical_to_number(pai2.action_information19) Comp_Without_LU_65_below,
1831: fnd_number.canonical_to_number(pai2.action_information20) Comp_Without_LU_29_65_below,
1832: fnd_number.canonical_to_number(pai2.action_information21) Special_25_below_Taxable_Base,
1833: fnd_number.canonical_to_number(pai2.action_information22) Special_25_below_Tax,
1834: fnd_number.canonical_to_number(pai2.action_information23) Comp_Without_LU_25_below, -- EOY 2008
1835: fnd_number.canonical_to_number(pai2.action_information24) Comp_Without_LU_29_25_below -- EOY 2008
1836: FROM
1837: pay_action_information pai,
1830: fnd_number.canonical_to_number(pai2.action_information19) Comp_Without_LU_65_below,
1831: fnd_number.canonical_to_number(pai2.action_information20) Comp_Without_LU_29_65_below,
1832: fnd_number.canonical_to_number(pai2.action_information21) Special_25_below_Taxable_Base,
1833: fnd_number.canonical_to_number(pai2.action_information22) Special_25_below_Tax,
1834: fnd_number.canonical_to_number(pai2.action_information23) Comp_Without_LU_25_below, -- EOY 2008
1835: fnd_number.canonical_to_number(pai2.action_information24) Comp_Without_LU_29_25_below -- EOY 2008
1836: FROM
1837: pay_action_information pai,
1838: pay_payroll_actions ppa,
1831: fnd_number.canonical_to_number(pai2.action_information20) Comp_Without_LU_29_65_below,
1832: fnd_number.canonical_to_number(pai2.action_information21) Special_25_below_Taxable_Base,
1833: fnd_number.canonical_to_number(pai2.action_information22) Special_25_below_Tax,
1834: fnd_number.canonical_to_number(pai2.action_information23) Comp_Without_LU_25_below, -- EOY 2008
1835: fnd_number.canonical_to_number(pai2.action_information24) Comp_Without_LU_29_25_below -- EOY 2008
1836: FROM
1837: pay_action_information pai,
1838: pay_payroll_actions ppa,
1839: pay_action_information pai1,