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 82: 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)

78: and ppos.person_id = pap.person_id
79: and ppos.date_start <= lp_Tax_Year_End_Date
80: --and nvl(ppos.actual_termination_date, lp_Tax_Year_End_Date) >= lp_Tax_Year_Start_Date
81: and pai.action_information1 = to_char(p_employer_id)
82: 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)
83: and decode(pai.action_information_category,'NL ATS EMPLOYEE DETAILS',fnd_number.canonical_to_number(pai.action_information3),null) = paa.assignment_id
84: and pai.effective_date = lp_Tax_Year_End_Date
85: and paa.effective_start_date =
86: (

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

79: and ppos.date_start <= lp_Tax_Year_End_Date
80: --and nvl(ppos.actual_termination_date, lp_Tax_Year_End_Date) >= lp_Tax_Year_Start_Date
81: and pai.action_information1 = to_char(p_employer_id)
82: 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)
83: and decode(pai.action_information_category,'NL ATS EMPLOYEE DETAILS',fnd_number.canonical_to_number(pai.action_information3),null) = paa.assignment_id
84: and pai.effective_date = lp_Tax_Year_End_Date
85: and paa.effective_start_date =
86: (
87: SELECT MIN(asg.effective_start_date)

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

585: if p_agg_flag = 'Y' then
586:
587: if l_person_id = l_previous_person_id AND l_period_of_service = l_prev_period_of_service then
588:
589: l_taxable_income:=fnd_number.canonical_to_number(info_rec.taxable_income) + l_taxable_income;
590: l_deducted_wage_tax:=fnd_number.canonical_to_number(info_rec.deducted_wage_tax) + l_deducted_wage_tax;
591: l_labour_tax_reduction:=fnd_number.canonical_to_number(info_rec.labour_tax_reduction) + l_labour_tax_reduction;
592: l_ZVW:=fnd_number.canonical_to_number(info_rec.ZVW_Cont) + l_ZVW;
593: l_ZVW_Basis:=fnd_number.canonical_to_number(info_rec.ZVW_Basis) + l_ZVW_Basis;

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

586:
587: if l_person_id = l_previous_person_id AND l_period_of_service = l_prev_period_of_service then
588:
589: l_taxable_income:=fnd_number.canonical_to_number(info_rec.taxable_income) + l_taxable_income;
590: l_deducted_wage_tax:=fnd_number.canonical_to_number(info_rec.deducted_wage_tax) + l_deducted_wage_tax;
591: l_labour_tax_reduction:=fnd_number.canonical_to_number(info_rec.labour_tax_reduction) + l_labour_tax_reduction;
592: l_ZVW:=fnd_number.canonical_to_number(info_rec.ZVW_Cont) + l_ZVW;
593: l_ZVW_Basis:=fnd_number.canonical_to_number(info_rec.ZVW_Basis) + l_ZVW_Basis;
594: l_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Private_Use_Car) + l_Private_Use_Car;

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

587: if l_person_id = l_previous_person_id AND l_period_of_service = l_prev_period_of_service then
588:
589: l_taxable_income:=fnd_number.canonical_to_number(info_rec.taxable_income) + l_taxable_income;
590: l_deducted_wage_tax:=fnd_number.canonical_to_number(info_rec.deducted_wage_tax) + l_deducted_wage_tax;
591: l_labour_tax_reduction:=fnd_number.canonical_to_number(info_rec.labour_tax_reduction) + l_labour_tax_reduction;
592: l_ZVW:=fnd_number.canonical_to_number(info_rec.ZVW_Cont) + l_ZVW;
593: l_ZVW_Basis:=fnd_number.canonical_to_number(info_rec.ZVW_Basis) + l_ZVW_Basis;
594: l_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Private_Use_Car) + l_Private_Use_Car;
595: l_Net_Expense_Allowance:=fnd_number.canonical_to_number(info_rec.Net_Expense_Allowance) + l_Net_Expense_Allowance;

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

588:
589: l_taxable_income:=fnd_number.canonical_to_number(info_rec.taxable_income) + l_taxable_income;
590: l_deducted_wage_tax:=fnd_number.canonical_to_number(info_rec.deducted_wage_tax) + l_deducted_wage_tax;
591: l_labour_tax_reduction:=fnd_number.canonical_to_number(info_rec.labour_tax_reduction) + l_labour_tax_reduction;
592: l_ZVW:=fnd_number.canonical_to_number(info_rec.ZVW_Cont) + l_ZVW;
593: l_ZVW_Basis:=fnd_number.canonical_to_number(info_rec.ZVW_Basis) + l_ZVW_Basis;
594: l_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Private_Use_Car) + l_Private_Use_Car;
595: l_Net_Expense_Allowance:=fnd_number.canonical_to_number(info_rec.Net_Expense_Allowance) + l_Net_Expense_Allowance;
596: l_Value_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Value_Private_Use_Car) + l_Value_Private_Use_Car;

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

589: l_taxable_income:=fnd_number.canonical_to_number(info_rec.taxable_income) + l_taxable_income;
590: l_deducted_wage_tax:=fnd_number.canonical_to_number(info_rec.deducted_wage_tax) + l_deducted_wage_tax;
591: l_labour_tax_reduction:=fnd_number.canonical_to_number(info_rec.labour_tax_reduction) + l_labour_tax_reduction;
592: l_ZVW:=fnd_number.canonical_to_number(info_rec.ZVW_Cont) + l_ZVW;
593: l_ZVW_Basis:=fnd_number.canonical_to_number(info_rec.ZVW_Basis) + l_ZVW_Basis;
594: l_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Private_Use_Car) + l_Private_Use_Car;
595: l_Net_Expense_Allowance:=fnd_number.canonical_to_number(info_rec.Net_Expense_Allowance) + l_Net_Expense_Allowance;
596: l_Value_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Value_Private_Use_Car) + l_Value_Private_Use_Car;
597: l_Saved_Amount_LSS:=fnd_number.canonical_to_number(info_rec.Saved_Amount_LSS) + l_Saved_Amount_LSS;

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

