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.

[Home] [Help]

APPS.PAY_AU_TERMINATIONS dependencies on FND_NUMBER

Line 64: ** fnd_number.canonical_to_number

60: ** 31-May-2007 priupadh 115.39 Bug# 6071863 Corrected version numbers in change history .
61: ** 04-Jun-2007 priupadh 115.40 Bug# 6071863 Modified query csr_get_prev_age in function get_prev_age .
62: ** 23-Aug-2007 priupadh 115.41 Bug# 6192381 Added function au_check_trans
63: ** 17-Sep-2007 avenkatk 115.42 Bug# 6430072 Function calculate_etp_tax - Added condition to convert User Tables value using
64: ** fnd_number.canonical_to_number
65: */
66: g_debug constant boolean := hr_utility.debug_enabled;
67: g_package constant varchar2(60) := 'pay_au_terminations.';
68: --

Line 1805: Bug 6430072 - Added condition to convert User Table values to number using fnd_number.canonical_to_number

1801: and then the difference with the lower range, This Difference is then multiplied by the Tax Percentage + Medicare Levy
1802:
1803: The Summation of all these values is the Net ETP Tax
1804:
1805: Bug 6430072 - Added condition to convert User Table values to number using fnd_number.canonical_to_number
1806: and not to_number.
1807: */
1808:
1809: CURSOR csr_get_etp_tax(p_bus_grp_id IN hr_all_organization_units.organization_id%TYPE

Line 1814: SELECT NVL(SUM(round((least(fnd_number.canonical_to_number(purf.row_high_range),p_amount)-fnd_number.canonical_to_number(purf.row_low_range_or_name))

1810: ,p_date_paid IN DATE
1811: ,p_user_table IN VARCHAR2
1812: ,p_amount IN NUMBER
1813: ,p_med_levy IN NUMBER) IS
1814: SELECT NVL(SUM(round((least(fnd_number.canonical_to_number(purf.row_high_range),p_amount)-fnd_number.canonical_to_number(purf.row_low_range_or_name))
1815: *(fnd_number.canonical_to_number(pucif.value) + decode(fnd_number.canonical_to_number(pucif.value),0,0,p_med_levy)))),0)
1816: FROM pay_user_tables put,
1817: pay_user_rows_F purf,
1818: pay_user_columns puc,

Line 1815: *(fnd_number.canonical_to_number(pucif.value) + decode(fnd_number.canonical_to_number(pucif.value),0,0,p_med_levy)))),0)

1811: ,p_user_table IN VARCHAR2
1812: ,p_amount IN NUMBER
1813: ,p_med_levy IN NUMBER) IS
1814: SELECT NVL(SUM(round((least(fnd_number.canonical_to_number(purf.row_high_range),p_amount)-fnd_number.canonical_to_number(purf.row_low_range_or_name))
1815: *(fnd_number.canonical_to_number(pucif.value) + decode(fnd_number.canonical_to_number(pucif.value),0,0,p_med_levy)))),0)
1816: FROM pay_user_tables put,
1817: pay_user_rows_F purf,
1818: pay_user_columns puc,
1819: pay_user_column_instances_f pucif

Line 1828: and p_amount > fnd_number.canonical_to_number(purf.row_low_range_or_name) /* 6430072 */

1824: and puc.user_column_id=pucif.user_column_id
1825: and purf.user_row_id=pucif.user_row_id
1826: and p_date_paid between purf.effective_start_date and purf.effective_end_date
1827: and p_date_paid between pucif.effective_start_date and pucif.effective_end_date
1828: and p_amount > fnd_number.canonical_to_number(purf.row_low_range_or_name) /* 6430072 */
1829: order by fnd_number.canonical_to_number(purf.row_low_range_or_name);
1830:
1831: l_procedure VARCHAR2(80);
1832: lv_user_table VARCHAR2(50);

Line 1829: order by fnd_number.canonical_to_number(purf.row_low_range_or_name);

1825: and purf.user_row_id=pucif.user_row_id
1826: and p_date_paid between purf.effective_start_date and purf.effective_end_date
1827: and p_date_paid between pucif.effective_start_date and pucif.effective_end_date
1828: and p_amount > fnd_number.canonical_to_number(purf.row_low_range_or_name) /* 6430072 */
1829: order by fnd_number.canonical_to_number(purf.row_low_range_or_name);
1830:
1831: l_procedure VARCHAR2(80);
1832: lv_user_table VARCHAR2(50);
1833: lv_etp_tax NUMBER :=0;