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

APPS.PAY_NL_ATS_REPORT dependencies on FND_NUMBER

Line 51: NVL(fnd_number.canonical_to_number(pai.action_information18),fnd_number.canonical_to_number(pai.action_information4)) Taxable_Income,

47: --11886537 begins
48: --NVL(pai.action_information18,pai.action_information4) Taxable_Income,
49: --pai.action_Information5 Deducted_Wage_Tax,
50: --pai.action_information8 Labour_Tax_Reduction,
51: NVL(fnd_number.canonical_to_number(pai.action_information18),fnd_number.canonical_to_number(pai.action_information4)) Taxable_Income,
52: fnd_number.canonical_to_number(pai.action_Information5) Deducted_Wage_Tax,
53: fnd_number.canonical_to_number(pai.action_information8) Labour_Tax_Reduction,
54: --11886537 ends
55: decode(substr(pai.action_information14,1,1),'1',lp_yes,2,lp_yes,3,lp_yes,lp_no) Insured_For_WAO,

Line 52: fnd_number.canonical_to_number(pai.action_Information5) Deducted_Wage_Tax,

48: --NVL(pai.action_information18,pai.action_information4) Taxable_Income,
49: --pai.action_Information5 Deducted_Wage_Tax,
50: --pai.action_information8 Labour_Tax_Reduction,
51: NVL(fnd_number.canonical_to_number(pai.action_information18),fnd_number.canonical_to_number(pai.action_information4)) Taxable_Income,
52: fnd_number.canonical_to_number(pai.action_Information5) Deducted_Wage_Tax,
53: fnd_number.canonical_to_number(pai.action_information8) Labour_Tax_Reduction,
54: --11886537 ends
55: decode(substr(pai.action_information14,1,1),'1',lp_yes,2,lp_yes,3,lp_yes,lp_no) Insured_For_WAO,
56: --decode(substr(pai.action_information14,2,1),'1',lp_yes,2,lp_yes,3,lp_yes,lp_no) Insured_For_ZFW,

Line 53: fnd_number.canonical_to_number(pai.action_information8) Labour_Tax_Reduction,

49: --pai.action_Information5 Deducted_Wage_Tax,
50: --pai.action_information8 Labour_Tax_Reduction,
51: NVL(fnd_number.canonical_to_number(pai.action_information18),fnd_number.canonical_to_number(pai.action_information4)) Taxable_Income,
52: fnd_number.canonical_to_number(pai.action_Information5) Deducted_Wage_Tax,
53: fnd_number.canonical_to_number(pai.action_information8) Labour_Tax_Reduction,
54: --11886537 ends
55: decode(substr(pai.action_information14,1,1),'1',lp_yes,2,lp_yes,3,lp_yes,lp_no) Insured_For_WAO,
56: --decode(substr(pai.action_information14,2,1),'1',lp_yes,2,lp_yes,3,lp_yes,lp_no) Insured_For_ZFW,
57: --pai.action_information15 ZVW_Cont, --11886537

Line 58: fnd_number.canonical_to_number(pai.action_information15) ZVW_Cont, --11886537

54: --11886537 ends
55: decode(substr(pai.action_information14,1,1),'1',lp_yes,2,lp_yes,3,lp_yes,lp_no) Insured_For_WAO,
56: --decode(substr(pai.action_information14,2,1),'1',lp_yes,2,lp_yes,3,lp_yes,lp_no) Insured_For_ZFW,
57: --pai.action_information15 ZVW_Cont, --11886537
58: fnd_number.canonical_to_number(pai.action_information15) ZVW_Cont, --11886537
59: substr(pai.action_information12,13,1) Company_Car,
60: --11886537 begins
61: --pai.action_information17 Private_Use_Car,
62: --pai.action_information16 Net_Expense_Allowance,

Line 69: fnd_number.canonical_to_number(pai.action_information17) Private_Use_Car,

65: --pai.action_information21 Saved_Amount_LSS,
66: --pai.action_information22 Employer_Child_Care,
67: --pai.action_information23 Allowance_on_Disability,
68: --pai.action_information24 Applied_LCLD,
69: fnd_number.canonical_to_number(pai.action_information17) Private_Use_Car,
70: fnd_number.canonical_to_number(pai.action_information16) Net_Expense_Allowance,
71: fnd_number.canonical_to_number(pai.action_information19) ZVW_Basis,
72: fnd_number.canonical_to_number(pai.action_information20) Value_Private_Use_Car,
73: fnd_number.canonical_to_number(pai.action_information21) Saved_Amount_LSS,

Line 70: fnd_number.canonical_to_number(pai.action_information16) Net_Expense_Allowance,

66: --pai.action_information22 Employer_Child_Care,
67: --pai.action_information23 Allowance_on_Disability,
68: --pai.action_information24 Applied_LCLD,
69: fnd_number.canonical_to_number(pai.action_information17) Private_Use_Car,
70: fnd_number.canonical_to_number(pai.action_information16) Net_Expense_Allowance,
71: fnd_number.canonical_to_number(pai.action_information19) ZVW_Basis,
72: fnd_number.canonical_to_number(pai.action_information20) Value_Private_Use_Car,
73: fnd_number.canonical_to_number(pai.action_information21) Saved_Amount_LSS,
74: fnd_number.canonical_to_number(pai.action_information22) Employer_Child_Care,

Line 71: fnd_number.canonical_to_number(pai.action_information19) ZVW_Basis,

67: --pai.action_information23 Allowance_on_Disability,
68: --pai.action_information24 Applied_LCLD,
69: fnd_number.canonical_to_number(pai.action_information17) Private_Use_Car,
70: fnd_number.canonical_to_number(pai.action_information16) Net_Expense_Allowance,
71: fnd_number.canonical_to_number(pai.action_information19) ZVW_Basis,
72: fnd_number.canonical_to_number(pai.action_information20) Value_Private_Use_Car,
73: fnd_number.canonical_to_number(pai.action_information21) Saved_Amount_LSS,
74: fnd_number.canonical_to_number(pai.action_information22) Employer_Child_Care,
75: fnd_number.canonical_to_number(pai.action_information23) Allowance_on_Disability,

Line 72: fnd_number.canonical_to_number(pai.action_information20) Value_Private_Use_Car,

68: --pai.action_information24 Applied_LCLD,
69: fnd_number.canonical_to_number(pai.action_information17) Private_Use_Car,
70: fnd_number.canonical_to_number(pai.action_information16) Net_Expense_Allowance,
71: fnd_number.canonical_to_number(pai.action_information19) ZVW_Basis,
72: fnd_number.canonical_to_number(pai.action_information20) Value_Private_Use_Car,
73: fnd_number.canonical_to_number(pai.action_information21) Saved_Amount_LSS,
74: fnd_number.canonical_to_number(pai.action_information22) Employer_Child_Care,
75: fnd_number.canonical_to_number(pai.action_information23) Allowance_on_Disability,
76: fnd_number.canonical_to_number(pai.action_information24) Applied_LCLD,

Line 73: fnd_number.canonical_to_number(pai.action_information21) Saved_Amount_LSS,

69: fnd_number.canonical_to_number(pai.action_information17) Private_Use_Car,
70: fnd_number.canonical_to_number(pai.action_information16) Net_Expense_Allowance,
71: fnd_number.canonical_to_number(pai.action_information19) ZVW_Basis,
72: fnd_number.canonical_to_number(pai.action_information20) Value_Private_Use_Car,
73: fnd_number.canonical_to_number(pai.action_information21) Saved_Amount_LSS,
74: fnd_number.canonical_to_number(pai.action_information22) Employer_Child_Care,
75: fnd_number.canonical_to_number(pai.action_information23) Allowance_on_Disability,
76: fnd_number.canonical_to_number(pai.action_information24) Applied_LCLD,
77: --11886537 ends

Line 74: fnd_number.canonical_to_number(pai.action_information22) Employer_Child_Care,

70: fnd_number.canonical_to_number(pai.action_information16) Net_Expense_Allowance,
71: fnd_number.canonical_to_number(pai.action_information19) ZVW_Basis,
72: fnd_number.canonical_to_number(pai.action_information20) Value_Private_Use_Car,
73: fnd_number.canonical_to_number(pai.action_information21) Saved_Amount_LSS,
74: fnd_number.canonical_to_number(pai.action_information22) Employer_Child_Care,
75: fnd_number.canonical_to_number(pai.action_information23) Allowance_on_Disability,
76: fnd_number.canonical_to_number(pai.action_information24) Applied_LCLD,
77: --11886537 ends
78: pai.action_information25 User_Bal_String

Line 75: fnd_number.canonical_to_number(pai.action_information23) Allowance_on_Disability,

71: fnd_number.canonical_to_number(pai.action_information19) ZVW_Basis,
72: fnd_number.canonical_to_number(pai.action_information20) Value_Private_Use_Car,
73: fnd_number.canonical_to_number(pai.action_information21) Saved_Amount_LSS,
74: fnd_number.canonical_to_number(pai.action_information22) Employer_Child_Care,
75: fnd_number.canonical_to_number(pai.action_information23) Allowance_on_Disability,
76: fnd_number.canonical_to_number(pai.action_information24) Applied_LCLD,
77: --11886537 ends
78: pai.action_information25 User_Bal_String
79: from

