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 1206: fnd_number.canonical_to_number(nvl(ppm.pem_information2,0)), -- Annual Salary

1202: Return Number is
1203: /*Bug:3919215 Modified the cursor. selected Employer classification of prev emplr */
1204: Cursor c_prev_emp_details is
1205: select nvl(ppm.pem_information1,'X'), -- Designation
1206: fnd_number.canonical_to_number(nvl(ppm.pem_information2,0)), -- Annual Salary
1207: nvl(ppm.pem_information3,'X'), -- PF Number
1208: nvl(ppm.pem_information4,'X'), -- PF Establishment Code
1209: nvl(ppm.pem_information5,'X'), -- EPF Number
1210: nvl(ppm.pem_information6,'X'), -- Emplr class

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

1207: nvl(ppm.pem_information3,'X'), -- PF Number
1208: nvl(ppm.pem_information4,'X'), -- PF Establishment Code
1209: nvl(ppm.pem_information5,'X'), -- EPF Number
1210: nvl(ppm.pem_information6,'X'), -- Emplr class
1211: fnd_number.canonical_to_number(nvl(ppm.pem_information8,0)), -- LTC Curr
1212: fnd_number.canonical_to_number(nvl(ppm.pem_information9,0)), -- Leave Encashment
1213: fnd_number.canonical_to_number(nvl(ppm.pem_information10,0)), -- Gratuity
1214: fnd_number.canonical_to_number(nvl(ppm.pem_information11,0)), -- Retrenchment Amount
1215: fnd_number.canonical_to_number(nvl(ppm.pem_information12,0)), -- VRS

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

1208: nvl(ppm.pem_information4,'X'), -- PF Establishment Code
1209: nvl(ppm.pem_information5,'X'), -- EPF Number
1210: nvl(ppm.pem_information6,'X'), -- Emplr class
1211: fnd_number.canonical_to_number(nvl(ppm.pem_information8,0)), -- LTC Curr
1212: fnd_number.canonical_to_number(nvl(ppm.pem_information9,0)), -- Leave Encashment
1213: fnd_number.canonical_to_number(nvl(ppm.pem_information10,0)), -- Gratuity
1214: fnd_number.canonical_to_number(nvl(ppm.pem_information11,0)), -- Retrenchment Amount
1215: fnd_number.canonical_to_number(nvl(ppm.pem_information12,0)), -- VRS
1216: fnd_number.canonical_to_number(nvl(ppm.pem_information13,0)), -- Gross Sal

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

1209: nvl(ppm.pem_information5,'X'), -- EPF Number
1210: nvl(ppm.pem_information6,'X'), -- Emplr class
1211: fnd_number.canonical_to_number(nvl(ppm.pem_information8,0)), -- LTC Curr
1212: fnd_number.canonical_to_number(nvl(ppm.pem_information9,0)), -- Leave Encashment
1213: fnd_number.canonical_to_number(nvl(ppm.pem_information10,0)), -- Gratuity
1214: fnd_number.canonical_to_number(nvl(ppm.pem_information11,0)), -- Retrenchment Amount
1215: fnd_number.canonical_to_number(nvl(ppm.pem_information12,0)), -- VRS
1216: fnd_number.canonical_to_number(nvl(ppm.pem_information13,0)), -- Gross Sal
1217: fnd_number.canonical_to_number(nvl(ppm.pem_information14,0)), -- PF

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

1210: nvl(ppm.pem_information6,'X'), -- Emplr class
1211: fnd_number.canonical_to_number(nvl(ppm.pem_information8,0)), -- LTC Curr
1212: fnd_number.canonical_to_number(nvl(ppm.pem_information9,0)), -- Leave Encashment
1213: fnd_number.canonical_to_number(nvl(ppm.pem_information10,0)), -- Gratuity
1214: fnd_number.canonical_to_number(nvl(ppm.pem_information11,0)), -- Retrenchment Amount
1215: fnd_number.canonical_to_number(nvl(ppm.pem_information12,0)), -- VRS
1216: fnd_number.canonical_to_number(nvl(ppm.pem_information13,0)), -- Gross Sal
1217: fnd_number.canonical_to_number(nvl(ppm.pem_information14,0)), -- PF
1218: fnd_number.canonical_to_number(nvl(ppm.pem_information15,0)), -- Ent Alw

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