590: l_deducted_wage_tax:=fnd_number.canonical_to_number(info_rec.deducted_wage_tax) + l_deducted_wage_tax;
591: l_labour_tax_reduction:=fnd_number.canonical_to_number(info_rec.labour_tax_reduction) + l_labour_tax_reduction;
592: l_ZVW:=fnd_number.canonical_to_number(info_rec.ZVW_Cont) + l_ZVW;
593: l_ZVW_Basis:=fnd_number.canonical_to_number(info_rec.ZVW_Basis) + l_ZVW_Basis;
594: l_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Private_Use_Car) + l_Private_Use_Car;
595: l_Net_Expense_Allowance:=fnd_number.canonical_to_number(info_rec.Net_Expense_Allowance) + l_Net_Expense_Allowance;
596: l_Value_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Value_Private_Use_Car) + l_Value_Private_Use_Car;
597: l_Saved_Amount_LSS:=fnd_number.canonical_to_number(info_rec.Saved_Amount_LSS) + l_Saved_Amount_LSS;
598: l_Employer_Child_Care:=fnd_number.canonical_to_number(info_rec.Employer_Child_Care) + l_Employer_Child_Care;

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

591: l_labour_tax_reduction:=fnd_number.canonical_to_number(info_rec.labour_tax_reduction) + l_labour_tax_reduction;
592: l_ZVW:=fnd_number.canonical_to_number(info_rec.ZVW_Cont) + l_ZVW;
593: l_ZVW_Basis:=fnd_number.canonical_to_number(info_rec.ZVW_Basis) + l_ZVW_Basis;
594: l_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Private_Use_Car) + l_Private_Use_Car;
595: l_Net_Expense_Allowance:=fnd_number.canonical_to_number(info_rec.Net_Expense_Allowance) + l_Net_Expense_Allowance;
596: l_Value_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Value_Private_Use_Car) + l_Value_Private_Use_Car;
597: l_Saved_Amount_LSS:=fnd_number.canonical_to_number(info_rec.Saved_Amount_LSS) + l_Saved_Amount_LSS;
598: l_Employer_Child_Care:=fnd_number.canonical_to_number(info_rec.Employer_Child_Care) + l_Employer_Child_Care;
599: l_Allowance_on_Disability:=fnd_number.canonical_to_number(info_rec.Allowance_on_Disability) + l_Allowance_on_Disability;

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

592: l_ZVW:=fnd_number.canonical_to_number(info_rec.ZVW_Cont) + l_ZVW;
593: l_ZVW_Basis:=fnd_number.canonical_to_number(info_rec.ZVW_Basis) + l_ZVW_Basis;
594: l_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Private_Use_Car) + l_Private_Use_Car;
595: l_Net_Expense_Allowance:=fnd_number.canonical_to_number(info_rec.Net_Expense_Allowance) + l_Net_Expense_Allowance;
596: l_Value_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Value_Private_Use_Car) + l_Value_Private_Use_Car;
597: l_Saved_Amount_LSS:=fnd_number.canonical_to_number(info_rec.Saved_Amount_LSS) + l_Saved_Amount_LSS;
598: l_Employer_Child_Care:=fnd_number.canonical_to_number(info_rec.Employer_Child_Care) + l_Employer_Child_Care;
599: l_Allowance_on_Disability:=fnd_number.canonical_to_number(info_rec.Allowance_on_Disability) + l_Allowance_on_Disability;
600: l_Applied_LCLD:=fnd_number.canonical_to_number(info_rec.Applied_LCLD) + l_Applied_LCLD;

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

593: l_ZVW_Basis:=fnd_number.canonical_to_number(info_rec.ZVW_Basis) + l_ZVW_Basis;
594: l_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Private_Use_Car) + l_Private_Use_Car;
595: l_Net_Expense_Allowance:=fnd_number.canonical_to_number(info_rec.Net_Expense_Allowance) + l_Net_Expense_Allowance;
596: l_Value_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Value_Private_Use_Car) + l_Value_Private_Use_Car;
597: l_Saved_Amount_LSS:=fnd_number.canonical_to_number(info_rec.Saved_Amount_LSS) + l_Saved_Amount_LSS;
598: l_Employer_Child_Care:=fnd_number.canonical_to_number(info_rec.Employer_Child_Care) + l_Employer_Child_Care;
599: l_Allowance_on_Disability:=fnd_number.canonical_to_number(info_rec.Allowance_on_Disability) + l_Allowance_on_Disability;
600: l_Applied_LCLD:=fnd_number.canonical_to_number(info_rec.Applied_LCLD) + l_Applied_LCLD;
601: populate_UserBalVal(info_rec.User_Bal_String,'Y');

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

594: l_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Private_Use_Car) + l_Private_Use_Car;
595: l_Net_Expense_Allowance:=fnd_number.canonical_to_number(info_rec.Net_Expense_Allowance) + l_Net_Expense_Allowance;
596: l_Value_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Value_Private_Use_Car) + l_Value_Private_Use_Car;
597: l_Saved_Amount_LSS:=fnd_number.canonical_to_number(info_rec.Saved_Amount_LSS) + l_Saved_Amount_LSS;
598: l_Employer_Child_Care:=fnd_number.canonical_to_number(info_rec.Employer_Child_Care) + l_Employer_Child_Care;
599: l_Allowance_on_Disability:=fnd_number.canonical_to_number(info_rec.Allowance_on_Disability) + l_Allowance_on_Disability;
600: l_Applied_LCLD:=fnd_number.canonical_to_number(info_rec.Applied_LCLD) + l_Applied_LCLD;
601: populate_UserBalVal(info_rec.User_Bal_String,'Y');
602:

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

595: l_Net_Expense_Allowance:=fnd_number.canonical_to_number(info_rec.Net_Expense_Allowance) + l_Net_Expense_Allowance;
596: l_Value_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Value_Private_Use_Car) + l_Value_Private_Use_Car;
597: l_Saved_Amount_LSS:=fnd_number.canonical_to_number(info_rec.Saved_Amount_LSS) + l_Saved_Amount_LSS;
598: l_Employer_Child_Care:=fnd_number.canonical_to_number(info_rec.Employer_Child_Care) + l_Employer_Child_Care;
599: l_Allowance_on_Disability:=fnd_number.canonical_to_number(info_rec.Allowance_on_Disability) + l_Allowance_on_Disability;
600: l_Applied_LCLD:=fnd_number.canonical_to_number(info_rec.Applied_LCLD) + l_Applied_LCLD;
601: populate_UserBalVal(info_rec.User_Bal_String,'Y');
602:
603: end if;

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

596: l_Value_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Value_Private_Use_Car) + l_Value_Private_Use_Car;
597: l_Saved_Amount_LSS:=fnd_number.canonical_to_number(info_rec.Saved_Amount_LSS) + l_Saved_Amount_LSS;
598: l_Employer_Child_Care:=fnd_number.canonical_to_number(info_rec.Employer_Child_Care) + l_Employer_Child_Care;
599: l_Allowance_on_Disability:=fnd_number.canonical_to_number(info_rec.Allowance_on_Disability) + l_Allowance_on_Disability;
600: l_Applied_LCLD:=fnd_number.canonical_to_number(info_rec.Applied_LCLD) + l_Applied_LCLD;
601: populate_UserBalVal(info_rec.User_Bal_String,'Y');
602:
603: end if;
604:

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

693: vUserBalVal.DELETE;
694:
695: end if;
696:
697: l_taxable_income:=fnd_number.canonical_to_number(info_rec.taxable_income);
698: l_deducted_wage_tax:=fnd_number.canonical_to_number(info_rec.deducted_wage_tax);
699: l_labour_tax_reduction:=fnd_number.canonical_to_number(info_rec.labour_tax_reduction);
700: l_ZVW:=fnd_number.canonical_to_number(info_rec.ZVW_Cont);
701: l_ZVW_Basis:=fnd_number.canonical_to_number(info_rec.ZVW_Basis);

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

694:
695: end if;
696:
697: l_taxable_income:=fnd_number.canonical_to_number(info_rec.taxable_income);
698: l_deducted_wage_tax:=fnd_number.canonical_to_number(info_rec.deducted_wage_tax);
699: l_labour_tax_reduction:=fnd_number.canonical_to_number(info_rec.labour_tax_reduction);
700: l_ZVW:=fnd_number.canonical_to_number(info_rec.ZVW_Cont);
701: l_ZVW_Basis:=fnd_number.canonical_to_number(info_rec.ZVW_Basis);
702: l_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Private_Use_Car);

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

695: end if;
696:
697: l_taxable_income:=fnd_number.canonical_to_number(info_rec.taxable_income);
698: l_deducted_wage_tax:=fnd_number.canonical_to_number(info_rec.deducted_wage_tax);
699: l_labour_tax_reduction:=fnd_number.canonical_to_number(info_rec.labour_tax_reduction);
700: l_ZVW:=fnd_number.canonical_to_number(info_rec.ZVW_Cont);
701: l_ZVW_Basis:=fnd_number.canonical_to_number(info_rec.ZVW_Basis);
702: l_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Private_Use_Car);
703: l_Net_Expense_Allowance:=fnd_number.canonical_to_number(info_rec.Net_Expense_Allowance);

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

696:
697: l_taxable_income:=fnd_number.canonical_to_number(info_rec.taxable_income);
698: l_deducted_wage_tax:=fnd_number.canonical_to_number(info_rec.deducted_wage_tax);
699: l_labour_tax_reduction:=fnd_number.canonical_to_number(info_rec.labour_tax_reduction);
700: l_ZVW:=fnd_number.canonical_to_number(info_rec.ZVW_Cont);
701: l_ZVW_Basis:=fnd_number.canonical_to_number(info_rec.ZVW_Basis);
702: l_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Private_Use_Car);
703: l_Net_Expense_Allowance:=fnd_number.canonical_to_number(info_rec.Net_Expense_Allowance);
704: l_Value_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Value_Private_Use_Car);

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

697: l_taxable_income:=fnd_number.canonical_to_number(info_rec.taxable_income);
698: l_deducted_wage_tax:=fnd_number.canonical_to_number(info_rec.deducted_wage_tax);
699: l_labour_tax_reduction:=fnd_number.canonical_to_number(info_rec.labour_tax_reduction);
700: l_ZVW:=fnd_number.canonical_to_number(info_rec.ZVW_Cont);
701: l_ZVW_Basis:=fnd_number.canonical_to_number(info_rec.ZVW_Basis);
702: l_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Private_Use_Car);
703: l_Net_Expense_Allowance:=fnd_number.canonical_to_number(info_rec.Net_Expense_Allowance);
704: l_Value_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Value_Private_Use_Car);
705: l_Saved_Amount_LSS:=fnd_number.canonical_to_number(info_rec.Saved_Amount_LSS);

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

698: l_deducted_wage_tax:=fnd_number.canonical_to_number(info_rec.deducted_wage_tax);
699: l_labour_tax_reduction:=fnd_number.canonical_to_number(info_rec.labour_tax_reduction);
700: l_ZVW:=fnd_number.canonical_to_number(info_rec.ZVW_Cont);
701: l_ZVW_Basis:=fnd_number.canonical_to_number(info_rec.ZVW_Basis);
702: l_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Private_Use_Car);
703: l_Net_Expense_Allowance:=fnd_number.canonical_to_number(info_rec.Net_Expense_Allowance);
704: l_Value_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Value_Private_Use_Car);
705: l_Saved_Amount_LSS:=fnd_number.canonical_to_number(info_rec.Saved_Amount_LSS);
706: l_Employer_Child_Care:=fnd_number.canonical_to_number(info_rec.Employer_Child_Care);

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

699: l_labour_tax_reduction:=fnd_number.canonical_to_number(info_rec.labour_tax_reduction);
700: l_ZVW:=fnd_number.canonical_to_number(info_rec.ZVW_Cont);
701: l_ZVW_Basis:=fnd_number.canonical_to_number(info_rec.ZVW_Basis);
702: l_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Private_Use_Car);
703: l_Net_Expense_Allowance:=fnd_number.canonical_to_number(info_rec.Net_Expense_Allowance);
704: l_Value_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Value_Private_Use_Car);
705: l_Saved_Amount_LSS:=fnd_number.canonical_to_number(info_rec.Saved_Amount_LSS);
706: l_Employer_Child_Care:=fnd_number.canonical_to_number(info_rec.Employer_Child_Care);
707: l_Allowance_on_Disability:=fnd_number.canonical_to_number(info_rec.Allowance_on_Disability);

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

700: l_ZVW:=fnd_number.canonical_to_number(info_rec.ZVW_Cont);
701: l_ZVW_Basis:=fnd_number.canonical_to_number(info_rec.ZVW_Basis);
702: l_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Private_Use_Car);
703: l_Net_Expense_Allowance:=fnd_number.canonical_to_number(info_rec.Net_Expense_Allowance);
704: l_Value_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Value_Private_Use_Car);
705: l_Saved_Amount_LSS:=fnd_number.canonical_to_number(info_rec.Saved_Amount_LSS);
706: l_Employer_Child_Care:=fnd_number.canonical_to_number(info_rec.Employer_Child_Care);
707: l_Allowance_on_Disability:=fnd_number.canonical_to_number(info_rec.Allowance_on_Disability);
708: l_Applied_LCLD:=fnd_number.canonical_to_number(info_rec.Applied_LCLD);

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

701: l_ZVW_Basis:=fnd_number.canonical_to_number(info_rec.ZVW_Basis);
702: l_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Private_Use_Car);
703: l_Net_Expense_Allowance:=fnd_number.canonical_to_number(info_rec.Net_Expense_Allowance);
704: l_Value_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Value_Private_Use_Car);
705: l_Saved_Amount_LSS:=fnd_number.canonical_to_number(info_rec.Saved_Amount_LSS);
706: l_Employer_Child_Care:=fnd_number.canonical_to_number(info_rec.Employer_Child_Care);
707: l_Allowance_on_Disability:=fnd_number.canonical_to_number(info_rec.Allowance_on_Disability);
708: l_Applied_LCLD:=fnd_number.canonical_to_number(info_rec.Applied_LCLD);
709: populate_UserBalVal(info_rec.User_Bal_String,'N');

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

702: l_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Private_Use_Car);
703: l_Net_Expense_Allowance:=fnd_number.canonical_to_number(info_rec.Net_Expense_Allowance);
704: l_Value_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Value_Private_Use_Car);
705: l_Saved_Amount_LSS:=fnd_number.canonical_to_number(info_rec.Saved_Amount_LSS);
706: l_Employer_Child_Care:=fnd_number.canonical_to_number(info_rec.Employer_Child_Care);
707: l_Allowance_on_Disability:=fnd_number.canonical_to_number(info_rec.Allowance_on_Disability);
708: l_Applied_LCLD:=fnd_number.canonical_to_number(info_rec.Applied_LCLD);
709: populate_UserBalVal(info_rec.User_Bal_String,'N');
710:

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

703: l_Net_Expense_Allowance:=fnd_number.canonical_to_number(info_rec.Net_Expense_Allowance);
704: l_Value_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Value_Private_Use_Car);
705: l_Saved_Amount_LSS:=fnd_number.canonical_to_number(info_rec.Saved_Amount_LSS);
706: l_Employer_Child_Care:=fnd_number.canonical_to_number(info_rec.Employer_Child_Care);
707: l_Allowance_on_Disability:=fnd_number.canonical_to_number(info_rec.Allowance_on_Disability);
708: l_Applied_LCLD:=fnd_number.canonical_to_number(info_rec.Applied_LCLD);
709: populate_UserBalVal(info_rec.User_Bal_String,'N');
710:
711:

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

704: l_Value_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Value_Private_Use_Car);
705: l_Saved_Amount_LSS:=fnd_number.canonical_to_number(info_rec.Saved_Amount_LSS);
706: l_Employer_Child_Care:=fnd_number.canonical_to_number(info_rec.Employer_Child_Care);
707: l_Allowance_on_Disability:=fnd_number.canonical_to_number(info_rec.Allowance_on_Disability);
708: l_Applied_LCLD:=fnd_number.canonical_to_number(info_rec.Applied_LCLD);
709: populate_UserBalVal(info_rec.User_Bal_String,'N');
710:
711:
712:

Line 1679: 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)

1675: and ppos.person_id = pap.person_id
1676: and ppos.date_start <= lp_Tax_Year_End_Date
1677: --and nvl(ppos.actual_termination_date, lp_Tax_Year_End_Date) >= lp_Tax_Year_Start_Date
1678: and pai.action_information1 = to_char(p_employer_id)
1679: 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)
1680: and decode(pai.action_information_category,'NL ATS EMPLOYEE DETAILS',fnd_number.canonical_to_number(pai.action_information3),null) = paa.assignment_id
1681: and pai.effective_date = lp_Tax_Year_End_Date
1682: and paa.effective_start_date =
1683: (

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

1676: and ppos.date_start <= lp_Tax_Year_End_Date
1677: --and nvl(ppos.actual_termination_date, lp_Tax_Year_End_Date) >= lp_Tax_Year_Start_Date
1678: and pai.action_information1 = to_char(p_employer_id)
1679: 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)
1680: and decode(pai.action_information_category,'NL ATS EMPLOYEE DETAILS',fnd_number.canonical_to_number(pai.action_information3),null) = paa.assignment_id
1681: and pai.effective_date = lp_Tax_Year_End_Date
1682: and paa.effective_start_date =
1683: (
1684: SELECT MIN(asg.effective_start_date)

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

2182: if p_agg_flag = 'Y' then
2183:
2184: if l_person_id = l_previous_person_id AND l_period_of_service = l_prev_period_of_service then
2185:
2186: l_taxable_income:=fnd_number.canonical_to_number(info_rec.taxable_income) + l_taxable_income;
2187: l_deducted_wage_tax:=fnd_number.canonical_to_number(info_rec.deducted_wage_tax) + l_deducted_wage_tax;
2188: l_labour_tax_reduction:=fnd_number.canonical_to_number(info_rec.labour_tax_reduction) + l_labour_tax_reduction;
2189: l_ZVW:=fnd_number.canonical_to_number(info_rec.ZVW_Cont) + l_ZVW;
2190: l_ZVW_Basis:=fnd_number.canonical_to_number(info_rec.ZVW_Basis) + l_ZVW_Basis;

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

2183:
2184: if l_person_id = l_previous_person_id AND l_period_of_service = l_prev_period_of_service then
2185:
2186: l_taxable_income:=fnd_number.canonical_to_number(info_rec.taxable_income) + l_taxable_income;
2187: l_deducted_wage_tax:=fnd_number.canonical_to_number(info_rec.deducted_wage_tax) + l_deducted_wage_tax;
2188: l_labour_tax_reduction:=fnd_number.canonical_to_number(info_rec.labour_tax_reduction) + l_labour_tax_reduction;
2189: l_ZVW:=fnd_number.canonical_to_number(info_rec.ZVW_Cont) + l_ZVW;
2190: l_ZVW_Basis:=fnd_number.canonical_to_number(info_rec.ZVW_Basis) + l_ZVW_Basis;
2191: l_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Private_Use_Car) + l_Private_Use_Car;

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

2184: if l_person_id = l_previous_person_id AND l_period_of_service = l_prev_period_of_service then
2185:
2186: l_taxable_income:=fnd_number.canonical_to_number(info_rec.taxable_income) + l_taxable_income;
2187: l_deducted_wage_tax:=fnd_number.canonical_to_number(info_rec.deducted_wage_tax) + l_deducted_wage_tax;
2188: l_labour_tax_reduction:=fnd_number.canonical_to_number(info_rec.labour_tax_reduction) + l_labour_tax_reduction;
2189: l_ZVW:=fnd_number.canonical_to_number(info_rec.ZVW_Cont) + l_ZVW;
2190: l_ZVW_Basis:=fnd_number.canonical_to_number(info_rec.ZVW_Basis) + l_ZVW_Basis;
2191: l_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Private_Use_Car) + l_Private_Use_Car;
2192: l_Net_Expense_Allowance:=fnd_number.canonical_to_number(info_rec.Net_Expense_Allowance) + l_Net_Expense_Allowance;

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

2185:
2186: l_taxable_income:=fnd_number.canonical_to_number(info_rec.taxable_income) + l_taxable_income;
2187: l_deducted_wage_tax:=fnd_number.canonical_to_number(info_rec.deducted_wage_tax) + l_deducted_wage_tax;
2188: l_labour_tax_reduction:=fnd_number.canonical_to_number(info_rec.labour_tax_reduction) + l_labour_tax_reduction;
2189: l_ZVW:=fnd_number.canonical_to_number(info_rec.ZVW_Cont) + l_ZVW;
2190: l_ZVW_Basis:=fnd_number.canonical_to_number(info_rec.ZVW_Basis) + l_ZVW_Basis;
2191: l_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Private_Use_Car) + l_Private_Use_Car;
2192: l_Net_Expense_Allowance:=fnd_number.canonical_to_number(info_rec.Net_Expense_Allowance) + l_Net_Expense_Allowance;
2193: l_Value_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Value_Private_Use_Car) + l_Value_Private_Use_Car;

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

2186: l_taxable_income:=fnd_number.canonical_to_number(info_rec.taxable_income) + l_taxable_income;
2187: l_deducted_wage_tax:=fnd_number.canonical_to_number(info_rec.deducted_wage_tax) + l_deducted_wage_tax;
2188: l_labour_tax_reduction:=fnd_number.canonical_to_number(info_rec.labour_tax_reduction) + l_labour_tax_reduction;
2189: l_ZVW:=fnd_number.canonical_to_number(info_rec.ZVW_Cont) + l_ZVW;
2190: l_ZVW_Basis:=fnd_number.canonical_to_number(info_rec.ZVW_Basis) + l_ZVW_Basis;
2191: l_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Private_Use_Car) + l_Private_Use_Car;
2192: l_Net_Expense_Allowance:=fnd_number.canonical_to_number(info_rec.Net_Expense_Allowance) + l_Net_Expense_Allowance;
2193: l_Value_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Value_Private_Use_Car) + l_Value_Private_Use_Car;
2194: l_Saved_Amount_LSS:=fnd_number.canonical_to_number(info_rec.Saved_Amount_LSS) + l_Saved_Amount_LSS;

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

2187: l_deducted_wage_tax:=fnd_number.canonical_to_number(info_rec.deducted_wage_tax) + l_deducted_wage_tax;
2188: l_labour_tax_reduction:=fnd_number.canonical_to_number(info_rec.labour_tax_reduction) + l_labour_tax_reduction;
2189: l_ZVW:=fnd_number.canonical_to_number(info_rec.ZVW_Cont) + l_ZVW;
2190: l_ZVW_Basis:=fnd_number.canonical_to_number(info_rec.ZVW_Basis) + l_ZVW_Basis;
2191: l_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Private_Use_Car) + l_Private_Use_Car;
2192: l_Net_Expense_Allowance:=fnd_number.canonical_to_number(info_rec.Net_Expense_Allowance) + l_Net_Expense_Allowance;
2193: l_Value_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Value_Private_Use_Car) + l_Value_Private_Use_Car;
2194: l_Saved_Amount_LSS:=fnd_number.canonical_to_number(info_rec.Saved_Amount_LSS) + l_Saved_Amount_LSS;
2195: l_Employer_Child_Care:=fnd_number.canonical_to_number(info_rec.Employer_Child_Care) + l_Employer_Child_Care;

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

2188: l_labour_tax_reduction:=fnd_number.canonical_to_number(info_rec.labour_tax_reduction) + l_labour_tax_reduction;
2189: l_ZVW:=fnd_number.canonical_to_number(info_rec.ZVW_Cont) + l_ZVW;
2190: l_ZVW_Basis:=fnd_number.canonical_to_number(info_rec.ZVW_Basis) + l_ZVW_Basis;
2191: l_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Private_Use_Car) + l_Private_Use_Car;
2192: l_Net_Expense_Allowance:=fnd_number.canonical_to_number(info_rec.Net_Expense_Allowance) + l_Net_Expense_Allowance;
2193: l_Value_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Value_Private_Use_Car) + l_Value_Private_Use_Car;
2194: l_Saved_Amount_LSS:=fnd_number.canonical_to_number(info_rec.Saved_Amount_LSS) + l_Saved_Amount_LSS;
2195: l_Employer_Child_Care:=fnd_number.canonical_to_number(info_rec.Employer_Child_Care) + l_Employer_Child_Care;
2196: l_Allowance_on_Disability:=fnd_number.canonical_to_number(info_rec.Allowance_on_Disability) + l_Allowance_on_Disability;

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

2189: l_ZVW:=fnd_number.canonical_to_number(info_rec.ZVW_Cont) + l_ZVW;
2190: l_ZVW_Basis:=fnd_number.canonical_to_number(info_rec.ZVW_Basis) + l_ZVW_Basis;
2191: l_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Private_Use_Car) + l_Private_Use_Car;
2192: l_Net_Expense_Allowance:=fnd_number.canonical_to_number(info_rec.Net_Expense_Allowance) + l_Net_Expense_Allowance;
2193: l_Value_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Value_Private_Use_Car) + l_Value_Private_Use_Car;
2194: l_Saved_Amount_LSS:=fnd_number.canonical_to_number(info_rec.Saved_Amount_LSS) + l_Saved_Amount_LSS;
2195: l_Employer_Child_Care:=fnd_number.canonical_to_number(info_rec.Employer_Child_Care) + l_Employer_Child_Care;
2196: l_Allowance_on_Disability:=fnd_number.canonical_to_number(info_rec.Allowance_on_Disability) + l_Allowance_on_Disability;
2197: l_Applied_LCLD:=fnd_number.canonical_to_number(info_rec.Applied_LCLD) + l_Applied_LCLD;

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

2190: l_ZVW_Basis:=fnd_number.canonical_to_number(info_rec.ZVW_Basis) + l_ZVW_Basis;
2191: l_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Private_Use_Car) + l_Private_Use_Car;
2192: l_Net_Expense_Allowance:=fnd_number.canonical_to_number(info_rec.Net_Expense_Allowance) + l_Net_Expense_Allowance;
2193: l_Value_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Value_Private_Use_Car) + l_Value_Private_Use_Car;
2194: l_Saved_Amount_LSS:=fnd_number.canonical_to_number(info_rec.Saved_Amount_LSS) + l_Saved_Amount_LSS;
2195: l_Employer_Child_Care:=fnd_number.canonical_to_number(info_rec.Employer_Child_Care) + l_Employer_Child_Care;
2196: l_Allowance_on_Disability:=fnd_number.canonical_to_number(info_rec.Allowance_on_Disability) + l_Allowance_on_Disability;
2197: l_Applied_LCLD:=fnd_number.canonical_to_number(info_rec.Applied_LCLD) + l_Applied_LCLD;
2198: populate_UserBalVal(info_rec.User_Bal_String,'Y');

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

2191: l_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Private_Use_Car) + l_Private_Use_Car;
2192: l_Net_Expense_Allowance:=fnd_number.canonical_to_number(info_rec.Net_Expense_Allowance) + l_Net_Expense_Allowance;
2193: l_Value_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Value_Private_Use_Car) + l_Value_Private_Use_Car;
2194: l_Saved_Amount_LSS:=fnd_number.canonical_to_number(info_rec.Saved_Amount_LSS) + l_Saved_Amount_LSS;
2195: l_Employer_Child_Care:=fnd_number.canonical_to_number(info_rec.Employer_Child_Care) + l_Employer_Child_Care;
2196: l_Allowance_on_Disability:=fnd_number.canonical_to_number(info_rec.Allowance_on_Disability) + l_Allowance_on_Disability;
2197: l_Applied_LCLD:=fnd_number.canonical_to_number(info_rec.Applied_LCLD) + l_Applied_LCLD;
2198: populate_UserBalVal(info_rec.User_Bal_String,'Y');
2199:

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

2192: l_Net_Expense_Allowance:=fnd_number.canonical_to_number(info_rec.Net_Expense_Allowance) + l_Net_Expense_Allowance;
2193: l_Value_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Value_Private_Use_Car) + l_Value_Private_Use_Car;
2194: l_Saved_Amount_LSS:=fnd_number.canonical_to_number(info_rec.Saved_Amount_LSS) + l_Saved_Amount_LSS;
2195: l_Employer_Child_Care:=fnd_number.canonical_to_number(info_rec.Employer_Child_Care) + l_Employer_Child_Care;
2196: l_Allowance_on_Disability:=fnd_number.canonical_to_number(info_rec.Allowance_on_Disability) + l_Allowance_on_Disability;
2197: l_Applied_LCLD:=fnd_number.canonical_to_number(info_rec.Applied_LCLD) + l_Applied_LCLD;
2198: populate_UserBalVal(info_rec.User_Bal_String,'Y');
2199:
2200: end if;

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

2193: l_Value_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Value_Private_Use_Car) + l_Value_Private_Use_Car;
2194: l_Saved_Amount_LSS:=fnd_number.canonical_to_number(info_rec.Saved_Amount_LSS) + l_Saved_Amount_LSS;
2195: l_Employer_Child_Care:=fnd_number.canonical_to_number(info_rec.Employer_Child_Care) + l_Employer_Child_Care;
2196: l_Allowance_on_Disability:=fnd_number.canonical_to_number(info_rec.Allowance_on_Disability) + l_Allowance_on_Disability;
2197: l_Applied_LCLD:=fnd_number.canonical_to_number(info_rec.Applied_LCLD) + l_Applied_LCLD;
2198: populate_UserBalVal(info_rec.User_Bal_String,'Y');
2199:
2200: end if;
2201:

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

2290: vUserBalVal.DELETE;
2291:
2292: end if;
2293:
2294: l_taxable_income:=fnd_number.canonical_to_number(info_rec.taxable_income);
2295: l_deducted_wage_tax:=fnd_number.canonical_to_number(info_rec.deducted_wage_tax);
2296: l_labour_tax_reduction:=fnd_number.canonical_to_number(info_rec.labour_tax_reduction);
2297: l_ZVW:=fnd_number.canonical_to_number(info_rec.ZVW_Cont);
2298: l_ZVW_Basis:=fnd_number.canonical_to_number(info_rec.ZVW_Basis);

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

2291:
2292: end if;
2293:
2294: l_taxable_income:=fnd_number.canonical_to_number(info_rec.taxable_income);
2295: l_deducted_wage_tax:=fnd_number.canonical_to_number(info_rec.deducted_wage_tax);
2296: l_labour_tax_reduction:=fnd_number.canonical_to_number(info_rec.labour_tax_reduction);
2297: l_ZVW:=fnd_number.canonical_to_number(info_rec.ZVW_Cont);
2298: l_ZVW_Basis:=fnd_number.canonical_to_number(info_rec.ZVW_Basis);
2299: l_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Private_Use_Car);

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

2292: end if;
2293:
2294: l_taxable_income:=fnd_number.canonical_to_number(info_rec.taxable_income);
2295: l_deducted_wage_tax:=fnd_number.canonical_to_number(info_rec.deducted_wage_tax);
2296: l_labour_tax_reduction:=fnd_number.canonical_to_number(info_rec.labour_tax_reduction);
2297: l_ZVW:=fnd_number.canonical_to_number(info_rec.ZVW_Cont);
2298: l_ZVW_Basis:=fnd_number.canonical_to_number(info_rec.ZVW_Basis);
2299: l_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Private_Use_Car);
2300: l_Net_Expense_Allowance:=fnd_number.canonical_to_number(info_rec.Net_Expense_Allowance);

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

2293:
2294: l_taxable_income:=fnd_number.canonical_to_number(info_rec.taxable_income);
2295: l_deducted_wage_tax:=fnd_number.canonical_to_number(info_rec.deducted_wage_tax);
2296: l_labour_tax_reduction:=fnd_number.canonical_to_number(info_rec.labour_tax_reduction);
2297: l_ZVW:=fnd_number.canonical_to_number(info_rec.ZVW_Cont);
2298: l_ZVW_Basis:=fnd_number.canonical_to_number(info_rec.ZVW_Basis);
2299: l_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Private_Use_Car);
2300: l_Net_Expense_Allowance:=fnd_number.canonical_to_number(info_rec.Net_Expense_Allowance);
2301: l_Value_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Value_Private_Use_Car);

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

2294: l_taxable_income:=fnd_number.canonical_to_number(info_rec.taxable_income);
2295: l_deducted_wage_tax:=fnd_number.canonical_to_number(info_rec.deducted_wage_tax);
2296: l_labour_tax_reduction:=fnd_number.canonical_to_number(info_rec.labour_tax_reduction);
2297: l_ZVW:=fnd_number.canonical_to_number(info_rec.ZVW_Cont);
2298: l_ZVW_Basis:=fnd_number.canonical_to_number(info_rec.ZVW_Basis);
2299: l_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Private_Use_Car);
2300: l_Net_Expense_Allowance:=fnd_number.canonical_to_number(info_rec.Net_Expense_Allowance);
2301: l_Value_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Value_Private_Use_Car);
2302: l_Saved_Amount_LSS:=fnd_number.canonical_to_number(info_rec.Saved_Amount_LSS);

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

2295: l_deducted_wage_tax:=fnd_number.canonical_to_number(info_rec.deducted_wage_tax);
2296: l_labour_tax_reduction:=fnd_number.canonical_to_number(info_rec.labour_tax_reduction);
2297: l_ZVW:=fnd_number.canonical_to_number(info_rec.ZVW_Cont);
2298: l_ZVW_Basis:=fnd_number.canonical_to_number(info_rec.ZVW_Basis);
2299: l_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Private_Use_Car);
2300: l_Net_Expense_Allowance:=fnd_number.canonical_to_number(info_rec.Net_Expense_Allowance);
2301: l_Value_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Value_Private_Use_Car);
2302: l_Saved_Amount_LSS:=fnd_number.canonical_to_number(info_rec.Saved_Amount_LSS);
2303: l_Employer_Child_Care:=fnd_number.canonical_to_number(info_rec.Employer_Child_Care);

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

2296: l_labour_tax_reduction:=fnd_number.canonical_to_number(info_rec.labour_tax_reduction);
2297: l_ZVW:=fnd_number.canonical_to_number(info_rec.ZVW_Cont);
2298: l_ZVW_Basis:=fnd_number.canonical_to_number(info_rec.ZVW_Basis);
2299: l_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Private_Use_Car);
2300: l_Net_Expense_Allowance:=fnd_number.canonical_to_number(info_rec.Net_Expense_Allowance);
2301: l_Value_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Value_Private_Use_Car);
2302: l_Saved_Amount_LSS:=fnd_number.canonical_to_number(info_rec.Saved_Amount_LSS);
2303: l_Employer_Child_Care:=fnd_number.canonical_to_number(info_rec.Employer_Child_Care);
2304: l_Allowance_on_Disability:=fnd_number.canonical_to_number(info_rec.Allowance_on_Disability);

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

2297: l_ZVW:=fnd_number.canonical_to_number(info_rec.ZVW_Cont);
2298: l_ZVW_Basis:=fnd_number.canonical_to_number(info_rec.ZVW_Basis);
2299: l_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Private_Use_Car);
2300: l_Net_Expense_Allowance:=fnd_number.canonical_to_number(info_rec.Net_Expense_Allowance);
2301: l_Value_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Value_Private_Use_Car);
2302: l_Saved_Amount_LSS:=fnd_number.canonical_to_number(info_rec.Saved_Amount_LSS);
2303: l_Employer_Child_Care:=fnd_number.canonical_to_number(info_rec.Employer_Child_Care);
2304: l_Allowance_on_Disability:=fnd_number.canonical_to_number(info_rec.Allowance_on_Disability);
2305: l_Applied_LCLD:=fnd_number.canonical_to_number(info_rec.Applied_LCLD);

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

2298: l_ZVW_Basis:=fnd_number.canonical_to_number(info_rec.ZVW_Basis);
2299: l_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Private_Use_Car);
2300: l_Net_Expense_Allowance:=fnd_number.canonical_to_number(info_rec.Net_Expense_Allowance);
2301: l_Value_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Value_Private_Use_Car);
2302: l_Saved_Amount_LSS:=fnd_number.canonical_to_number(info_rec.Saved_Amount_LSS);
2303: l_Employer_Child_Care:=fnd_number.canonical_to_number(info_rec.Employer_Child_Care);
2304: l_Allowance_on_Disability:=fnd_number.canonical_to_number(info_rec.Allowance_on_Disability);
2305: l_Applied_LCLD:=fnd_number.canonical_to_number(info_rec.Applied_LCLD);
2306: populate_UserBalVal(info_rec.User_Bal_String,'N');

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

2299: l_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Private_Use_Car);
2300: l_Net_Expense_Allowance:=fnd_number.canonical_to_number(info_rec.Net_Expense_Allowance);
2301: l_Value_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Value_Private_Use_Car);
2302: l_Saved_Amount_LSS:=fnd_number.canonical_to_number(info_rec.Saved_Amount_LSS);
2303: l_Employer_Child_Care:=fnd_number.canonical_to_number(info_rec.Employer_Child_Care);
2304: l_Allowance_on_Disability:=fnd_number.canonical_to_number(info_rec.Allowance_on_Disability);
2305: l_Applied_LCLD:=fnd_number.canonical_to_number(info_rec.Applied_LCLD);
2306: populate_UserBalVal(info_rec.User_Bal_String,'N');
2307:

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

2300: l_Net_Expense_Allowance:=fnd_number.canonical_to_number(info_rec.Net_Expense_Allowance);
2301: l_Value_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Value_Private_Use_Car);
2302: l_Saved_Amount_LSS:=fnd_number.canonical_to_number(info_rec.Saved_Amount_LSS);
2303: l_Employer_Child_Care:=fnd_number.canonical_to_number(info_rec.Employer_Child_Care);
2304: l_Allowance_on_Disability:=fnd_number.canonical_to_number(info_rec.Allowance_on_Disability);
2305: l_Applied_LCLD:=fnd_number.canonical_to_number(info_rec.Applied_LCLD);
2306: populate_UserBalVal(info_rec.User_Bal_String,'N');
2307:
2308:

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

2301: l_Value_Private_Use_Car:=fnd_number.canonical_to_number(info_rec.Value_Private_Use_Car);
2302: l_Saved_Amount_LSS:=fnd_number.canonical_to_number(info_rec.Saved_Amount_LSS);
2303: l_Employer_Child_Care:=fnd_number.canonical_to_number(info_rec.Employer_Child_Care);
2304: l_Allowance_on_Disability:=fnd_number.canonical_to_number(info_rec.Allowance_on_Disability);
2305: l_Applied_LCLD:=fnd_number.canonical_to_number(info_rec.Applied_LCLD);
2306: populate_UserBalVal(info_rec.User_Bal_String,'N');
2307:
2308:
2309:

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

3265: FOR lCtr IN PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.FIRST .. PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.LAST LOOP
3266:
3267: l_end := instr(p_User_Bal_String,'|',l_start,1);
3268:
3269: vUserBalVal(lCtr).BalValue := fnd_number.canonical_to_number(substr(p_User_Bal_String,l_start,l_end-l_start));
3270: vUserBalVal(lCtr).TagName := PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable(lCtr).TagName;
3271:
3272: hr_utility.set_location('tag-'||vUserBalVal(lCtr).TagName,13);
3273: hr_utility.set_location('bal-'||vUserBalVal(lCtr).BalValue,23);

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

3281: FOR lCtr IN PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.FIRST .. PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable.LAST LOOP
3282:
3283: l_end := instr(p_User_Bal_String,'|',l_start,1);
3284:
3285: vUserBalVal(lCtr).BalValue := vUserBalVal(lCtr).BalValue + fnd_number.canonical_to_number(substr(p_User_Bal_String,l_start,l_end-l_start));
3286: vUserBalVal(lCtr).TagName := PAY_NL_TAXOFFICE_ARCHIVE.vUserBalTable(lCtr).TagName;
3287:
3288: l_start := l_end + 1;
3289: