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_TAXOFFICE_ARCHIVE dependencies on FND_NUMBER

Line 645: ,p_action_information1 => fnd_number.number_to_canonical(l_employer_id)

641: ,p_effective_date => l_ATS_Process_Date
642: ,p_source_id => NULL
643: ,p_source_text => NULL
644: ,p_action_information_category => 'NL ATS EMPLOYEE DETAILS'
645: ,p_action_information1 => fnd_number.number_to_canonical(l_employer_id)
646: ,p_action_information2 => fnd_number.number_to_canonical(l_person_id)
647: ,p_action_information3 => fnd_number.number_to_canonical(l_assignment_id)
648: --,p_action_information4 => l_wage --11886537
649: ,p_action_information4 => fnd_number.number_to_canonical(l_wage) --11886537

Line 646: ,p_action_information2 => fnd_number.number_to_canonical(l_person_id)

642: ,p_source_id => NULL
643: ,p_source_text => NULL
644: ,p_action_information_category => 'NL ATS EMPLOYEE DETAILS'
645: ,p_action_information1 => fnd_number.number_to_canonical(l_employer_id)
646: ,p_action_information2 => fnd_number.number_to_canonical(l_person_id)
647: ,p_action_information3 => fnd_number.number_to_canonical(l_assignment_id)
648: --,p_action_information4 => l_wage --11886537
649: ,p_action_information4 => fnd_number.number_to_canonical(l_wage) --11886537
650: --,p_action_information5 => l_deduct_wage_tax_si_cont --11886537

Line 647: ,p_action_information3 => fnd_number.number_to_canonical(l_assignment_id)

643: ,p_source_text => NULL
644: ,p_action_information_category => 'NL ATS EMPLOYEE DETAILS'
645: ,p_action_information1 => fnd_number.number_to_canonical(l_employer_id)
646: ,p_action_information2 => fnd_number.number_to_canonical(l_person_id)
647: ,p_action_information3 => fnd_number.number_to_canonical(l_assignment_id)
648: --,p_action_information4 => l_wage --11886537
649: ,p_action_information4 => fnd_number.number_to_canonical(l_wage) --11886537
650: --,p_action_information5 => l_deduct_wage_tax_si_cont --11886537
651: ,p_action_information5 => fnd_number.number_to_canonical(l_deduct_wage_tax_si_cont) --11886537

Line 649: ,p_action_information4 => fnd_number.number_to_canonical(l_wage) --11886537

645: ,p_action_information1 => fnd_number.number_to_canonical(l_employer_id)
646: ,p_action_information2 => fnd_number.number_to_canonical(l_person_id)
647: ,p_action_information3 => fnd_number.number_to_canonical(l_assignment_id)
648: --,p_action_information4 => l_wage --11886537
649: ,p_action_information4 => fnd_number.number_to_canonical(l_wage) --11886537
650: --,p_action_information5 => l_deduct_wage_tax_si_cont --11886537
651: ,p_action_information5 => fnd_number.number_to_canonical(l_deduct_wage_tax_si_cont) --11886537
652: ,p_action_information6 => l_asg_start_date
653: ,p_action_information7 => l_asg_end_date

Line 651: ,p_action_information5 => fnd_number.number_to_canonical(l_deduct_wage_tax_si_cont) --11886537

647: ,p_action_information3 => fnd_number.number_to_canonical(l_assignment_id)
648: --,p_action_information4 => l_wage --11886537
649: ,p_action_information4 => fnd_number.number_to_canonical(l_wage) --11886537
650: --,p_action_information5 => l_deduct_wage_tax_si_cont --11886537
651: ,p_action_information5 => fnd_number.number_to_canonical(l_deduct_wage_tax_si_cont) --11886537
652: ,p_action_information6 => l_asg_start_date
653: ,p_action_information7 => l_asg_end_date
654: --,p_action_information8 => l_Labour_Discount --11886537
655: ,p_action_information8 => fnd_number.number_to_canonical(l_Labour_Discount) --11886537

Line 655: ,p_action_information8 => fnd_number.number_to_canonical(l_Labour_Discount) --11886537

651: ,p_action_information5 => fnd_number.number_to_canonical(l_deduct_wage_tax_si_cont) --11886537
652: ,p_action_information6 => l_asg_start_date
653: ,p_action_information7 => l_asg_end_date
654: --,p_action_information8 => l_Labour_Discount --11886537
655: ,p_action_information8 => fnd_number.number_to_canonical(l_Labour_Discount) --11886537
656: ,p_action_information9 => l_Wage_Tax_Discount
657: ,p_action_information10 => l_Wage_Tax_Table_Code
658: ,p_action_information11 => l_Income_Code
659: ,p_action_information12 => l_Special_Indicator

Line 662: ,p_action_information15 => fnd_number.number_to_canonical(l_ZVW_Contribution)

658: ,p_action_information11 => l_Income_Code
659: ,p_action_information12 => l_Special_Indicator
660: ,p_action_information13 => l_Amount_Special_Indicator
661: ,p_action_information14 => l_SI_Insured_Flag
662: ,p_action_information15 => fnd_number.number_to_canonical(l_ZVW_Contribution)
663: ,p_action_information16 => fnd_number.number_to_canonical(l_Net_Expense_Allowance)
664: ,p_action_information17 => fnd_number.number_to_canonical(l_Private_Use_Car)
665: --,p_action_information18 => l_taxable_income --11886537
666: ,p_action_information18 => fnd_number.number_to_canonical(l_taxable_income) --11886537

Line 663: ,p_action_information16 => fnd_number.number_to_canonical(l_Net_Expense_Allowance)

659: ,p_action_information12 => l_Special_Indicator
660: ,p_action_information13 => l_Amount_Special_Indicator
661: ,p_action_information14 => l_SI_Insured_Flag
662: ,p_action_information15 => fnd_number.number_to_canonical(l_ZVW_Contribution)
663: ,p_action_information16 => fnd_number.number_to_canonical(l_Net_Expense_Allowance)
664: ,p_action_information17 => fnd_number.number_to_canonical(l_Private_Use_Car)
665: --,p_action_information18 => l_taxable_income --11886537
666: ,p_action_information18 => fnd_number.number_to_canonical(l_taxable_income) --11886537
667: ,p_action_information19 => fnd_number.number_to_canonical(l_ZVW_Basis)

Line 664: ,p_action_information17 => fnd_number.number_to_canonical(l_Private_Use_Car)

660: ,p_action_information13 => l_Amount_Special_Indicator
661: ,p_action_information14 => l_SI_Insured_Flag
662: ,p_action_information15 => fnd_number.number_to_canonical(l_ZVW_Contribution)
663: ,p_action_information16 => fnd_number.number_to_canonical(l_Net_Expense_Allowance)
664: ,p_action_information17 => fnd_number.number_to_canonical(l_Private_Use_Car)
665: --,p_action_information18 => l_taxable_income --11886537
666: ,p_action_information18 => fnd_number.number_to_canonical(l_taxable_income) --11886537
667: ,p_action_information19 => fnd_number.number_to_canonical(l_ZVW_Basis)
668: ,p_action_information20 => fnd_number.number_to_canonical(l_Value_Private_Use_Car)

Line 666: ,p_action_information18 => fnd_number.number_to_canonical(l_taxable_income) --11886537

662: ,p_action_information15 => fnd_number.number_to_canonical(l_ZVW_Contribution)
663: ,p_action_information16 => fnd_number.number_to_canonical(l_Net_Expense_Allowance)
664: ,p_action_information17 => fnd_number.number_to_canonical(l_Private_Use_Car)
665: --,p_action_information18 => l_taxable_income --11886537
666: ,p_action_information18 => fnd_number.number_to_canonical(l_taxable_income) --11886537
667: ,p_action_information19 => fnd_number.number_to_canonical(l_ZVW_Basis)
668: ,p_action_information20 => fnd_number.number_to_canonical(l_Value_Private_Use_Car)
669: ,p_action_information21 => fnd_number.number_to_canonical(l_LSS_Saved_Amount)
670: ,p_action_information22 => fnd_number.number_to_canonical(l_Employer_Part_Child_Care)

Line 667: ,p_action_information19 => fnd_number.number_to_canonical(l_ZVW_Basis)

663: ,p_action_information16 => fnd_number.number_to_canonical(l_Net_Expense_Allowance)
664: ,p_action_information17 => fnd_number.number_to_canonical(l_Private_Use_Car)
665: --,p_action_information18 => l_taxable_income --11886537
666: ,p_action_information18 => fnd_number.number_to_canonical(l_taxable_income) --11886537
667: ,p_action_information19 => fnd_number.number_to_canonical(l_ZVW_Basis)
668: ,p_action_information20 => fnd_number.number_to_canonical(l_Value_Private_Use_Car)
669: ,p_action_information21 => fnd_number.number_to_canonical(l_LSS_Saved_Amount)
670: ,p_action_information22 => fnd_number.number_to_canonical(l_Employer_Part_Child_Care)
671: ,p_action_information23 => fnd_number.number_to_canonical(l_Allowance_On_Disability)

Line 668: ,p_action_information20 => fnd_number.number_to_canonical(l_Value_Private_Use_Car)

664: ,p_action_information17 => fnd_number.number_to_canonical(l_Private_Use_Car)
665: --,p_action_information18 => l_taxable_income --11886537
666: ,p_action_information18 => fnd_number.number_to_canonical(l_taxable_income) --11886537
667: ,p_action_information19 => fnd_number.number_to_canonical(l_ZVW_Basis)
668: ,p_action_information20 => fnd_number.number_to_canonical(l_Value_Private_Use_Car)
669: ,p_action_information21 => fnd_number.number_to_canonical(l_LSS_Saved_Amount)
670: ,p_action_information22 => fnd_number.number_to_canonical(l_Employer_Part_Child_Care)
671: ,p_action_information23 => fnd_number.number_to_canonical(l_Allowance_On_Disability)
672: ,p_action_information24 => fnd_number.number_to_canonical(l_Applied_LCLD)

Line 669: ,p_action_information21 => fnd_number.number_to_canonical(l_LSS_Saved_Amount)

665: --,p_action_information18 => l_taxable_income --11886537
666: ,p_action_information18 => fnd_number.number_to_canonical(l_taxable_income) --11886537
667: ,p_action_information19 => fnd_number.number_to_canonical(l_ZVW_Basis)
668: ,p_action_information20 => fnd_number.number_to_canonical(l_Value_Private_Use_Car)
669: ,p_action_information21 => fnd_number.number_to_canonical(l_LSS_Saved_Amount)
670: ,p_action_information22 => fnd_number.number_to_canonical(l_Employer_Part_Child_Care)
671: ,p_action_information23 => fnd_number.number_to_canonical(l_Allowance_On_Disability)
672: ,p_action_information24 => fnd_number.number_to_canonical(l_Applied_LCLD)
673: ,p_action_information25 => l_User_Bal_String);

Line 670: ,p_action_information22 => fnd_number.number_to_canonical(l_Employer_Part_Child_Care)

666: ,p_action_information18 => fnd_number.number_to_canonical(l_taxable_income) --11886537
667: ,p_action_information19 => fnd_number.number_to_canonical(l_ZVW_Basis)
668: ,p_action_information20 => fnd_number.number_to_canonical(l_Value_Private_Use_Car)
669: ,p_action_information21 => fnd_number.number_to_canonical(l_LSS_Saved_Amount)
670: ,p_action_information22 => fnd_number.number_to_canonical(l_Employer_Part_Child_Care)
671: ,p_action_information23 => fnd_number.number_to_canonical(l_Allowance_On_Disability)
672: ,p_action_information24 => fnd_number.number_to_canonical(l_Applied_LCLD)
673: ,p_action_information25 => l_User_Bal_String);
674:

Line 671: ,p_action_information23 => fnd_number.number_to_canonical(l_Allowance_On_Disability)

667: ,p_action_information19 => fnd_number.number_to_canonical(l_ZVW_Basis)
668: ,p_action_information20 => fnd_number.number_to_canonical(l_Value_Private_Use_Car)
669: ,p_action_information21 => fnd_number.number_to_canonical(l_LSS_Saved_Amount)
670: ,p_action_information22 => fnd_number.number_to_canonical(l_Employer_Part_Child_Care)
671: ,p_action_information23 => fnd_number.number_to_canonical(l_Allowance_On_Disability)
672: ,p_action_information24 => fnd_number.number_to_canonical(l_Applied_LCLD)
673: ,p_action_information25 => l_User_Bal_String);
674:
675: END IF;

Line 672: ,p_action_information24 => fnd_number.number_to_canonical(l_Applied_LCLD)

668: ,p_action_information20 => fnd_number.number_to_canonical(l_Value_Private_Use_Car)
669: ,p_action_information21 => fnd_number.number_to_canonical(l_LSS_Saved_Amount)
670: ,p_action_information22 => fnd_number.number_to_canonical(l_Employer_Part_Child_Care)
671: ,p_action_information23 => fnd_number.number_to_canonical(l_Allowance_On_Disability)
672: ,p_action_information24 => fnd_number.number_to_canonical(l_Applied_LCLD)
673: ,p_action_information25 => l_User_Bal_String);
674:
675: END IF;
676: end if;

Line 747: fnd_number.canonical_to_number(substr(max(lpad(NVL(paa.action_sequence,0),15,'0')||paa.assignment_action_id),16)) Max_Asg_Act

743:
744: CURSOR csr_max_assgt_act_id IS
745: SELECT
746: --MAX(assignment_action_id) --11868538
747: fnd_number.canonical_to_number(substr(max(lpad(NVL(paa.action_sequence,0),15,'0')||paa.assignment_action_id),16)) Max_Asg_Act
748: from pay_assignment_actions paa
749: ,pay_payroll_actions ppa
750: ,pay_payrolls_f ppf
751: where paa.payroll_action_id =ppa.payroll_action_id

Line 3482: l_balance_string := l_balance_string||fnd_number.number_to_canonical(ceil(l_balance_value))||'|';

3478: ELSE
3479: l_balance_value := pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
3480: END IF;
3481:
3482: l_balance_string := l_balance_string||fnd_number.number_to_canonical(ceil(l_balance_value))||'|';
3483:
3484: END LOOP;
3485:
3486: p_User_Bal_String := l_balance_string;