Line 76: fnd_number.canonical_to_number(pai.action_information24) Applied_LCLD,

72: fnd_number.canonical_to_number(pai.action_information20) Value_Private_Use_Car,
73: fnd_number.canonical_to_number(pai.action_information21) Saved_Amount_LSS,
74: fnd_number.canonical_to_number(pai.action_information22) Employer_Child_Care,
75: fnd_number.canonical_to_number(pai.action_information23) Allowance_on_Disability,
76: fnd_number.canonical_to_number(pai.action_information24) Applied_LCLD,
77: --11886537 ends
78: pai.action_information25 User_Bal_String
79: from
80: pay_assignment_actions assact,

Line 98: and decode(pai.action_information_category,'NL ATS EMPLOYEE DETAILS',fnd_number.canonical_to_number(pai.action_information2),null) = nvl(p_person_id,pap.person_id)

94: and ppos.person_id = pap.person_id
95: and ppos.date_start <= lp_Tax_Year_End_Date
96: --and nvl(ppos.actual_termination_date, lp_Tax_Year_End_Date) >= lp_Tax_Year_Start_Date
97: and pai.action_information1 = to_char(p_employer_id)
98: and decode(pai.action_information_category,'NL ATS EMPLOYEE DETAILS',fnd_number.canonical_to_number(pai.action_information2),null) = nvl(p_person_id,pap.person_id)
99: and decode(pai.action_information_category,'NL ATS EMPLOYEE DETAILS',fnd_number.canonical_to_number(pai.action_information3),null) = paa.assignment_id
100: and pai.effective_date = lp_Tax_Year_End_Date
101: and paa.effective_start_date =
102: (

Line 99: and decode(pai.action_information_category,'NL ATS EMPLOYEE DETAILS',fnd_number.canonical_to_number(pai.action_information3),null) = paa.assignment_id

95: and ppos.date_start <= lp_Tax_Year_End_Date
96: --and nvl(ppos.actual_termination_date, lp_Tax_Year_End_Date) >= lp_Tax_Year_Start_Date
97: and pai.action_information1 = to_char(p_employer_id)
98: and decode(pai.action_information_category,'NL ATS EMPLOYEE DETAILS',fnd_number.canonical_to_number(pai.action_information2),null) = nvl(p_person_id,pap.person_id)
99: and decode(pai.action_information_category,'NL ATS EMPLOYEE DETAILS',fnd_number.canonical_to_number(pai.action_information3),null) = paa.assignment_id
100: and pai.effective_date = lp_Tax_Year_End_Date
101: and paa.effective_start_date =
102: (
103: SELECT MIN(asg.effective_start_date)

Line 605: l_taxable_income:=fnd_number.canonical_to_number(info_rec.taxable_income) + l_taxable_income;

601: if p_agg_flag = 'Y' then
602:
603: if l_person_id = l_previous_person_id AND l_period_of_service = l_prev_period_of_service then
604:
605: l_taxable_income:=fnd_number.canonical_to_number(info_rec.taxable_income) + l_taxable_income;
606: l_deducted_wage_tax:=fnd_number.canonical_to_number(info_rec.deducted_wage_tax) + l_deducted_wage_tax;
607: l_labour_tax_reduction:=fnd_number.canonical_to_number(info_rec.labour_tax_reduction) + l_labour_tax_reduction;
608: l_ZVW:=fnd_number.canonical_to_number(info_rec.ZVW_Cont) + l_ZVW;
609: l_ZVW_Basis:=fnd_number.canonical_to_number(info_rec.ZVW_Basis) + l_ZVW_Basis;

Line 606: l_deducted_wage_tax:=fnd_number.canonical_to_number(info_rec.deducted_wage_tax) + l_deducted_wage_tax;

602:
603: if l_person_id = l_previous_person_id AND l_period_of_service = l_prev_period_of_service then
604:
605: l_taxable_income:=fnd_number.canonical_to_number(info_rec.taxable_income) + l_taxable_income;
606: l_deducted_wage_tax:=fnd_number.canonical_to_number(info_rec.deducted_wage_tax) + l_deducted_wage_tax;
607: l_labour_tax_reduction:=fnd_number.canonical_to_number(info_rec.labour_tax_reduction) + l_labour_tax_reduction;
608: l_ZVW:=fnd_number.canonical_to_number(info_rec.ZVW_Cont) + l_ZVW;
609: l_ZVW_Basis:=fnd_number.canonical_to_number(info_rec.ZVW_Basis) + l_ZVW_Basis;
610: l_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Private_Use_Car) + l_Private_Use_Car;

Line 607: l_labour_tax_reduction:=fnd_number.canonical_to_number(info_rec.labour_tax_reduction) + l_labour_tax_reduction;

603: if l_person_id = l_previous_person_id AND l_period_of_service = l_prev_period_of_service then
604:
605: l_taxable_income:=fnd_number.canonical_to_number(info_rec.taxable_income) + l_taxable_income;
606: l_deducted_wage_tax:=fnd_number.canonical_to_number(info_rec.deducted_wage_tax) + l_deducted_wage_tax;
607: l_labour_tax_reduction:=fnd_number.canonical_to_number(info_rec.labour_tax_reduction) + l_labour_tax_reduction;
608: l_ZVW:=fnd_number.canonical_to_number(info_rec.ZVW_Cont) + l_ZVW;
609: l_ZVW_Basis:=fnd_number.canonical_to_number(info_rec.ZVW_Basis) + l_ZVW_Basis;
610: l_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Private_Use_Car) + l_Private_Use_Car;
611: l_Net_Expense_Allowance:=fnd_number.canonical_to_number(info_rec.Net_Expense_Allowance) + l_Net_Expense_Allowance;

Line 608: l_ZVW:=fnd_number.canonical_to_number(info_rec.ZVW_Cont) + l_ZVW;

604:
605: l_taxable_income:=fnd_number.canonical_to_number(info_rec.taxable_income) + l_taxable_income;
606: l_deducted_wage_tax:=fnd_number.canonical_to_number(info_rec.deducted_wage_tax) + l_deducted_wage_tax;
607: l_labour_tax_reduction:=fnd_number.canonical_to_number(info_rec.labour_tax_reduction) + l_labour_tax_reduction;
608: l_ZVW:=fnd_number.canonical_to_number(info_rec.ZVW_Cont) + l_ZVW;
609: l_ZVW_Basis:=fnd_number.canonical_to_number(info_rec.ZVW_Basis) + l_ZVW_Basis;
610: l_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Private_Use_Car) + l_Private_Use_Car;
611: l_Net_Expense_Allowance:=fnd_number.canonical_to_number(info_rec.Net_Expense_Allowance) + l_Net_Expense_Allowance;
612: l_Value_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Value_Private_Use_Car) + l_Value_Private_Use_Car;

Line 609: l_ZVW_Basis:=fnd_number.canonical_to_number(info_rec.ZVW_Basis) + l_ZVW_Basis;

605: l_taxable_income:=fnd_number.canonical_to_number(info_rec.taxable_income) + l_taxable_income;
606: l_deducted_wage_tax:=fnd_number.canonical_to_number(info_rec.deducted_wage_tax) + l_deducted_wage_tax;
607: l_labour_tax_reduction:=fnd_number.canonical_to_number(info_rec.labour_tax_reduction) + l_labour_tax_reduction;
608: l_ZVW:=fnd_number.canonical_to_number(info_rec.ZVW_Cont) + l_ZVW;
609: l_ZVW_Basis:=fnd_number.canonical_to_number(info_rec.ZVW_Basis) + l_ZVW_Basis;
610: l_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Private_Use_Car) + l_Private_Use_Car;
611: l_Net_Expense_Allowance:=fnd_number.canonical_to_number(info_rec.Net_Expense_Allowance) + l_Net_Expense_Allowance;
612: l_Value_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Value_Private_Use_Car) + l_Value_Private_Use_Car;
613: l_Saved_Amount_LSS:=fnd_number.canonical_to_number(info_rec.Saved_Amount_LSS) + l_Saved_Amount_LSS;

Line 610: l_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Private_Use_Car) + l_Private_Use_Car;

606: l_deducted_wage_tax:=fnd_number.canonical_to_number(info_rec.deducted_wage_tax) + l_deducted_wage_tax;
607: l_labour_tax_reduction:=fnd_number.canonical_to_number(info_rec.labour_tax_reduction) + l_labour_tax_reduction;
608: l_ZVW:=fnd_number.canonical_to_number(info_rec.ZVW_Cont) + l_ZVW;
609: l_ZVW_Basis:=fnd_number.canonical_to_number(info_rec.ZVW_Basis) + l_ZVW_Basis;
610: l_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Private_Use_Car) + l_Private_Use_Car;
611: l_Net_Expense_Allowance:=fnd_number.canonical_to_number(info_rec.Net_Expense_Allowance) + l_Net_Expense_Allowance;
612: l_Value_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Value_Private_Use_Car) + l_Value_Private_Use_Car;
613: l_Saved_Amount_LSS:=fnd_number.canonical_to_number(info_rec.Saved_Amount_LSS) + l_Saved_Amount_LSS;
614: l_Employer_Child_Care:=fnd_number.canonical_to_number(info_rec.Employer_Child_Care) + l_Employer_Child_Care;

Line 611: l_Net_Expense_Allowance:=fnd_number.canonical_to_number(info_rec.Net_Expense_Allowance) + l_Net_Expense_Allowance;

607: l_labour_tax_reduction:=fnd_number.canonical_to_number(info_rec.labour_tax_reduction) + l_labour_tax_reduction;
608: l_ZVW:=fnd_number.canonical_to_number(info_rec.ZVW_Cont) + l_ZVW;
609: l_ZVW_Basis:=fnd_number.canonical_to_number(info_rec.ZVW_Basis) + l_ZVW_Basis;
610: l_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Private_Use_Car) + l_Private_Use_Car;
611: l_Net_Expense_Allowance:=fnd_number.canonical_to_number(info_rec.Net_Expense_Allowance) + l_Net_Expense_Allowance;
612: l_Value_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Value_Private_Use_Car) + l_Value_Private_Use_Car;
613: l_Saved_Amount_LSS:=fnd_number.canonical_to_number(info_rec.Saved_Amount_LSS) + l_Saved_Amount_LSS;
614: l_Employer_Child_Care:=fnd_number.canonical_to_number(info_rec.Employer_Child_Care) + l_Employer_Child_Care;
615: l_Allowance_on_Disability:=fnd_number.canonical_to_number(info_rec.Allowance_on_Disability) + l_Allowance_on_Disability;

Line 612: l_Value_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Value_Private_Use_Car) + l_Value_Private_Use_Car;

608: l_ZVW:=fnd_number.canonical_to_number(info_rec.ZVW_Cont) + l_ZVW;
609: l_ZVW_Basis:=fnd_number.canonical_to_number(info_rec.ZVW_Basis) + l_ZVW_Basis;
610: l_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Private_Use_Car) + l_Private_Use_Car;
611: l_Net_Expense_Allowance:=fnd_number.canonical_to_number(info_rec.Net_Expense_Allowance) + l_Net_Expense_Allowance;
612: l_Value_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Value_Private_Use_Car) + l_Value_Private_Use_Car;
613: l_Saved_Amount_LSS:=fnd_number.canonical_to_number(info_rec.Saved_Amount_LSS) + l_Saved_Amount_LSS;
614: l_Employer_Child_Care:=fnd_number.canonical_to_number(info_rec.Employer_Child_Care) + l_Employer_Child_Care;
615: l_Allowance_on_Disability:=fnd_number.canonical_to_number(info_rec.Allowance_on_Disability) + l_Allowance_on_Disability;
616: l_Applied_LCLD:=fnd_number.canonical_to_number(info_rec.Applied_LCLD) + l_Applied_LCLD;

Line 613: l_Saved_Amount_LSS:=fnd_number.canonical_to_number(info_rec.Saved_Amount_LSS) + l_Saved_Amount_LSS;

609: l_ZVW_Basis:=fnd_number.canonical_to_number(info_rec.ZVW_Basis) + l_ZVW_Basis;
610: l_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Private_Use_Car) + l_Private_Use_Car;
611: l_Net_Expense_Allowance:=fnd_number.canonical_to_number(info_rec.Net_Expense_Allowance) + l_Net_Expense_Allowance;
612: l_Value_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Value_Private_Use_Car) + l_Value_Private_Use_Car;
613: l_Saved_Amount_LSS:=fnd_number.canonical_to_number(info_rec.Saved_Amount_LSS) + l_Saved_Amount_LSS;
614: l_Employer_Child_Care:=fnd_number.canonical_to_number(info_rec.Employer_Child_Care) + l_Employer_Child_Care;
615: l_Allowance_on_Disability:=fnd_number.canonical_to_number(info_rec.Allowance_on_Disability) + l_Allowance_on_Disability;
616: l_Applied_LCLD:=fnd_number.canonical_to_number(info_rec.Applied_LCLD) + l_Applied_LCLD;
617: populate_UserBalVal(info_rec.User_Bal_String,'Y');

Line 614: l_Employer_Child_Care:=fnd_number.canonical_to_number(info_rec.Employer_Child_Care) + l_Employer_Child_Care;

610: l_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Private_Use_Car) + l_Private_Use_Car;
611: l_Net_Expense_Allowance:=fnd_number.canonical_to_number(info_rec.Net_Expense_Allowance) + l_Net_Expense_Allowance;
612: l_Value_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Value_Private_Use_Car) + l_Value_Private_Use_Car;
613: l_Saved_Amount_LSS:=fnd_number.canonical_to_number(info_rec.Saved_Amount_LSS) + l_Saved_Amount_LSS;
614: l_Employer_Child_Care:=fnd_number.canonical_to_number(info_rec.Employer_Child_Care) + l_Employer_Child_Care;
615: l_Allowance_on_Disability:=fnd_number.canonical_to_number(info_rec.Allowance_on_Disability) + l_Allowance_on_Disability;
616: l_Applied_LCLD:=fnd_number.canonical_to_number(info_rec.Applied_LCLD) + l_Applied_LCLD;
617: populate_UserBalVal(info_rec.User_Bal_String,'Y');
618:

Line 615: l_Allowance_on_Disability:=fnd_number.canonical_to_number(info_rec.Allowance_on_Disability) + l_Allowance_on_Disability;

611: l_Net_Expense_Allowance:=fnd_number.canonical_to_number(info_rec.Net_Expense_Allowance) + l_Net_Expense_Allowance;
612: l_Value_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Value_Private_Use_Car) + l_Value_Private_Use_Car;
613: l_Saved_Amount_LSS:=fnd_number.canonical_to_number(info_rec.Saved_Amount_LSS) + l_Saved_Amount_LSS;
614: l_Employer_Child_Care:=fnd_number.canonical_to_number(info_rec.Employer_Child_Care) + l_Employer_Child_Care;
615: l_Allowance_on_Disability:=fnd_number.canonical_to_number(info_rec.Allowance_on_Disability) + l_Allowance_on_Disability;
616: l_Applied_LCLD:=fnd_number.canonical_to_number(info_rec.Applied_LCLD) + l_Applied_LCLD;
617: populate_UserBalVal(info_rec.User_Bal_String,'Y');
618:
619: end if;

Line 616: l_Applied_LCLD:=fnd_number.canonical_to_number(info_rec.Applied_LCLD) + l_Applied_LCLD;

612: l_Value_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Value_Private_Use_Car) + l_Value_Private_Use_Car;
613: l_Saved_Amount_LSS:=fnd_number.canonical_to_number(info_rec.Saved_Amount_LSS) + l_Saved_Amount_LSS;
614: l_Employer_Child_Care:=fnd_number.canonical_to_number(info_rec.Employer_Child_Care) + l_Employer_Child_Care;
615: l_Allowance_on_Disability:=fnd_number.canonical_to_number(info_rec.Allowance_on_Disability) + l_Allowance_on_Disability;
616: l_Applied_LCLD:=fnd_number.canonical_to_number(info_rec.Applied_LCLD) + l_Applied_LCLD;
617: populate_UserBalVal(info_rec.User_Bal_String,'Y');
618:
619: end if;
620:

Line 718: l_taxable_income:=fnd_number.canonical_to_number(info_rec.taxable_income);

714: vUserBalVal.DELETE;
715:
716: end if;
717:
718: l_taxable_income:=fnd_number.canonical_to_number(info_rec.taxable_income);
719: l_deducted_wage_tax:=fnd_number.canonical_to_number(info_rec.deducted_wage_tax);
720: l_labour_tax_reduction:=fnd_number.canonical_to_number(info_rec.labour_tax_reduction);
721: l_ZVW:=fnd_number.canonical_to_number(info_rec.ZVW_Cont);
722: l_ZVW_Basis:=fnd_number.canonical_to_number(info_rec.ZVW_Basis);

Line 719: l_deducted_wage_tax:=fnd_number.canonical_to_number(info_rec.deducted_wage_tax);

715:
716: end if;
717:
718: l_taxable_income:=fnd_number.canonical_to_number(info_rec.taxable_income);
719: l_deducted_wage_tax:=fnd_number.canonical_to_number(info_rec.deducted_wage_tax);
720: l_labour_tax_reduction:=fnd_number.canonical_to_number(info_rec.labour_tax_reduction);
721: l_ZVW:=fnd_number.canonical_to_number(info_rec.ZVW_Cont);
722: l_ZVW_Basis:=fnd_number.canonical_to_number(info_rec.ZVW_Basis);
723: l_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Private_Use_Car);

Line 720: l_labour_tax_reduction:=fnd_number.canonical_to_number(info_rec.labour_tax_reduction);

716: end if;
717:
718: l_taxable_income:=fnd_number.canonical_to_number(info_rec.taxable_income);
719: l_deducted_wage_tax:=fnd_number.canonical_to_number(info_rec.deducted_wage_tax);
720: l_labour_tax_reduction:=fnd_number.canonical_to_number(info_rec.labour_tax_reduction);
721: l_ZVW:=fnd_number.canonical_to_number(info_rec.ZVW_Cont);
722: l_ZVW_Basis:=fnd_number.canonical_to_number(info_rec.ZVW_Basis);
723: l_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Private_Use_Car);
724: l_Net_Expense_Allowance:=fnd_number.canonical_to_number(info_rec.Net_Expense_Allowance);

Line 721: l_ZVW:=fnd_number.canonical_to_number(info_rec.ZVW_Cont);

717:
718: l_taxable_income:=fnd_number.canonical_to_number(info_rec.taxable_income);
719: l_deducted_wage_tax:=fnd_number.canonical_to_number(info_rec.deducted_wage_tax);
720: l_labour_tax_reduction:=fnd_number.canonical_to_number(info_rec.labour_tax_reduction);
721: l_ZVW:=fnd_number.canonical_to_number(info_rec.ZVW_Cont);
722: l_ZVW_Basis:=fnd_number.canonical_to_number(info_rec.ZVW_Basis);
723: l_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Private_Use_Car);
724: l_Net_Expense_Allowance:=fnd_number.canonical_to_number(info_rec.Net_Expense_Allowance);
725: l_Value_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Value_Private_Use_Car);

Line 722: l_ZVW_Basis:=fnd_number.canonical_to_number(info_rec.ZVW_Basis);

718: l_taxable_income:=fnd_number.canonical_to_number(info_rec.taxable_income);
719: l_deducted_wage_tax:=fnd_number.canonical_to_number(info_rec.deducted_wage_tax);
720: l_labour_tax_reduction:=fnd_number.canonical_to_number(info_rec.labour_tax_reduction);
721: l_ZVW:=fnd_number.canonical_to_number(info_rec.ZVW_Cont);
722: l_ZVW_Basis:=fnd_number.canonical_to_number(info_rec.ZVW_Basis);
723: l_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Private_Use_Car);
724: l_Net_Expense_Allowance:=fnd_number.canonical_to_number(info_rec.Net_Expense_Allowance);
725: l_Value_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Value_Private_Use_Car);
726: l_Saved_Amount_LSS:=fnd_number.canonical_to_number(info_rec.Saved_Amount_LSS);

Line 723: l_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Private_Use_Car);

719: l_deducted_wage_tax:=fnd_number.canonical_to_number(info_rec.deducted_wage_tax);
720: l_labour_tax_reduction:=fnd_number.canonical_to_number(info_rec.labour_tax_reduction);
721: l_ZVW:=fnd_number.canonical_to_number(info_rec.ZVW_Cont);
722: l_ZVW_Basis:=fnd_number.canonical_to_number(info_rec.ZVW_Basis);
723: l_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Private_Use_Car);
724: l_Net_Expense_Allowance:=fnd_number.canonical_to_number(info_rec.Net_Expense_Allowance);
725: l_Value_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Value_Private_Use_Car);
726: l_Saved_Amount_LSS:=fnd_number.canonical_to_number(info_rec.Saved_Amount_LSS);
727: l_Employer_Child_Care:=fnd_number.canonical_to_number(info_rec.Employer_Child_Care);

Line 724: l_Net_Expense_Allowance:=fnd_number.canonical_to_number(info_rec.Net_Expense_Allowance);

720: l_labour_tax_reduction:=fnd_number.canonical_to_number(info_rec.labour_tax_reduction);
721: l_ZVW:=fnd_number.canonical_to_number(info_rec.ZVW_Cont);
722: l_ZVW_Basis:=fnd_number.canonical_to_number(info_rec.ZVW_Basis);
723: l_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Private_Use_Car);
724: l_Net_Expense_Allowance:=fnd_number.canonical_to_number(info_rec.Net_Expense_Allowance);
725: l_Value_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Value_Private_Use_Car);
726: l_Saved_Amount_LSS:=fnd_number.canonical_to_number(info_rec.Saved_Amount_LSS);
727: l_Employer_Child_Care:=fnd_number.canonical_to_number(info_rec.Employer_Child_Care);
728: l_Allowance_on_Disability:=fnd_number.canonical_to_number(info_rec.Allowance_on_Disability);

Line 725: l_Value_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Value_Private_Use_Car);

721: l_ZVW:=fnd_number.canonical_to_number(info_rec.ZVW_Cont);
722: l_ZVW_Basis:=fnd_number.canonical_to_number(info_rec.ZVW_Basis);
723: l_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Private_Use_Car);
724: l_Net_Expense_Allowance:=fnd_number.canonical_to_number(info_rec.Net_Expense_Allowance);
725: l_Value_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Value_Private_Use_Car);
726: l_Saved_Amount_LSS:=fnd_number.canonical_to_number(info_rec.Saved_Amount_LSS);
727: l_Employer_Child_Care:=fnd_number.canonical_to_number(info_rec.Employer_Child_Care);
728: l_Allowance_on_Disability:=fnd_number.canonical_to_number(info_rec.Allowance_on_Disability);
729: l_Applied_LCLD:=fnd_number.canonical_to_number(info_rec.Applied_LCLD);

Line 726: l_Saved_Amount_LSS:=fnd_number.canonical_to_number(info_rec.Saved_Amount_LSS);

722: l_ZVW_Basis:=fnd_number.canonical_to_number(info_rec.ZVW_Basis);
723: l_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Private_Use_Car);
724: l_Net_Expense_Allowance:=fnd_number.canonical_to_number(info_rec.Net_Expense_Allowance);
725: l_Value_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Value_Private_Use_Car);
726: l_Saved_Amount_LSS:=fnd_number.canonical_to_number(info_rec.Saved_Amount_LSS);
727: l_Employer_Child_Care:=fnd_number.canonical_to_number(info_rec.Employer_Child_Care);
728: l_Allowance_on_Disability:=fnd_number.canonical_to_number(info_rec.Allowance_on_Disability);
729: l_Applied_LCLD:=fnd_number.canonical_to_number(info_rec.Applied_LCLD);
730: populate_UserBalVal(info_rec.User_Bal_String,'N');

Line 727: l_Employer_Child_Care:=fnd_number.canonical_to_number(info_rec.Employer_Child_Care);

723: l_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Private_Use_Car);
724: l_Net_Expense_Allowance:=fnd_number.canonical_to_number(info_rec.Net_Expense_Allowance);
725: l_Value_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Value_Private_Use_Car);
726: l_Saved_Amount_LSS:=fnd_number.canonical_to_number(info_rec.Saved_Amount_LSS);
727: l_Employer_Child_Care:=fnd_number.canonical_to_number(info_rec.Employer_Child_Care);
728: l_Allowance_on_Disability:=fnd_number.canonical_to_number(info_rec.Allowance_on_Disability);
729: l_Applied_LCLD:=fnd_number.canonical_to_number(info_rec.Applied_LCLD);
730: populate_UserBalVal(info_rec.User_Bal_String,'N');
731:

Line 728: l_Allowance_on_Disability:=fnd_number.canonical_to_number(info_rec.Allowance_on_Disability);

724: l_Net_Expense_Allowance:=fnd_number.canonical_to_number(info_rec.Net_Expense_Allowance);
725: l_Value_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Value_Private_Use_Car);
726: l_Saved_Amount_LSS:=fnd_number.canonical_to_number(info_rec.Saved_Amount_LSS);
727: l_Employer_Child_Care:=fnd_number.canonical_to_number(info_rec.Employer_Child_Care);
728: l_Allowance_on_Disability:=fnd_number.canonical_to_number(info_rec.Allowance_on_Disability);
729: l_Applied_LCLD:=fnd_number.canonical_to_number(info_rec.Applied_LCLD);
730: populate_UserBalVal(info_rec.User_Bal_String,'N');
731:
732:

Line 729: l_Applied_LCLD:=fnd_number.canonical_to_number(info_rec.Applied_LCLD);

725: l_Value_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Value_Private_Use_Car);
726: l_Saved_Amount_LSS:=fnd_number.canonical_to_number(info_rec.Saved_Amount_LSS);
727: l_Employer_Child_Care:=fnd_number.canonical_to_number(info_rec.Employer_Child_Care);
728: l_Allowance_on_Disability:=fnd_number.canonical_to_number(info_rec.Allowance_on_Disability);
729: l_Applied_LCLD:=fnd_number.canonical_to_number(info_rec.Applied_LCLD);
730: populate_UserBalVal(info_rec.User_Bal_String,'N');
731:
732:
733:

Line 1679: NVL(fnd_number.canonical_to_number(pai.action_information18),fnd_number.canonical_to_number(pai.action_information4)) Taxable_Income,

1675: --11886537 begins
1676: --NVL(pai.action_information18,pai.action_information4) Taxable_Income,
1677: --pai.action_Information5 Deducted_Wage_Tax,
1678: --pai.action_information8 Labour_Tax_Reduction,
1679: NVL(fnd_number.canonical_to_number(pai.action_information18),fnd_number.canonical_to_number(pai.action_information4)) Taxable_Income,
1680: fnd_number.canonical_to_number(pai.action_Information5) Deducted_Wage_Tax,
1681: fnd_number.canonical_to_number(pai.action_information8) Labour_Tax_Reduction,
1682: --11886537 ends
1683: decode(substr(pai.action_information14,1,1),'1',lp_yes,2,lp_yes,3,lp_yes,lp_no) Insured_For_WAO,

Line 1680: fnd_number.canonical_to_number(pai.action_Information5) Deducted_Wage_Tax,