1211: fnd_number.canonical_to_number(nvl(ppm.pem_information8,0)), -- LTC Curr
1212: fnd_number.canonical_to_number(nvl(ppm.pem_information9,0)), -- Leave Encashment
1213: fnd_number.canonical_to_number(nvl(ppm.pem_information10,0)), -- Gratuity
1214: fnd_number.canonical_to_number(nvl(ppm.pem_information11,0)), -- Retrenchment Amount
1215: fnd_number.canonical_to_number(nvl(ppm.pem_information12,0)), -- VRS
1216: fnd_number.canonical_to_number(nvl(ppm.pem_information13,0)), -- Gross Sal
1217: fnd_number.canonical_to_number(nvl(ppm.pem_information14,0)), -- PF
1218: fnd_number.canonical_to_number(nvl(ppm.pem_information15,0)), -- Ent Alw
1219: fnd_number.canonical_to_number(nvl(ppm.pem_information16,0)), -- PT

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

1212: fnd_number.canonical_to_number(nvl(ppm.pem_information9,0)), -- Leave Encashment
1213: fnd_number.canonical_to_number(nvl(ppm.pem_information10,0)), -- Gratuity
1214: fnd_number.canonical_to_number(nvl(ppm.pem_information11,0)), -- Retrenchment Amount
1215: fnd_number.canonical_to_number(nvl(ppm.pem_information12,0)), -- VRS
1216: fnd_number.canonical_to_number(nvl(ppm.pem_information13,0)), -- Gross Sal
1217: fnd_number.canonical_to_number(nvl(ppm.pem_information14,0)), -- PF
1218: fnd_number.canonical_to_number(nvl(ppm.pem_information15,0)), -- Ent Alw
1219: fnd_number.canonical_to_number(nvl(ppm.pem_information16,0)), -- PT
1220: fnd_number.canonical_to_number(nvl(ppm.pem_information17,0)), -- TDS

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

1213: fnd_number.canonical_to_number(nvl(ppm.pem_information10,0)), -- Gratuity
1214: fnd_number.canonical_to_number(nvl(ppm.pem_information11,0)), -- Retrenchment Amount
1215: fnd_number.canonical_to_number(nvl(ppm.pem_information12,0)), -- VRS
1216: fnd_number.canonical_to_number(nvl(ppm.pem_information13,0)), -- Gross Sal
1217: fnd_number.canonical_to_number(nvl(ppm.pem_information14,0)), -- PF
1218: fnd_number.canonical_to_number(nvl(ppm.pem_information15,0)), -- Ent Alw
1219: fnd_number.canonical_to_number(nvl(ppm.pem_information16,0)), -- PT
1220: fnd_number.canonical_to_number(nvl(ppm.pem_information17,0)), -- TDS
1221: fnd_number.canonical_to_number(nvl(ppm.pem_information18,0)), -- Superannuation

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

1214: fnd_number.canonical_to_number(nvl(ppm.pem_information11,0)), -- Retrenchment Amount
1215: fnd_number.canonical_to_number(nvl(ppm.pem_information12,0)), -- VRS
1216: fnd_number.canonical_to_number(nvl(ppm.pem_information13,0)), -- Gross Sal
1217: fnd_number.canonical_to_number(nvl(ppm.pem_information14,0)), -- PF
1218: fnd_number.canonical_to_number(nvl(ppm.pem_information15,0)), -- Ent Alw
1219: fnd_number.canonical_to_number(nvl(ppm.pem_information16,0)), -- PT
1220: fnd_number.canonical_to_number(nvl(ppm.pem_information17,0)), -- TDS
1221: fnd_number.canonical_to_number(nvl(ppm.pem_information18,0)), -- Superannuation
1222: fnd_number.canonical_to_number(nvl(ppm.pem_information19,0)), -- Prev Surcharge

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

1215: fnd_number.canonical_to_number(nvl(ppm.pem_information12,0)), -- VRS
1216: fnd_number.canonical_to_number(nvl(ppm.pem_information13,0)), -- Gross Sal
1217: fnd_number.canonical_to_number(nvl(ppm.pem_information14,0)), -- PF
1218: fnd_number.canonical_to_number(nvl(ppm.pem_information15,0)), -- Ent Alw
1219: fnd_number.canonical_to_number(nvl(ppm.pem_information16,0)), -- PT
1220: fnd_number.canonical_to_number(nvl(ppm.pem_information17,0)), -- TDS
1221: fnd_number.canonical_to_number(nvl(ppm.pem_information18,0)), -- Superannuation
1222: fnd_number.canonical_to_number(nvl(ppm.pem_information19,0)), -- Prev Surcharge
1223: fnd_number.canonical_to_number(nvl(ppm.pem_information20,0)), -- Prev Cess

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

1216: fnd_number.canonical_to_number(nvl(ppm.pem_information13,0)), -- Gross Sal
1217: fnd_number.canonical_to_number(nvl(ppm.pem_information14,0)), -- PF
1218: fnd_number.canonical_to_number(nvl(ppm.pem_information15,0)), -- Ent Alw
1219: fnd_number.canonical_to_number(nvl(ppm.pem_information16,0)), -- PT
1220: fnd_number.canonical_to_number(nvl(ppm.pem_information17,0)), -- TDS
1221: fnd_number.canonical_to_number(nvl(ppm.pem_information18,0)), -- Superannuation
1222: fnd_number.canonical_to_number(nvl(ppm.pem_information19,0)), -- Prev Surcharge
1223: fnd_number.canonical_to_number(nvl(ppm.pem_information20,0)), -- Prev Cess
1224: fnd_number.canonical_to_number(nvl(ppm.pem_information21,0)), -- Exemption under 80gg

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

1217: fnd_number.canonical_to_number(nvl(ppm.pem_information14,0)), -- PF
1218: fnd_number.canonical_to_number(nvl(ppm.pem_information15,0)), -- Ent Alw
1219: fnd_number.canonical_to_number(nvl(ppm.pem_information16,0)), -- PT
1220: fnd_number.canonical_to_number(nvl(ppm.pem_information17,0)), -- TDS
1221: fnd_number.canonical_to_number(nvl(ppm.pem_information18,0)), -- Superannuation
1222: fnd_number.canonical_to_number(nvl(ppm.pem_information19,0)), -- Prev Surcharge
1223: fnd_number.canonical_to_number(nvl(ppm.pem_information20,0)), -- Prev Cess
1224: fnd_number.canonical_to_number(nvl(ppm.pem_information21,0)), -- Exemption under 80gg
1225: fnd_number.canonical_to_number(nvl(ppm.pem_information22,0)), -- Medical Reimbursement

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

1218: fnd_number.canonical_to_number(nvl(ppm.pem_information15,0)), -- Ent Alw
1219: fnd_number.canonical_to_number(nvl(ppm.pem_information16,0)), -- PT
1220: fnd_number.canonical_to_number(nvl(ppm.pem_information17,0)), -- TDS
1221: fnd_number.canonical_to_number(nvl(ppm.pem_information18,0)), -- Superannuation
1222: fnd_number.canonical_to_number(nvl(ppm.pem_information19,0)), -- Prev Surcharge
1223: fnd_number.canonical_to_number(nvl(ppm.pem_information20,0)), -- Prev Cess
1224: fnd_number.canonical_to_number(nvl(ppm.pem_information21,0)), -- Exemption under 80gg
1225: fnd_number.canonical_to_number(nvl(ppm.pem_information22,0)), -- Medical Reimbursement
1226: fnd_number.canonical_to_number(nvl(ppm.pem_information23,0)), -- Sec and HE Cess

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

1219: fnd_number.canonical_to_number(nvl(ppm.pem_information16,0)), -- PT
1220: fnd_number.canonical_to_number(nvl(ppm.pem_information17,0)), -- TDS
1221: fnd_number.canonical_to_number(nvl(ppm.pem_information18,0)), -- Superannuation
1222: fnd_number.canonical_to_number(nvl(ppm.pem_information19,0)), -- Prev Surcharge
1223: fnd_number.canonical_to_number(nvl(ppm.pem_information20,0)), -- Prev Cess
1224: fnd_number.canonical_to_number(nvl(ppm.pem_information21,0)), -- Exemption under 80gg
1225: fnd_number.canonical_to_number(nvl(ppm.pem_information22,0)), -- Medical Reimbursement
1226: fnd_number.canonical_to_number(nvl(ppm.pem_information23,0)), -- Sec and HE Cess
1227: fnd_number.canonical_to_number(nvl(ppm.pem_information24,0)), -- Exemption under 80ccd

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

1220: fnd_number.canonical_to_number(nvl(ppm.pem_information17,0)), -- TDS
1221: fnd_number.canonical_to_number(nvl(ppm.pem_information18,0)), -- Superannuation
1222: fnd_number.canonical_to_number(nvl(ppm.pem_information19,0)), -- Prev Surcharge
1223: fnd_number.canonical_to_number(nvl(ppm.pem_information20,0)), -- Prev Cess
1224: fnd_number.canonical_to_number(nvl(ppm.pem_information21,0)), -- Exemption under 80gg
1225: fnd_number.canonical_to_number(nvl(ppm.pem_information22,0)), -- Medical Reimbursement
1226: fnd_number.canonical_to_number(nvl(ppm.pem_information23,0)), -- Sec and HE Cess
1227: fnd_number.canonical_to_number(nvl(ppm.pem_information24,0)), -- Exemption under 80ccd
1228: ppm.end_date

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

1221: fnd_number.canonical_to_number(nvl(ppm.pem_information18,0)), -- Superannuation
1222: fnd_number.canonical_to_number(nvl(ppm.pem_information19,0)), -- Prev Surcharge
1223: fnd_number.canonical_to_number(nvl(ppm.pem_information20,0)), -- Prev Cess
1224: fnd_number.canonical_to_number(nvl(ppm.pem_information21,0)), -- Exemption under 80gg
1225: fnd_number.canonical_to_number(nvl(ppm.pem_information22,0)), -- Medical Reimbursement
1226: fnd_number.canonical_to_number(nvl(ppm.pem_information23,0)), -- Sec and HE Cess
1227: fnd_number.canonical_to_number(nvl(ppm.pem_information24,0)), -- Exemption under 80ccd
1228: ppm.end_date
1229: from per_previous_employers ppm,

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

1222: fnd_number.canonical_to_number(nvl(ppm.pem_information19,0)), -- Prev Surcharge
1223: fnd_number.canonical_to_number(nvl(ppm.pem_information20,0)), -- Prev Cess
1224: fnd_number.canonical_to_number(nvl(ppm.pem_information21,0)), -- Exemption under 80gg
1225: fnd_number.canonical_to_number(nvl(ppm.pem_information22,0)), -- Medical Reimbursement
1226: fnd_number.canonical_to_number(nvl(ppm.pem_information23,0)), -- Sec and HE Cess
1227: fnd_number.canonical_to_number(nvl(ppm.pem_information24,0)), -- Exemption under 80ccd
1228: ppm.end_date
1229: from per_previous_employers ppm,
1230: per_all_assignments_f paa

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

1223: fnd_number.canonical_to_number(nvl(ppm.pem_information20,0)), -- Prev Cess
1224: fnd_number.canonical_to_number(nvl(ppm.pem_information21,0)), -- Exemption under 80gg
1225: fnd_number.canonical_to_number(nvl(ppm.pem_information22,0)), -- Medical Reimbursement
1226: fnd_number.canonical_to_number(nvl(ppm.pem_information23,0)), -- Sec and HE Cess
1227: fnd_number.canonical_to_number(nvl(ppm.pem_information24,0)), -- Exemption under 80ccd
1228: ppm.end_date
1229: from per_previous_employers ppm,
1230: per_all_assignments_f paa
1231: where paa.assignment_id = p_assignment_id

Line 1658: Return fnd_number.canonical_to_number(l_rent_paid);

1654: Close c_act_rent_paid;
1655:
1656: pay_in_utils.set_location(g_debug,'Rent paid is' || l_rent_paid,20);
1657: pay_in_utils.trace('**************************************************','********************');
1658: Return fnd_number.canonical_to_number(l_rent_paid);
1659: Else
1660: pay_in_utils.trace('**************************************************','********************');
1661: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);
1662: Return 0;

Line 1928: SELECT fnd_number.canonical_to_number(exemption_amount)

1924: WHERE element_type_id = p_element_type_id
1925: AND p_date_earned BETWEEN effective_start_date AND effective_end_date;
1926:
1927: CURSOR c_exemption (p_perk_name IN VARCHAR2) IS
1928: SELECT fnd_number.canonical_to_number(exemption_amount)
1929: FROM pay_in_other_perquisites_v
1930: WHERE perquisite_name = p_perk_name;
1931:
1932: l_perk_name pay_element_types_f.element_information1%TYPE;

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

3083:
3084: CURSOR csr_global_value(p_global_name IN VARCHAR2
3085: ,p_date IN DATE)
3086: IS
3087: SELECT fnd_number.canonical_to_number(glb.global_value)
3088: FROM ff_globals_f glb
3089: WHERE glb.global_name = p_global_name
3090: AND p_date BETWEEN glb.effective_start_date
3091: AND glb.effective_end_date

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

3122: THEN
3123: pay_in_utils.trace('l_table_name',l_table_name);
3124: END IF;
3125:
3126: l_tax_slab := fnd_number.canonical_to_number(pay_in_utils.get_user_table_value
3127: (p_business_group_id => p_business_group_id
3128: ,p_table_name => l_table_name
3129: ,p_column_name => 'Tax Rate'
3130: ,p_row_name => 'Tax Slabs'

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

3132: ,p_effective_date => p_pay_end_date
3133: ,p_message => p_message
3134: ));
3135:
3136: l_additional_amount := fnd_number.canonical_to_number(pay_in_utils.get_user_table_value
3137: (p_business_group_id => p_business_group_id
3138: ,p_table_name => l_table_name
3139: ,p_column_name => 'Additional Amount'
3140: ,p_row_name => 'Tax Slabs'

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

3142: ,p_effective_date => p_pay_end_date
3143: ,p_message => p_message
3144: ));
3145:
3146: l_reduced_amount := fnd_number.canonical_to_number(pay_in_utils.get_user_table_value
3147: (p_business_group_id => p_business_group_id
3148: ,p_table_name => l_table_name
3149: ,p_column_name => 'Reduced Amount'
3150: ,p_row_name => 'Tax Slabs'

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

3887:
3888: CURSOR csr_global_value(p_global_name IN VARCHAR2
3889: ,p_date IN DATE)
3890: IS
3891: SELECT fnd_number.canonical_to_number(glb.global_value)
3892: FROM ff_globals_f glb
3893: WHERE glb.global_name = p_global_name
3894: AND p_date BETWEEN glb.effective_start_date
3895: AND glb.effective_end_date