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

Line 1562: fnd_number.canonical_to_number(nvl(ppm.pem_information2,0)), -- Annual Salary

1558: Return Number is
1559: /*Bug:3919215 Modified the cursor. selected Employer classification of prev emplr */
1560: Cursor c_prev_emp_details is
1561: select nvl(ppm.pem_information1,'X'), -- Designation
1562: fnd_number.canonical_to_number(nvl(ppm.pem_information2,0)), -- Annual Salary
1563: nvl(ppm.pem_information3,'X'), -- PF Number
1564: nvl(ppm.pem_information4,'X'), -- PF Establishment Code
1565: nvl(ppm.pem_information5,'X'), -- EPF Number
1566: nvl(ppm.pem_information6,'X'), -- Emplr class

Line 1567: fnd_number.canonical_to_number(nvl(ppm.pem_information8,0)), -- LTC Curr

1563: nvl(ppm.pem_information3,'X'), -- PF Number
1564: nvl(ppm.pem_information4,'X'), -- PF Establishment Code
1565: nvl(ppm.pem_information5,'X'), -- EPF Number
1566: nvl(ppm.pem_information6,'X'), -- Emplr class
1567: fnd_number.canonical_to_number(nvl(ppm.pem_information8,0)), -- LTC Curr
1568: fnd_number.canonical_to_number(nvl(ppm.pem_information9,0)), -- Leave Encashment
1569: fnd_number.canonical_to_number(nvl(ppm.pem_information10,0)), -- Gratuity
1570: fnd_number.canonical_to_number(nvl(ppm.pem_information11,0)), -- Retrenchment Amount
1571: fnd_number.canonical_to_number(nvl(ppm.pem_information12,0)), -- VRS

Line 1568: fnd_number.canonical_to_number(nvl(ppm.pem_information9,0)), -- Leave Encashment

1564: nvl(ppm.pem_information4,'X'), -- PF Establishment Code
1565: nvl(ppm.pem_information5,'X'), -- EPF Number
1566: nvl(ppm.pem_information6,'X'), -- Emplr class
1567: fnd_number.canonical_to_number(nvl(ppm.pem_information8,0)), -- LTC Curr
1568: fnd_number.canonical_to_number(nvl(ppm.pem_information9,0)), -- Leave Encashment
1569: fnd_number.canonical_to_number(nvl(ppm.pem_information10,0)), -- Gratuity
1570: fnd_number.canonical_to_number(nvl(ppm.pem_information11,0)), -- Retrenchment Amount
1571: fnd_number.canonical_to_number(nvl(ppm.pem_information12,0)), -- VRS
1572: fnd_number.canonical_to_number(nvl(ppm.pem_information13,0)), -- Gross Sal

Line 1569: fnd_number.canonical_to_number(nvl(ppm.pem_information10,0)), -- Gratuity

1565: nvl(ppm.pem_information5,'X'), -- EPF Number
1566: nvl(ppm.pem_information6,'X'), -- Emplr class
1567: fnd_number.canonical_to_number(nvl(ppm.pem_information8,0)), -- LTC Curr
1568: fnd_number.canonical_to_number(nvl(ppm.pem_information9,0)), -- Leave Encashment
1569: fnd_number.canonical_to_number(nvl(ppm.pem_information10,0)), -- Gratuity
1570: fnd_number.canonical_to_number(nvl(ppm.pem_information11,0)), -- Retrenchment Amount
1571: fnd_number.canonical_to_number(nvl(ppm.pem_information12,0)), -- VRS
1572: fnd_number.canonical_to_number(nvl(ppm.pem_information13,0)), -- Gross Sal
1573: fnd_number.canonical_to_number(nvl(ppm.pem_information14,0)), -- PF

Line 1570: fnd_number.canonical_to_number(nvl(ppm.pem_information11,0)), -- Retrenchment Amount

1566: nvl(ppm.pem_information6,'X'), -- Emplr class
1567: fnd_number.canonical_to_number(nvl(ppm.pem_information8,0)), -- LTC Curr
1568: fnd_number.canonical_to_number(nvl(ppm.pem_information9,0)), -- Leave Encashment
1569: fnd_number.canonical_to_number(nvl(ppm.pem_information10,0)), -- Gratuity
1570: fnd_number.canonical_to_number(nvl(ppm.pem_information11,0)), -- Retrenchment Amount
1571: fnd_number.canonical_to_number(nvl(ppm.pem_information12,0)), -- VRS
1572: fnd_number.canonical_to_number(nvl(ppm.pem_information13,0)), -- Gross Sal
1573: fnd_number.canonical_to_number(nvl(ppm.pem_information14,0)), -- PF
1574: fnd_number.canonical_to_number(nvl(ppm.pem_information15,0)), -- Ent Alw

Line 1571: fnd_number.canonical_to_number(nvl(ppm.pem_information12,0)), -- VRS

1567: fnd_number.canonical_to_number(nvl(ppm.pem_information8,0)), -- LTC Curr
1568: fnd_number.canonical_to_number(nvl(ppm.pem_information9,0)), -- Leave Encashment
1569: fnd_number.canonical_to_number(nvl(ppm.pem_information10,0)), -- Gratuity
1570: fnd_number.canonical_to_number(nvl(ppm.pem_information11,0)), -- Retrenchment Amount
1571: fnd_number.canonical_to_number(nvl(ppm.pem_information12,0)), -- VRS
1572: fnd_number.canonical_to_number(nvl(ppm.pem_information13,0)), -- Gross Sal
1573: fnd_number.canonical_to_number(nvl(ppm.pem_information14,0)), -- PF
1574: fnd_number.canonical_to_number(nvl(ppm.pem_information15,0)), -- Ent Alw
1575: fnd_number.canonical_to_number(nvl(ppm.pem_information16,0)), -- PT

Line 1572: fnd_number.canonical_to_number(nvl(ppm.pem_information13,0)), -- Gross Sal

1568: fnd_number.canonical_to_number(nvl(ppm.pem_information9,0)), -- Leave Encashment
1569: fnd_number.canonical_to_number(nvl(ppm.pem_information10,0)), -- Gratuity
1570: fnd_number.canonical_to_number(nvl(ppm.pem_information11,0)), -- Retrenchment Amount
1571: fnd_number.canonical_to_number(nvl(ppm.pem_information12,0)), -- VRS
1572: fnd_number.canonical_to_number(nvl(ppm.pem_information13,0)), -- Gross Sal
1573: fnd_number.canonical_to_number(nvl(ppm.pem_information14,0)), -- PF
1574: fnd_number.canonical_to_number(nvl(ppm.pem_information15,0)), -- Ent Alw
1575: fnd_number.canonical_to_number(nvl(ppm.pem_information16,0)), -- PT
1576: fnd_number.canonical_to_number(nvl(ppm.pem_information17,0)), -- TDS

Line 1573: fnd_number.canonical_to_number(nvl(ppm.pem_information14,0)), -- PF

1569: fnd_number.canonical_to_number(nvl(ppm.pem_information10,0)), -- Gratuity
1570: fnd_number.canonical_to_number(nvl(ppm.pem_information11,0)), -- Retrenchment Amount
1571: fnd_number.canonical_to_number(nvl(ppm.pem_information12,0)), -- VRS
1572: fnd_number.canonical_to_number(nvl(ppm.pem_information13,0)), -- Gross Sal
1573: fnd_number.canonical_to_number(nvl(ppm.pem_information14,0)), -- PF
1574: fnd_number.canonical_to_number(nvl(ppm.pem_information15,0)), -- Ent Alw
1575: fnd_number.canonical_to_number(nvl(ppm.pem_information16,0)), -- PT
1576: fnd_number.canonical_to_number(nvl(ppm.pem_information17,0)), -- TDS
1577: fnd_number.canonical_to_number(nvl(ppm.pem_information18,0)), -- Superannuation

Line 1574: fnd_number.canonical_to_number(nvl(ppm.pem_information15,0)), -- Ent Alw

1570: fnd_number.canonical_to_number(nvl(ppm.pem_information11,0)), -- Retrenchment Amount
1571: fnd_number.canonical_to_number(nvl(ppm.pem_information12,0)), -- VRS
1572: fnd_number.canonical_to_number(nvl(ppm.pem_information13,0)), -- Gross Sal
1573: fnd_number.canonical_to_number(nvl(ppm.pem_information14,0)), -- PF
1574: fnd_number.canonical_to_number(nvl(ppm.pem_information15,0)), -- Ent Alw
1575: fnd_number.canonical_to_number(nvl(ppm.pem_information16,0)), -- PT
1576: fnd_number.canonical_to_number(nvl(ppm.pem_information17,0)), -- TDS
1577: fnd_number.canonical_to_number(nvl(ppm.pem_information18,0)), -- Superannuation
1578: fnd_number.canonical_to_number(nvl(ppm.pem_information19,0)), -- Prev Surcharge

Line 1575: fnd_number.canonical_to_number(nvl(ppm.pem_information16,0)), -- PT

1571: fnd_number.canonical_to_number(nvl(ppm.pem_information12,0)), -- VRS
1572: fnd_number.canonical_to_number(nvl(ppm.pem_information13,0)), -- Gross Sal
1573: fnd_number.canonical_to_number(nvl(ppm.pem_information14,0)), -- PF
1574: fnd_number.canonical_to_number(nvl(ppm.pem_information15,0)), -- Ent Alw
1575: fnd_number.canonical_to_number(nvl(ppm.pem_information16,0)), -- PT
1576: fnd_number.canonical_to_number(nvl(ppm.pem_information17,0)), -- TDS
1577: fnd_number.canonical_to_number(nvl(ppm.pem_information18,0)), -- Superannuation
1578: fnd_number.canonical_to_number(nvl(ppm.pem_information19,0)), -- Prev Surcharge
1579: fnd_number.canonical_to_number(nvl(ppm.pem_information20,0)), -- Prev Cess

Line 1576: fnd_number.canonical_to_number(nvl(ppm.pem_information17,0)), -- TDS

1572: fnd_number.canonical_to_number(nvl(ppm.pem_information13,0)), -- Gross Sal
1573: fnd_number.canonical_to_number(nvl(ppm.pem_information14,0)), -- PF
1574: fnd_number.canonical_to_number(nvl(ppm.pem_information15,0)), -- Ent Alw
1575: fnd_number.canonical_to_number(nvl(ppm.pem_information16,0)), -- PT
1576: fnd_number.canonical_to_number(nvl(ppm.pem_information17,0)), -- TDS
1577: fnd_number.canonical_to_number(nvl(ppm.pem_information18,0)), -- Superannuation
1578: fnd_number.canonical_to_number(nvl(ppm.pem_information19,0)), -- Prev Surcharge
1579: fnd_number.canonical_to_number(nvl(ppm.pem_information20,0)), -- Prev Cess
1580: fnd_number.canonical_to_number(nvl(ppm.pem_information21,0)), -- Exemption under 80gg

Line 1577: fnd_number.canonical_to_number(nvl(ppm.pem_information18,0)), -- Superannuation

1573: fnd_number.canonical_to_number(nvl(ppm.pem_information14,0)), -- PF
1574: fnd_number.canonical_to_number(nvl(ppm.pem_information15,0)), -- Ent Alw
1575: fnd_number.canonical_to_number(nvl(ppm.pem_information16,0)), -- PT
1576: fnd_number.canonical_to_number(nvl(ppm.pem_information17,0)), -- TDS
1577: fnd_number.canonical_to_number(nvl(ppm.pem_information18,0)), -- Superannuation
1578: fnd_number.canonical_to_number(nvl(ppm.pem_information19,0)), -- Prev Surcharge
1579: fnd_number.canonical_to_number(nvl(ppm.pem_information20,0)), -- Prev Cess
1580: fnd_number.canonical_to_number(nvl(ppm.pem_information21,0)), -- Exemption under 80gg
1581: fnd_number.canonical_to_number(nvl(ppm.pem_information22,0)), -- Medical Reimbursement

Line 1578: fnd_number.canonical_to_number(nvl(ppm.pem_information19,0)), -- Prev Surcharge

1574: fnd_number.canonical_to_number(nvl(ppm.pem_information15,0)), -- Ent Alw
1575: fnd_number.canonical_to_number(nvl(ppm.pem_information16,0)), -- PT
1576: fnd_number.canonical_to_number(nvl(ppm.pem_information17,0)), -- TDS
1577: fnd_number.canonical_to_number(nvl(ppm.pem_information18,0)), -- Superannuation
1578: fnd_number.canonical_to_number(nvl(ppm.pem_information19,0)), -- Prev Surcharge
1579: fnd_number.canonical_to_number(nvl(ppm.pem_information20,0)), -- Prev Cess
1580: fnd_number.canonical_to_number(nvl(ppm.pem_information21,0)), -- Exemption under 80gg
1581: fnd_number.canonical_to_number(nvl(ppm.pem_information22,0)), -- Medical Reimbursement
1582: fnd_number.canonical_to_number(nvl(ppm.pem_information23,0)), -- Sec and HE Cess

Line 1579: fnd_number.canonical_to_number(nvl(ppm.pem_information20,0)), -- Prev Cess

1575: fnd_number.canonical_to_number(nvl(ppm.pem_information16,0)), -- PT
1576: fnd_number.canonical_to_number(nvl(ppm.pem_information17,0)), -- TDS
1577: fnd_number.canonical_to_number(nvl(ppm.pem_information18,0)), -- Superannuation
1578: fnd_number.canonical_to_number(nvl(ppm.pem_information19,0)), -- Prev Surcharge
1579: fnd_number.canonical_to_number(nvl(ppm.pem_information20,0)), -- Prev Cess
1580: fnd_number.canonical_to_number(nvl(ppm.pem_information21,0)), -- Exemption under 80gg
1581: fnd_number.canonical_to_number(nvl(ppm.pem_information22,0)), -- Medical Reimbursement
1582: fnd_number.canonical_to_number(nvl(ppm.pem_information23,0)), -- Sec and HE Cess
1583: fnd_number.canonical_to_number(nvl(ppm.pem_information24,0)), -- Exemption under 80ccd

Line 1580: fnd_number.canonical_to_number(nvl(ppm.pem_information21,0)), -- Exemption under 80gg

1576: fnd_number.canonical_to_number(nvl(ppm.pem_information17,0)), -- TDS
1577: fnd_number.canonical_to_number(nvl(ppm.pem_information18,0)), -- Superannuation
1578: fnd_number.canonical_to_number(nvl(ppm.pem_information19,0)), -- Prev Surcharge
1579: fnd_number.canonical_to_number(nvl(ppm.pem_information20,0)), -- Prev Cess
1580: fnd_number.canonical_to_number(nvl(ppm.pem_information21,0)), -- Exemption under 80gg
1581: fnd_number.canonical_to_number(nvl(ppm.pem_information22,0)), -- Medical Reimbursement
1582: fnd_number.canonical_to_number(nvl(ppm.pem_information23,0)), -- Sec and HE Cess
1583: fnd_number.canonical_to_number(nvl(ppm.pem_information24,0)), -- Exemption under 80ccd
1584: fnd_number.canonical_to_number(nvl(ppm.pem_information25,0)), -- CGHS Exemption under 80D

Line 1581: fnd_number.canonical_to_number(nvl(ppm.pem_information22,0)), -- Medical Reimbursement

1577: fnd_number.canonical_to_number(nvl(ppm.pem_information18,0)), -- Superannuation
1578: fnd_number.canonical_to_number(nvl(ppm.pem_information19,0)), -- Prev Surcharge
1579: fnd_number.canonical_to_number(nvl(ppm.pem_information20,0)), -- Prev Cess
1580: fnd_number.canonical_to_number(nvl(ppm.pem_information21,0)), -- Exemption under 80gg
1581: fnd_number.canonical_to_number(nvl(ppm.pem_information22,0)), -- Medical Reimbursement
1582: fnd_number.canonical_to_number(nvl(ppm.pem_information23,0)), -- Sec and HE Cess
1583: fnd_number.canonical_to_number(nvl(ppm.pem_information24,0)), -- Exemption under 80ccd
1584: fnd_number.canonical_to_number(nvl(ppm.pem_information25,0)), -- CGHS Exemption under 80D
1585: ppm.end_date

Line 1582: fnd_number.canonical_to_number(nvl(ppm.pem_information23,0)), -- Sec and HE Cess

1578: fnd_number.canonical_to_number(nvl(ppm.pem_information19,0)), -- Prev Surcharge
1579: fnd_number.canonical_to_number(nvl(ppm.pem_information20,0)), -- Prev Cess
1580: fnd_number.canonical_to_number(nvl(ppm.pem_information21,0)), -- Exemption under 80gg
1581: fnd_number.canonical_to_number(nvl(ppm.pem_information22,0)), -- Medical Reimbursement
1582: fnd_number.canonical_to_number(nvl(ppm.pem_information23,0)), -- Sec and HE Cess
1583: fnd_number.canonical_to_number(nvl(ppm.pem_information24,0)), -- Exemption under 80ccd
1584: fnd_number.canonical_to_number(nvl(ppm.pem_information25,0)), -- CGHS Exemption under 80D
1585: ppm.end_date
1586: from per_previous_employers ppm,

Line 1583: fnd_number.canonical_to_number(nvl(ppm.pem_information24,0)), -- Exemption under 80ccd

1579: fnd_number.canonical_to_number(nvl(ppm.pem_information20,0)), -- Prev Cess
1580: fnd_number.canonical_to_number(nvl(ppm.pem_information21,0)), -- Exemption under 80gg
1581: fnd_number.canonical_to_number(nvl(ppm.pem_information22,0)), -- Medical Reimbursement
1582: fnd_number.canonical_to_number(nvl(ppm.pem_information23,0)), -- Sec and HE Cess
1583: fnd_number.canonical_to_number(nvl(ppm.pem_information24,0)), -- Exemption under 80ccd
1584: fnd_number.canonical_to_number(nvl(ppm.pem_information25,0)), -- CGHS Exemption under 80D
1585: ppm.end_date
1586: from per_previous_employers ppm,
1587: per_all_assignments_f paa

Line 1584: fnd_number.canonical_to_number(nvl(ppm.pem_information25,0)), -- CGHS Exemption under 80D

1580: fnd_number.canonical_to_number(nvl(ppm.pem_information21,0)), -- Exemption under 80gg
1581: fnd_number.canonical_to_number(nvl(ppm.pem_information22,0)), -- Medical Reimbursement
1582: fnd_number.canonical_to_number(nvl(ppm.pem_information23,0)), -- Sec and HE Cess
1583: fnd_number.canonical_to_number(nvl(ppm.pem_information24,0)), -- Exemption under 80ccd
1584: fnd_number.canonical_to_number(nvl(ppm.pem_information25,0)), -- CGHS Exemption under 80D
1585: ppm.end_date
1586: from per_previous_employers ppm,
1587: per_all_assignments_f paa
1588: where paa.assignment_id = p_assignment_id

Line 2069: Return fnd_number.canonical_to_number(l_rent_paid);

2065: Close c_act_rent_paid;
2066:
2067: pay_in_utils.set_location(g_debug,'Rent paid is' || l_rent_paid,20);
2068: pay_in_utils.trace('**************************************************','********************');
2069: Return fnd_number.canonical_to_number(l_rent_paid);
2070: Else
2071: pay_in_utils.trace('**************************************************','********************');
2072: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);
2073: Return 0;

Line 2339: SELECT fnd_number.canonical_to_number(exemption_amount)

2335: WHERE element_type_id = p_element_type_id
2336: AND p_date_earned BETWEEN effective_start_date AND effective_end_date;
2337:
2338: CURSOR c_exemption (p_perk_name IN VARCHAR2) IS
2339: SELECT fnd_number.canonical_to_number(exemption_amount)
2340: FROM pay_in_other_perquisites_v
2341: WHERE perquisite_name = p_perk_name;
2342:
2343: l_perk_name pay_element_types_f.element_information1%TYPE;

Line 3539: SELECT fnd_number.canonical_to_number(glb.global_value)

3535:
3536: CURSOR csr_global_value(p_global_name IN VARCHAR2
3537: ,p_date IN DATE)
3538: IS
3539: SELECT fnd_number.canonical_to_number(glb.global_value)
3540: FROM ff_globals_f glb
3541: WHERE glb.global_name = p_global_name
3542: AND p_date BETWEEN glb.effective_start_date
3543: AND glb.effective_end_date

Line 3654: l_tax_slab := fnd_number.canonical_to_number(pay_in_utils.get_user_table_value

3650: THEN
3651: pay_in_utils.trace('l_table_name',l_table_name);
3652: END IF;
3653:
3654: l_tax_slab := fnd_number.canonical_to_number(pay_in_utils.get_user_table_value
3655: (p_business_group_id => p_business_group_id
3656: ,p_table_name => l_table_name
3657: ,p_column_name => 'Tax Rate'
3658: ,p_row_name => 'Tax Slabs'

Line 3664: l_additional_amount := fnd_number.canonical_to_number(pay_in_utils.get_user_table_value

3660: ,p_effective_date => p_pay_date_paid
3661: ,p_message => p_message
3662: ));
3663:
3664: l_additional_amount := fnd_number.canonical_to_number(pay_in_utils.get_user_table_value
3665: (p_business_group_id => p_business_group_id
3666: ,p_table_name => l_table_name
3667: ,p_column_name => 'Additional Amount'
3668: ,p_row_name => 'Tax Slabs'

Line 3674: l_reduced_amount := fnd_number.canonical_to_number(pay_in_utils.get_user_table_value

3670: ,p_effective_date => p_pay_date_paid
3671: ,p_message => p_message
3672: ));
3673:
3674: l_reduced_amount := fnd_number.canonical_to_number(pay_in_utils.get_user_table_value
3675: (p_business_group_id => p_business_group_id
3676: ,p_table_name => l_table_name
3677: ,p_column_name => 'Reduced Amount'
3678: ,p_row_name => 'Tax Slabs'

Line 3821: l_tax_slab_wo_pan := fnd_number.canonical_to_number(pay_in_utils.get_user_table_value

3817: IF (g_debug) THEN
3818: pay_in_utils.trace('l_table_name',l_table_name);
3819: END IF;
3820:
3821: l_tax_slab_wo_pan := fnd_number.canonical_to_number(pay_in_utils.get_user_table_value
3822: (p_business_group_id => p_business_group_id
3823: ,p_table_name => l_table_name
3824: ,p_column_name => 'Tax Rate'
3825: ,p_row_name => 'Tax Slabs'

Line 3831: l_additional_amount_wo_pan := fnd_number.canonical_to_number(pay_in_utils.get_user_table_value

3827: ,p_effective_date => p_pay_date_paid
3828: ,p_message => p_message
3829: ));
3830:
3831: l_additional_amount_wo_pan := fnd_number.canonical_to_number(pay_in_utils.get_user_table_value
3832: (p_business_group_id => p_business_group_id
3833: ,p_table_name => l_table_name
3834: ,p_column_name => 'Additional Amount'
3835: ,p_row_name => 'Tax Slabs'

Line 3841: l_reduced_amount_wo_pan := fnd_number.canonical_to_number(pay_in_utils.get_user_table_value

3837: ,p_effective_date => p_pay_date_paid
3838: ,p_message => p_message
3839: ));
3840:
3841: l_reduced_amount_wo_pan := fnd_number.canonical_to_number(pay_in_utils.get_user_table_value
3842: (p_business_group_id => p_business_group_id
3843: ,p_table_name => l_table_name
3844: ,p_column_name => 'Reduced Amount'
3845: ,p_row_name => 'Tax Slabs'

Line 3941: SELECT fnd_number.canonical_to_number(glb.global_value)

3937:
3938: CURSOR csr_global_value(p_global_name IN VARCHAR2
3939: ,p_date IN DATE)
3940: IS
3941: SELECT fnd_number.canonical_to_number(glb.global_value)
3942: FROM ff_globals_f glb
3943: WHERE glb.global_name = p_global_name
3944: AND p_date BETWEEN glb.effective_start_date
3945: AND glb.effective_end_date

Line 4056: l_tax_slab := fnd_number.canonical_to_number(pay_in_utils.get_user_table_value

4052: THEN
4053: pay_in_utils.trace('l_table_name',l_table_name);
4054: END IF;
4055:
4056: l_tax_slab := fnd_number.canonical_to_number(pay_in_utils.get_user_table_value
4057: (p_business_group_id => p_business_group_id
4058: ,p_table_name => l_table_name
4059: ,p_column_name => 'Tax Rate'
4060: ,p_row_name => 'Tax Slabs'

Line 4066: l_additional_amount := fnd_number.canonical_to_number(pay_in_utils.get_user_table_value

4062: ,p_effective_date => p_pay_date_paid
4063: ,p_message => p_message
4064: ));
4065:
4066: l_additional_amount := fnd_number.canonical_to_number(pay_in_utils.get_user_table_value
4067: (p_business_group_id => p_business_group_id
4068: ,p_table_name => l_table_name
4069: ,p_column_name => 'Additional Amount'
4070: ,p_row_name => 'Tax Slabs'

Line 4076: l_reduced_amount := fnd_number.canonical_to_number(pay_in_utils.get_user_table_value

4072: ,p_effective_date => p_pay_date_paid
4073: ,p_message => p_message
4074: ));
4075:
4076: l_reduced_amount := fnd_number.canonical_to_number(pay_in_utils.get_user_table_value
4077: (p_business_group_id => p_business_group_id
4078: ,p_table_name => l_table_name
4079: ,p_column_name => 'Reduced Amount'
4080: ,p_row_name => 'Tax Slabs'

Line 4232: l_tax_slab_wo_pan := fnd_number.canonical_to_number(pay_in_utils.get_user_table_value

4228: IF (g_debug) THEN
4229: pay_in_utils.trace('l_table_name',l_table_name);
4230: END IF;
4231:
4232: l_tax_slab_wo_pan := fnd_number.canonical_to_number(pay_in_utils.get_user_table_value
4233: (p_business_group_id => p_business_group_id
4234: ,p_table_name => l_table_name
4235: ,p_column_name => 'Tax Rate'
4236: ,p_row_name => 'Tax Slabs'

Line 4242: l_additional_amount_wo_pan := fnd_number.canonical_to_number(pay_in_utils.get_user_table_value

4238: ,p_effective_date => p_pay_date_paid
4239: ,p_message => p_message
4240: ));
4241:
4242: l_additional_amount_wo_pan := fnd_number.canonical_to_number(pay_in_utils.get_user_table_value
4243: (p_business_group_id => p_business_group_id
4244: ,p_table_name => l_table_name
4245: ,p_column_name => 'Additional Amount'
4246: ,p_row_name => 'Tax Slabs'

Line 4252: l_reduced_amount_wo_pan := fnd_number.canonical_to_number(pay_in_utils.get_user_table_value

4248: ,p_effective_date => p_pay_date_paid
4249: ,p_message => p_message
4250: ));
4251:
4252: l_reduced_amount_wo_pan := fnd_number.canonical_to_number(pay_in_utils.get_user_table_value
4253: (p_business_group_id => p_business_group_id
4254: ,p_table_name => l_table_name
4255: ,p_column_name => 'Reduced Amount'
4256: ,p_row_name => 'Tax Slabs'

Line 4950: SELECT fnd_number.canonical_to_number(glb.global_value)

4946:
4947: CURSOR csr_global_value(p_global_name IN VARCHAR2
4948: ,p_date IN DATE)
4949: IS
4950: SELECT fnd_number.canonical_to_number(glb.global_value)
4951: FROM ff_globals_f glb
4952: WHERE glb.global_name = p_global_name
4953: AND p_date BETWEEN glb.effective_start_date
4954: AND glb.effective_end_date