1676: --NVL(pai.action_information18,pai.action_information4) Taxable_Income,
1677: --pai.action_Information5 Deducted_Wage_Tax,
1678: --pai.action_information8 Labour_Tax_Reduction,
1679: NVL(fnd_number.canonical_to_number(pai.action_information18),fnd_number.canonical_to_number(pai.action_information4)) Taxable_Income,
1680: fnd_number.canonical_to_number(pai.action_Information5) Deducted_Wage_Tax,
1681: fnd_number.canonical_to_number(pai.action_information8) Labour_Tax_Reduction,
1682: --11886537 ends
1683: decode(substr(pai.action_information14,1,1),'1',lp_yes,2,lp_yes,3,lp_yes,lp_no) Insured_For_WAO,
1684: --decode(substr(pai.action_information14,2,1),'1',lp_yes,2,lp_yes,3,lp_yes,lp_no) Insured_For_ZFW,

Line 1681: fnd_number.canonical_to_number(pai.action_information8) Labour_Tax_Reduction,

1677: --pai.action_Information5 Deducted_Wage_Tax,
1678: --pai.action_information8 Labour_Tax_Reduction,
1679: NVL(fnd_number.canonical_to_number(pai.action_information18),fnd_number.canonical_to_number(pai.action_information4)) Taxable_Income,
1680: fnd_number.canonical_to_number(pai.action_Information5) Deducted_Wage_Tax,
1681: fnd_number.canonical_to_number(pai.action_information8) Labour_Tax_Reduction,
1682: --11886537 ends
1683: decode(substr(pai.action_information14,1,1),'1',lp_yes,2,lp_yes,3,lp_yes,lp_no) Insured_For_WAO,
1684: --decode(substr(pai.action_information14,2,1),'1',lp_yes,2,lp_yes,3,lp_yes,lp_no) Insured_For_ZFW,
1685: --pai.action_information15 ZVW_Cont, --11886537

Line 1686: fnd_number.canonical_to_number(pai.action_information15) ZVW_Cont, --11886537

1682: --11886537 ends
1683: decode(substr(pai.action_information14,1,1),'1',lp_yes,2,lp_yes,3,lp_yes,lp_no) Insured_For_WAO,
1684: --decode(substr(pai.action_information14,2,1),'1',lp_yes,2,lp_yes,3,lp_yes,lp_no) Insured_For_ZFW,
1685: --pai.action_information15 ZVW_Cont, --11886537
1686: fnd_number.canonical_to_number(pai.action_information15) ZVW_Cont, --11886537
1687: substr(pai.action_information12,13,1) Company_Car,
1688: --11886537 begins
1689: --pai.action_information17 Private_Use_Car,
1690: --pai.action_information16 Net_Expense_Allowance,

Line 1697: fnd_number.canonical_to_number(pai.action_information17) Private_Use_Car,

1693: --pai.action_information21 Saved_Amount_LSS,
1694: --pai.action_information22 Employer_Child_Care,
1695: --pai.action_information23 Allowance_on_Disability,
1696: --pai.action_information24 Applied_LCLD,
1697: fnd_number.canonical_to_number(pai.action_information17) Private_Use_Car,
1698: fnd_number.canonical_to_number(pai.action_information16) Net_Expense_Allowance,
1699: fnd_number.canonical_to_number(pai.action_information19) ZVW_Basis,
1700: fnd_number.canonical_to_number(pai.action_information20) Value_Private_Use_Car,
1701: fnd_number.canonical_to_number(pai.action_information21) Saved_Amount_LSS,

Line 1698: fnd_number.canonical_to_number(pai.action_information16) Net_Expense_Allowance,

1694: --pai.action_information22 Employer_Child_Care,
1695: --pai.action_information23 Allowance_on_Disability,
1696: --pai.action_information24 Applied_LCLD,
1697: fnd_number.canonical_to_number(pai.action_information17) Private_Use_Car,
1698: fnd_number.canonical_to_number(pai.action_information16) Net_Expense_Allowance,
1699: fnd_number.canonical_to_number(pai.action_information19) ZVW_Basis,
1700: fnd_number.canonical_to_number(pai.action_information20) Value_Private_Use_Car,
1701: fnd_number.canonical_to_number(pai.action_information21) Saved_Amount_LSS,
1702: fnd_number.canonical_to_number(pai.action_information22) Employer_Child_Care,

Line 1699: fnd_number.canonical_to_number(pai.action_information19) ZVW_Basis,

1695: --pai.action_information23 Allowance_on_Disability,
1696: --pai.action_information24 Applied_LCLD,
1697: fnd_number.canonical_to_number(pai.action_information17) Private_Use_Car,
1698: fnd_number.canonical_to_number(pai.action_information16) Net_Expense_Allowance,
1699: fnd_number.canonical_to_number(pai.action_information19) ZVW_Basis,
1700: fnd_number.canonical_to_number(pai.action_information20) Value_Private_Use_Car,
1701: fnd_number.canonical_to_number(pai.action_information21) Saved_Amount_LSS,
1702: fnd_number.canonical_to_number(pai.action_information22) Employer_Child_Care,
1703: fnd_number.canonical_to_number(pai.action_information23) Allowance_on_Disability,

Line 1700: fnd_number.canonical_to_number(pai.action_information20) Value_Private_Use_Car,

1696: --pai.action_information24 Applied_LCLD,
1697: fnd_number.canonical_to_number(pai.action_information17) Private_Use_Car,
1698: fnd_number.canonical_to_number(pai.action_information16) Net_Expense_Allowance,
1699: fnd_number.canonical_to_number(pai.action_information19) ZVW_Basis,
1700: fnd_number.canonical_to_number(pai.action_information20) Value_Private_Use_Car,
1701: fnd_number.canonical_to_number(pai.action_information21) Saved_Amount_LSS,
1702: fnd_number.canonical_to_number(pai.action_information22) Employer_Child_Care,
1703: fnd_number.canonical_to_number(pai.action_information23) Allowance_on_Disability,
1704: fnd_number.canonical_to_number(pai.action_information24) Applied_LCLD,

Line 1701: fnd_number.canonical_to_number(pai.action_information21) Saved_Amount_LSS,

1697: fnd_number.canonical_to_number(pai.action_information17) Private_Use_Car,
1698: fnd_number.canonical_to_number(pai.action_information16) Net_Expense_Allowance,
1699: fnd_number.canonical_to_number(pai.action_information19) ZVW_Basis,
1700: fnd_number.canonical_to_number(pai.action_information20) Value_Private_Use_Car,
1701: fnd_number.canonical_to_number(pai.action_information21) Saved_Amount_LSS,
1702: fnd_number.canonical_to_number(pai.action_information22) Employer_Child_Care,
1703: fnd_number.canonical_to_number(pai.action_information23) Allowance_on_Disability,
1704: fnd_number.canonical_to_number(pai.action_information24) Applied_LCLD,
1705: --11886537 ends

Line 1702: fnd_number.canonical_to_number(pai.action_information22) Employer_Child_Care,

1698: fnd_number.canonical_to_number(pai.action_information16) Net_Expense_Allowance,
1699: fnd_number.canonical_to_number(pai.action_information19) ZVW_Basis,
1700: fnd_number.canonical_to_number(pai.action_information20) Value_Private_Use_Car,
1701: fnd_number.canonical_to_number(pai.action_information21) Saved_Amount_LSS,
1702: fnd_number.canonical_to_number(pai.action_information22) Employer_Child_Care,
1703: fnd_number.canonical_to_number(pai.action_information23) Allowance_on_Disability,
1704: fnd_number.canonical_to_number(pai.action_information24) Applied_LCLD,
1705: --11886537 ends
1706: pai.action_information25 User_Bal_String

Line 1703: fnd_number.canonical_to_number(pai.action_information23) Allowance_on_Disability,

1699: fnd_number.canonical_to_number(pai.action_information19) ZVW_Basis,
1700: fnd_number.canonical_to_number(pai.action_information20) Value_Private_Use_Car,
1701: fnd_number.canonical_to_number(pai.action_information21) Saved_Amount_LSS,
1702: fnd_number.canonical_to_number(pai.action_information22) Employer_Child_Care,
1703: fnd_number.canonical_to_number(pai.action_information23) Allowance_on_Disability,
1704: fnd_number.canonical_to_number(pai.action_information24) Applied_LCLD,
1705: --11886537 ends
1706: pai.action_information25 User_Bal_String
1707: from

Line 1704: fnd_number.canonical_to_number(pai.action_information24) Applied_LCLD,

1700: fnd_number.canonical_to_number(pai.action_information20) Value_Private_Use_Car,
1701: fnd_number.canonical_to_number(pai.action_information21) Saved_Amount_LSS,
1702: fnd_number.canonical_to_number(pai.action_information22) Employer_Child_Care,
1703: fnd_number.canonical_to_number(pai.action_information23) Allowance_on_Disability,
1704: fnd_number.canonical_to_number(pai.action_information24) Applied_LCLD,
1705: --11886537 ends
1706: pai.action_information25 User_Bal_String
1707: from
1708: pay_assignment_actions assact,

Line 1726: and decode(pai.action_information_category,'NL ATS EMPLOYEE DETAILS',fnd_number.canonical_to_number(pai.action_information2),null) = nvl(p_person_id,pap.person_id)

1722: and ppos.person_id = pap.person_id
1723: and ppos.date_start <= lp_Tax_Year_End_Date
1724: --and nvl(ppos.actual_termination_date, lp_Tax_Year_End_Date) >= lp_Tax_Year_Start_Date
1725: and pai.action_information1 = to_char(p_employer_id)
1726: and decode(pai.action_information_category,'NL ATS EMPLOYEE DETAILS',fnd_number.canonical_to_number(pai.action_information2),null) = nvl(p_person_id,pap.person_id)
1727: and decode(pai.action_information_category,'NL ATS EMPLOYEE DETAILS',fnd_number.canonical_to_number(pai.action_information3),null) = paa.assignment_id
1728: and pai.effective_date = lp_Tax_Year_End_Date
1729: and paa.effective_start_date =
1730: (

Line 1727: and decode(pai.action_information_category,'NL ATS EMPLOYEE DETAILS',fnd_number.canonical_to_number(pai.action_information3),null) = paa.assignment_id

1723: and ppos.date_start <= lp_Tax_Year_End_Date
1724: --and nvl(ppos.actual_termination_date, lp_Tax_Year_End_Date) >= lp_Tax_Year_Start_Date
1725: and pai.action_information1 = to_char(p_employer_id)
1726: and decode(pai.action_information_category,'NL ATS EMPLOYEE DETAILS',fnd_number.canonical_to_number(pai.action_information2),null) = nvl(p_person_id,pap.person_id)
1727: and decode(pai.action_information_category,'NL ATS EMPLOYEE DETAILS',fnd_number.canonical_to_number(pai.action_information3),null) = paa.assignment_id
1728: and pai.effective_date = lp_Tax_Year_End_Date
1729: and paa.effective_start_date =
1730: (
1731: SELECT MIN(asg.effective_start_date)

Line 2233: l_taxable_income:=fnd_number.canonical_to_number(info_rec.taxable_income) + l_taxable_income;

2229: if p_agg_flag = 'Y' then
2230:
2231: if l_person_id = l_previous_person_id AND l_period_of_service = l_prev_period_of_service then
2232:
2233: l_taxable_income:=fnd_number.canonical_to_number(info_rec.taxable_income) + l_taxable_income;
2234: l_deducted_wage_tax:=fnd_number.canonical_to_number(info_rec.deducted_wage_tax) + l_deducted_wage_tax;
2235: l_labour_tax_reduction:=fnd_number.canonical_to_number(info_rec.labour_tax_reduction) + l_labour_tax_reduction;
2236: l_ZVW:=fnd_number.canonical_to_number(info_rec.ZVW_Cont) + l_ZVW;
2237: l_ZVW_Basis:=fnd_number.canonical_to_number(info_rec.ZVW_Basis) + l_ZVW_Basis;

Line 2234: l_deducted_wage_tax:=fnd_number.canonical_to_number(info_rec.deducted_wage_tax) + l_deducted_wage_tax;

2230:
2231: if l_person_id = l_previous_person_id AND l_period_of_service = l_prev_period_of_service then
2232:
2233: l_taxable_income:=fnd_number.canonical_to_number(info_rec.taxable_income) + l_taxable_income;
2234: l_deducted_wage_tax:=fnd_number.canonical_to_number(info_rec.deducted_wage_tax) + l_deducted_wage_tax;
2235: l_labour_tax_reduction:=fnd_number.canonical_to_number(info_rec.labour_tax_reduction) + l_labour_tax_reduction;
2236: l_ZVW:=fnd_number.canonical_to_number(info_rec.ZVW_Cont) + l_ZVW;
2237: l_ZVW_Basis:=fnd_number.canonical_to_number(info_rec.ZVW_Basis) + l_ZVW_Basis;
2238: l_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Private_Use_Car) + l_Private_Use_Car;

Line 2235: l_labour_tax_reduction:=fnd_number.canonical_to_number(info_rec.labour_tax_reduction) + l_labour_tax_reduction;

2231: if l_person_id = l_previous_person_id AND l_period_of_service = l_prev_period_of_service then
2232:
2233: l_taxable_income:=fnd_number.canonical_to_number(info_rec.taxable_income) + l_taxable_income;
2234: l_deducted_wage_tax:=fnd_number.canonical_to_number(info_rec.deducted_wage_tax) + l_deducted_wage_tax;
2235: l_labour_tax_reduction:=fnd_number.canonical_to_number(info_rec.labour_tax_reduction) + l_labour_tax_reduction;
2236: l_ZVW:=fnd_number.canonical_to_number(info_rec.ZVW_Cont) + l_ZVW;
2237: l_ZVW_Basis:=fnd_number.canonical_to_number(info_rec.ZVW_Basis) + l_ZVW_Basis;
2238: l_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Private_Use_Car) + l_Private_Use_Car;
2239: l_Net_Expense_Allowance:=fnd_number.canonical_to_number(info_rec.Net_Expense_Allowance) + l_Net_Expense_Allowance;

Line 2236: l_ZVW:=fnd_number.canonical_to_number(info_rec.ZVW_Cont) + l_ZVW;

2232:
2233: l_taxable_income:=fnd_number.canonical_to_number(info_rec.taxable_income) + l_taxable_income;
2234: l_deducted_wage_tax:=fnd_number.canonical_to_number(info_rec.deducted_wage_tax) + l_deducted_wage_tax;
2235: l_labour_tax_reduction:=fnd_number.canonical_to_number(info_rec.labour_tax_reduction) + l_labour_tax_reduction;
2236: l_ZVW:=fnd_number.canonical_to_number(info_rec.ZVW_Cont) + l_ZVW;
2237: l_ZVW_Basis:=fnd_number.canonical_to_number(info_rec.ZVW_Basis) + l_ZVW_Basis;
2238: l_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Private_Use_Car) + l_Private_Use_Car;
2239: l_Net_Expense_Allowance:=fnd_number.canonical_to_number(info_rec.Net_Expense_Allowance) + l_Net_Expense_Allowance;
2240: l_Value_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Value_Private_Use_Car) + l_Value_Private_Use_Car;

Line 2237: l_ZVW_Basis:=fnd_number.canonical_to_number(info_rec.ZVW_Basis) + l_ZVW_Basis;

2233: l_taxable_income:=fnd_number.canonical_to_number(info_rec.taxable_income) + l_taxable_income;
2234: l_deducted_wage_tax:=fnd_number.canonical_to_number(info_rec.deducted_wage_tax) + l_deducted_wage_tax;
2235: l_labour_tax_reduction:=fnd_number.canonical_to_number(info_rec.labour_tax_reduction) + l_labour_tax_reduction;
2236: l_ZVW:=fnd_number.canonical_to_number(info_rec.ZVW_Cont) + l_ZVW;
2237: l_ZVW_Basis:=fnd_number.canonical_to_number(info_rec.ZVW_Basis) + l_ZVW_Basis;
2238: l_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Private_Use_Car) + l_Private_Use_Car;
2239: l_Net_Expense_Allowance:=fnd_number.canonical_to_number(info_rec.Net_Expense_Allowance) + l_Net_Expense_Allowance;
2240: l_Value_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Value_Private_Use_Car) + l_Value_Private_Use_Car;
2241: l_Saved_Amount_LSS:=fnd_number.canonical_to_number(info_rec.Saved_Amount_LSS) + l_Saved_Amount_LSS;

Line 2238: l_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Private_Use_Car) + l_Private_Use_Car;

2234: l_deducted_wage_tax:=fnd_number.canonical_to_number(info_rec.deducted_wage_tax) + l_deducted_wage_tax;
2235: l_labour_tax_reduction:=fnd_number.canonical_to_number(info_rec.labour_tax_reduction) + l_labour_tax_reduction;
2236: l_ZVW:=fnd_number.canonical_to_number(info_rec.ZVW_Cont) + l_ZVW;
2237: l_ZVW_Basis:=fnd_number.canonical_to_number(info_rec.ZVW_Basis) + l_ZVW_Basis;
2238: l_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Private_Use_Car) + l_Private_Use_Car;
2239: l_Net_Expense_Allowance:=fnd_number.canonical_to_number(info_rec.Net_Expense_Allowance) + l_Net_Expense_Allowance;
2240: l_Value_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Value_Private_Use_Car) + l_Value_Private_Use_Car;
2241: l_Saved_Amount_LSS:=fnd_number.canonical_to_number(info_rec.Saved_Amount_LSS) + l_Saved_Amount_LSS;
2242: l_Employer_Child_Care:=fnd_number.canonical_to_number(info_rec.Employer_Child_Care) + l_Employer_Child_Care;

Line 2239: l_Net_Expense_Allowance:=fnd_number.canonical_to_number(info_rec.Net_Expense_Allowance) + l_Net_Expense_Allowance;

2235: l_labour_tax_reduction:=fnd_number.canonical_to_number(info_rec.labour_tax_reduction) + l_labour_tax_reduction;
2236: l_ZVW:=fnd_number.canonical_to_number(info_rec.ZVW_Cont) + l_ZVW;
2237: l_ZVW_Basis:=fnd_number.canonical_to_number(info_rec.ZVW_Basis) + l_ZVW_Basis;
2238: l_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Private_Use_Car) + l_Private_Use_Car;
2239: l_Net_Expense_Allowance:=fnd_number.canonical_to_number(info_rec.Net_Expense_Allowance) + l_Net_Expense_Allowance;
2240: l_Value_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Value_Private_Use_Car) + l_Value_Private_Use_Car;
2241: l_Saved_Amount_LSS:=fnd_number.canonical_to_number(info_rec.Saved_Amount_LSS) + l_Saved_Amount_LSS;
2242: l_Employer_Child_Care:=fnd_number.canonical_to_number(info_rec.Employer_Child_Care) + l_Employer_Child_Care;
2243: l_Allowance_on_Disability:=fnd_number.canonical_to_number(info_rec.Allowance_on_Disability) + l_Allowance_on_Disability;

Line 2240: l_Value_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Value_Private_Use_Car) + l_Value_Private_Use_Car;

2236: l_ZVW:=fnd_number.canonical_to_number(info_rec.ZVW_Cont) + l_ZVW;
2237: l_ZVW_Basis:=fnd_number.canonical_to_number(info_rec.ZVW_Basis) + l_ZVW_Basis;
2238: l_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Private_Use_Car) + l_Private_Use_Car;
2239: l_Net_Expense_Allowance:=fnd_number.canonical_to_number(info_rec.Net_Expense_Allowance) + l_Net_Expense_Allowance;
2240: l_Value_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Value_Private_Use_Car) + l_Value_Private_Use_Car;
2241: l_Saved_Amount_LSS:=fnd_number.canonical_to_number(info_rec.Saved_Amount_LSS) + l_Saved_Amount_LSS;
2242: l_Employer_Child_Care:=fnd_number.canonical_to_number(info_rec.Employer_Child_Care) + l_Employer_Child_Care;
2243: l_Allowance_on_Disability:=fnd_number.canonical_to_number(info_rec.Allowance_on_Disability) + l_Allowance_on_Disability;
2244: l_Applied_LCLD:=fnd_number.canonical_to_number(info_rec.Applied_LCLD) + l_Applied_LCLD;

Line 2241: l_Saved_Amount_LSS:=fnd_number.canonical_to_number(info_rec.Saved_Amount_LSS) + l_Saved_Amount_LSS;

2237: l_ZVW_Basis:=fnd_number.canonical_to_number(info_rec.ZVW_Basis) + l_ZVW_Basis;
2238: l_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Private_Use_Car) + l_Private_Use_Car;
2239: l_Net_Expense_Allowance:=fnd_number.canonical_to_number(info_rec.Net_Expense_Allowance) + l_Net_Expense_Allowance;
2240: l_Value_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Value_Private_Use_Car) + l_Value_Private_Use_Car;
2241: l_Saved_Amount_LSS:=fnd_number.canonical_to_number(info_rec.Saved_Amount_LSS) + l_Saved_Amount_LSS;
2242: l_Employer_Child_Care:=fnd_number.canonical_to_number(info_rec.Employer_Child_Care) + l_Employer_Child_Care;
2243: l_Allowance_on_Disability:=fnd_number.canonical_to_number(info_rec.Allowance_on_Disability) + l_Allowance_on_Disability;
2244: l_Applied_LCLD:=fnd_number.canonical_to_number(info_rec.Applied_LCLD) + l_Applied_LCLD;
2245: populate_UserBalVal(info_rec.User_Bal_String,'Y');

Line 2242: l_Employer_Child_Care:=fnd_number.canonical_to_number(info_rec.Employer_Child_Care) + l_Employer_Child_Care;

2238: l_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Private_Use_Car) + l_Private_Use_Car;
2239: l_Net_Expense_Allowance:=fnd_number.canonical_to_number(info_rec.Net_Expense_Allowance) + l_Net_Expense_Allowance;
2240: l_Value_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Value_Private_Use_Car) + l_Value_Private_Use_Car;
2241: l_Saved_Amount_LSS:=fnd_number.canonical_to_number(info_rec.Saved_Amount_LSS) + l_Saved_Amount_LSS;
2242: l_Employer_Child_Care:=fnd_number.canonical_to_number(info_rec.Employer_Child_Care) + l_Employer_Child_Care;
2243: l_Allowance_on_Disability:=fnd_number.canonical_to_number(info_rec.Allowance_on_Disability) + l_Allowance_on_Disability;
2244: l_Applied_LCLD:=fnd_number.canonical_to_number(info_rec.Applied_LCLD) + l_Applied_LCLD;
2245: populate_UserBalVal(info_rec.User_Bal_String,'Y');
2246:

Line 2243: l_Allowance_on_Disability:=fnd_number.canonical_to_number(info_rec.Allowance_on_Disability) + l_Allowance_on_Disability;

2239: l_Net_Expense_Allowance:=fnd_number.canonical_to_number(info_rec.Net_Expense_Allowance) + l_Net_Expense_Allowance;
2240: l_Value_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Value_Private_Use_Car) + l_Value_Private_Use_Car;
2241: l_Saved_Amount_LSS:=fnd_number.canonical_to_number(info_rec.Saved_Amount_LSS) + l_Saved_Amount_LSS;
2242: l_Employer_Child_Care:=fnd_number.canonical_to_number(info_rec.Employer_Child_Care) + l_Employer_Child_Care;
2243: l_Allowance_on_Disability:=fnd_number.canonical_to_number(info_rec.Allowance_on_Disability) + l_Allowance_on_Disability;
2244: l_Applied_LCLD:=fnd_number.canonical_to_number(info_rec.Applied_LCLD) + l_Applied_LCLD;
2245: populate_UserBalVal(info_rec.User_Bal_String,'Y');
2246:
2247: end if;

Line 2244: l_Applied_LCLD:=fnd_number.canonical_to_number(info_rec.Applied_LCLD) + l_Applied_LCLD;

2240: l_Value_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Value_Private_Use_Car) + l_Value_Private_Use_Car;
2241: l_Saved_Amount_LSS:=fnd_number.canonical_to_number(info_rec.Saved_Amount_LSS) + l_Saved_Amount_LSS;
2242: l_Employer_Child_Care:=fnd_number.canonical_to_number(info_rec.Employer_Child_Care) + l_Employer_Child_Care;
2243: l_Allowance_on_Disability:=fnd_number.canonical_to_number(info_rec.Allowance_on_Disability) + l_Allowance_on_Disability;
2244: l_Applied_LCLD:=fnd_number.canonical_to_number(info_rec.Applied_LCLD) + l_Applied_LCLD;
2245: populate_UserBalVal(info_rec.User_Bal_String,'Y');
2246:
2247: end if;
2248:

Line 2346: l_taxable_income:=fnd_number.canonical_to_number(info_rec.taxable_income);

2342: vUserBalVal.DELETE;
2343:
2344: end if;
2345:
2346: l_taxable_income:=fnd_number.canonical_to_number(info_rec.taxable_income);
2347: l_deducted_wage_tax:=fnd_number.canonical_to_number(info_rec.deducted_wage_tax);
2348: l_labour_tax_reduction:=fnd_number.canonical_to_number(info_rec.labour_tax_reduction);
2349: l_ZVW:=fnd_number.canonical_to_number(info_rec.ZVW_Cont);
2350: l_ZVW_Basis:=fnd_number.canonical_to_number(info_rec.ZVW_Basis);

Line 2347: l_deducted_wage_tax:=fnd_number.canonical_to_number(info_rec.deducted_wage_tax);

2343:
2344: end if;
2345:
2346: l_taxable_income:=fnd_number.canonical_to_number(info_rec.taxable_income);
2347: l_deducted_wage_tax:=fnd_number.canonical_to_number(info_rec.deducted_wage_tax);
2348: l_labour_tax_reduction:=fnd_number.canonical_to_number(info_rec.labour_tax_reduction);
2349: l_ZVW:=fnd_number.canonical_to_number(info_rec.ZVW_Cont);
2350: l_ZVW_Basis:=fnd_number.canonical_to_number(info_rec.ZVW_Basis);
2351: l_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Private_Use_Car);

Line 2348: l_labour_tax_reduction:=fnd_number.canonical_to_number(info_rec.labour_tax_reduction);

2344: end if;
2345:
2346: l_taxable_income:=fnd_number.canonical_to_number(info_rec.taxable_income);
2347: l_deducted_wage_tax:=fnd_number.canonical_to_number(info_rec.deducted_wage_tax);
2348: l_labour_tax_reduction:=fnd_number.canonical_to_number(info_rec.labour_tax_reduction);
2349: l_ZVW:=fnd_number.canonical_to_number(info_rec.ZVW_Cont);
2350: l_ZVW_Basis:=fnd_number.canonical_to_number(info_rec.ZVW_Basis);
2351: l_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Private_Use_Car);
2352: l_Net_Expense_Allowance:=fnd_number.canonical_to_number(info_rec.Net_Expense_Allowance);

Line 2349: l_ZVW:=fnd_number.canonical_to_number(info_rec.ZVW_Cont);

2345:
2346: l_taxable_income:=fnd_number.canonical_to_number(info_rec.taxable_income);
2347: l_deducted_wage_tax:=fnd_number.canonical_to_number(info_rec.deducted_wage_tax);
2348: l_labour_tax_reduction:=fnd_number.canonical_to_number(info_rec.labour_tax_reduction);
2349: l_ZVW:=fnd_number.canonical_to_number(info_rec.ZVW_Cont);
2350: l_ZVW_Basis:=fnd_number.canonical_to_number(info_rec.ZVW_Basis);
2351: l_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Private_Use_Car);
2352: l_Net_Expense_Allowance:=fnd_number.canonical_to_number(info_rec.Net_Expense_Allowance);
2353: l_Value_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Value_Private_Use_Car);

Line 2350: l_ZVW_Basis:=fnd_number.canonical_to_number(info_rec.ZVW_Basis);

2346: l_taxable_income:=fnd_number.canonical_to_number(info_rec.taxable_income);
2347: l_deducted_wage_tax:=fnd_number.canonical_to_number(info_rec.deducted_wage_tax);
2348: l_labour_tax_reduction:=fnd_number.canonical_to_number(info_rec.labour_tax_reduction);
2349: l_ZVW:=fnd_number.canonical_to_number(info_rec.ZVW_Cont);
2350: l_ZVW_Basis:=fnd_number.canonical_to_number(info_rec.ZVW_Basis);
2351: l_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Private_Use_Car);
2352: l_Net_Expense_Allowance:=fnd_number.canonical_to_number(info_rec.Net_Expense_Allowance);
2353: l_Value_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Value_Private_Use_Car);
2354: l_Saved_Amount_LSS:=fnd_number.canonical_to_number(info_rec.Saved_Amount_LSS);

Line 2351: l_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Private_Use_Car);

2347: l_deducted_wage_tax:=fnd_number.canonical_to_number(info_rec.deducted_wage_tax);
2348: l_labour_tax_reduction:=fnd_number.canonical_to_number(info_rec.labour_tax_reduction);
2349: l_ZVW:=fnd_number.canonical_to_number(info_rec.ZVW_Cont);
2350: l_ZVW_Basis:=fnd_number.canonical_to_number(info_rec.ZVW_Basis);
2351: l_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Private_Use_Car);
2352: l_Net_Expense_Allowance:=fnd_number.canonical_to_number(info_rec.Net_Expense_Allowance);
2353: l_Value_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Value_Private_Use_Car);
2354: l_Saved_Amount_LSS:=fnd_number.canonical_to_number(info_rec.Saved_Amount_LSS);
2355: l_Employer_Child_Care:=fnd_number.canonical_to_number(info_rec.Employer_Child_Care);

Line 2352: l_Net_Expense_Allowance:=fnd_number.canonical_to_number(info_rec.Net_Expense_Allowance);

2348: l_labour_tax_reduction:=fnd_number.canonical_to_number(info_rec.labour_tax_reduction);
2349: l_ZVW:=fnd_number.canonical_to_number(info_rec.ZVW_Cont);
2350: l_ZVW_Basis:=fnd_number.canonical_to_number(info_rec.ZVW_Basis);
2351: l_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Private_Use_Car);
2352: l_Net_Expense_Allowance:=fnd_number.canonical_to_number(info_rec.Net_Expense_Allowance);
2353: l_Value_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Value_Private_Use_Car);
2354: l_Saved_Amount_LSS:=fnd_number.canonical_to_number(info_rec.Saved_Amount_LSS);
2355: l_Employer_Child_Care:=fnd_number.canonical_to_number(info_rec.Employer_Child_Care);
2356: l_Allowance_on_Disability:=fnd_number.canonical_to_number(info_rec.Allowance_on_Disability);

Line 2353: l_Value_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Value_Private_Use_Car);

2349: l_ZVW:=fnd_number.canonical_to_number(info_rec.ZVW_Cont);
2350: l_ZVW_Basis:=fnd_number.canonical_to_number(info_rec.ZVW_Basis);
2351: l_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Private_Use_Car);
2352: l_Net_Expense_Allowance:=fnd_number.canonical_to_number(info_rec.Net_Expense_Allowance);
2353: l_Value_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Value_Private_Use_Car);
2354: l_Saved_Amount_LSS:=fnd_number.canonical_to_number(info_rec.Saved_Amount_LSS);
2355: l_Employer_Child_Care:=fnd_number.canonical_to_number(info_rec.Employer_Child_Care);
2356: l_Allowance_on_Disability:=fnd_number.canonical_to_number(info_rec.Allowance_on_Disability);
2357: l_Applied_LCLD:=fnd_number.canonical_to_number(info_rec.Applied_LCLD);

Line 2354: l_Saved_Amount_LSS:=fnd_number.canonical_to_number(info_rec.Saved_Amount_LSS);

2350: l_ZVW_Basis:=fnd_number.canonical_to_number(info_rec.ZVW_Basis);
2351: l_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Private_Use_Car);
2352: l_Net_Expense_Allowance:=fnd_number.canonical_to_number(info_rec.Net_Expense_Allowance);
2353: l_Value_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Value_Private_Use_Car);
2354: l_Saved_Amount_LSS:=fnd_number.canonical_to_number(info_rec.Saved_Amount_LSS);
2355: l_Employer_Child_Care:=fnd_number.canonical_to_number(info_rec.Employer_Child_Care);
2356: l_Allowance_on_Disability:=fnd_number.canonical_to_number(info_rec.Allowance_on_Disability);
2357: l_Applied_LCLD:=fnd_number.canonical_to_number(info_rec.Applied_LCLD);
2358: populate_UserBalVal(info_rec.User_Bal_String,'N');

Line 2355: l_Employer_Child_Care:=fnd_number.canonical_to_number(info_rec.Employer_Child_Care);

2351: l_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Private_Use_Car);
2352: l_Net_Expense_Allowance:=fnd_number.canonical_to_number(info_rec.Net_Expense_Allowance);
2353: l_Value_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Value_Private_Use_Car);
2354: l_Saved_Amount_LSS:=fnd_number.canonical_to_number(info_rec.Saved_Amount_LSS);
2355: l_Employer_Child_Care:=fnd_number.canonical_to_number(info_rec.Employer_Child_Care);
2356: l_Allowance_on_Disability:=fnd_number.canonical_to_number(info_rec.Allowance_on_Disability);
2357: l_Applied_LCLD:=fnd_number.canonical_to_number(info_rec.Applied_LCLD);
2358: populate_UserBalVal(info_rec.User_Bal_String,'N');
2359:

Line 2356: l_Allowance_on_Disability:=fnd_number.canonical_to_number(info_rec.Allowance_on_Disability);

2352: l_Net_Expense_Allowance:=fnd_number.canonical_to_number(info_rec.Net_Expense_Allowance);
2353: l_Value_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Value_Private_Use_Car);
2354: l_Saved_Amount_LSS:=fnd_number.canonical_to_number(info_rec.Saved_Amount_LSS);
2355: l_Employer_Child_Care:=fnd_number.canonical_to_number(info_rec.Employer_Child_Care);
2356: l_Allowance_on_Disability:=fnd_number.canonical_to_number(info_rec.Allowance_on_Disability);
2357: l_Applied_LCLD:=fnd_number.canonical_to_number(info_rec.Applied_LCLD);
2358: populate_UserBalVal(info_rec.User_Bal_String,'N');
2359:
2360:

Line 2357: l_Applied_LCLD:=fnd_number.canonical_to_number(info_rec.Applied_LCLD);

2353: l_Value_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Value_Private_Use_Car);
2354: l_Saved_Amount_LSS:=fnd_number.canonical_to_number(info_rec.Saved_Amount_LSS);
2355: l_Employer_Child_Care:=fnd_number.canonical_to_number(info_rec.Employer_Child_Care);
2356: l_Allowance_on_Disability:=fnd_number.canonical_to_number(info_rec.Allowance_on_Disability);
2357: l_Applied_LCLD:=fnd_number.canonical_to_number(info_rec.Applied_LCLD);
2358: populate_UserBalVal(info_rec.User_Bal_String,'N');
2359:
2360:
2361:

Line 3331: vUserBalVal(lCtr).BalValue := fnd_number.canonical_to_number(substr(p_User_Bal_String,l_start,l_end-l_start));

3327: FOR lCtr IN PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.FIRST .. PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.LAST LOOP
3328:
3329: l_end := instr(p_User_Bal_String,'|',l_start,1);
3330:
3331: vUserBalVal(lCtr).BalValue := fnd_number.canonical_to_number(substr(p_User_Bal_String,l_start,l_end-l_start));
3332: vUserBalVal(lCtr).TagName := PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable(lCtr).TagName;
3333:
3334: hr_utility.set_location('tag-'||vUserBalVal(lCtr).TagName,13);
3335: hr_utility.set_location('bal-'||vUserBalVal(lCtr).BalValue,23);

Line 3347: vUserBalVal(lCtr).BalValue := vUserBalVal(lCtr).BalValue + fnd_number.canonical_to_number(substr(p_User_Bal_String,l_start,l_end-l_start));

3343: FOR lCtr IN PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.FIRST .. PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.LAST LOOP
3344:
3345: l_end := instr(p_User_Bal_String,'|',l_start,1);
3346:
3347: vUserBalVal(lCtr).BalValue := vUserBalVal(lCtr).BalValue + fnd_number.canonical_to_number(substr(p_User_Bal_String,l_start,l_end-l_start));
3348: vUserBalVal(lCtr).TagName := PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable(lCtr).TagName;
3349:
3350: l_start := l_end + 1;
3351: