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_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: ** 26-May-2009 dduvvuri 115.43 Bug# 8482224 Cursor csr_get_accrual_plan_id modified in Function get_accrual_plan_by_category
66: ** 20-Jul-2009 skshin 115.45 Bug# 8647962 Added Index(PURF) and ORDERED hint to get correct execution path
67: ** 30-Jul-2009 skshin 115.46 Bug# 8725341 Added Earnings_Leave_Loading balance to be retrieved effective from 01-JUL-2009 in calculate_term_asg_nge function
68: ** 07-Sep-2009 pmatamsr 115.47 Bug# 8769345 Added new input parameter to check_rollover function.

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

1913: and then the difference with the lower range, This Difference is then multiplied by the Tax Percentage + Medicare Levy
1914:
1915: The Summation of all these values is the Net ETP Tax
1916:
1917: Bug 6430072 - Added condition to convert User Table values to number using fnd_number.canonical_to_number
1918: and not to_number.
1919: */
1920:
1921: CURSOR csr_get_etp_tax(p_bus_grp_id IN hr_all_organization_units.organization_id%TYPE

Line 1926: SELECT /+ INDEX(PURF) ORDERED / 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))

1922: ,p_date_paid IN DATE
1923: ,p_user_table IN VARCHAR2
1924: ,p_amount IN NUMBER
1925: ,p_med_levy IN NUMBER) IS
1926: SELECT /*+ INDEX(PURF) ORDERED */ 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))
1927: *(fnd_number.canonical_to_number(pucif.value) + decode(fnd_number.canonical_to_number(pucif.value),0,0,p_med_levy)))),0) -- bug8647962
1928: FROM pay_user_tables put,
1929: pay_user_rows_F purf,
1930: pay_user_columns puc,

Line 1927: *(fnd_number.canonical_to_number(pucif.value) + decode(fnd_number.canonical_to_number(pucif.value),0,0,p_med_levy)))),0) -- bug8647962

1923: ,p_user_table IN VARCHAR2
1924: ,p_amount IN NUMBER
1925: ,p_med_levy IN NUMBER) IS
1926: SELECT /*+ INDEX(PURF) ORDERED */ 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))
1927: *(fnd_number.canonical_to_number(pucif.value) + decode(fnd_number.canonical_to_number(pucif.value),0,0,p_med_levy)))),0) -- bug8647962
1928: FROM pay_user_tables put,
1929: pay_user_rows_F purf,
1930: pay_user_columns puc,
1931: pay_user_column_instances_f pucif

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

1936: and puc.user_column_id=pucif.user_column_id
1937: and purf.user_row_id=pucif.user_row_id
1938: and p_date_paid between purf.effective_start_date and purf.effective_end_date
1939: and p_date_paid between pucif.effective_start_date and pucif.effective_end_date
1940: and p_amount > fnd_number.canonical_to_number(purf.row_low_range_or_name) /* 6430072 */
1941: order by fnd_number.canonical_to_number(purf.row_low_range_or_name);
1942:
1943: l_procedure VARCHAR2(80);
1944: lv_user_table VARCHAR2(50);

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

1937: and purf.user_row_id=pucif.user_row_id
1938: and p_date_paid between purf.effective_start_date and purf.effective_end_date
1939: and p_date_paid between pucif.effective_start_date and pucif.effective_end_date
1940: and p_amount > fnd_number.canonical_to_number(purf.row_low_range_or_name) /* 6430072 */
1941: order by fnd_number.canonical_to_number(purf.row_low_range_or_name);
1942:
1943: l_procedure VARCHAR2(80);
1944: lv_user_table VARCHAR2(50);
1945: lv_etp_tax NUMBER :=0;

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

2552: and then the difference with the lower range, This Difference is then multiplied by the Tax Percentage + Medicare Levy
2553:
2554: The Summation of all these values is the Net ETP Tax
2555:
2556: Bug 6430072 - Added condition to convert User Table values to number using fnd_number.canonical_to_number
2557: and not to_number.
2558: */
2559:
2560: CURSOR csr_get_etp_tax(p_bus_grp_id IN hr_all_organization_units.organization_id%TYPE

Line 2565: SELECT /+ INDEX(PURF) ORDERED / 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))

2561: ,p_date_paid IN DATE
2562: ,p_user_table IN VARCHAR2
2563: ,p_amount IN NUMBER
2564: ,p_med_levy IN NUMBER) IS
2565: SELECT /*+ INDEX(PURF) ORDERED */ 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))
2566: *(fnd_number.canonical_to_number(pucif.value) + decode(fnd_number.canonical_to_number(pucif.value),0,0,p_med_levy)))),0) -- bug8647962
2567: FROM pay_user_tables put,
2568: pay_user_rows_F purf,
2569: pay_user_columns puc,

Line 2566: *(fnd_number.canonical_to_number(pucif.value) + decode(fnd_number.canonical_to_number(pucif.value),0,0,p_med_levy)))),0) -- bug8647962

2562: ,p_user_table IN VARCHAR2
2563: ,p_amount IN NUMBER
2564: ,p_med_levy IN NUMBER) IS
2565: SELECT /*+ INDEX(PURF) ORDERED */ 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))
2566: *(fnd_number.canonical_to_number(pucif.value) + decode(fnd_number.canonical_to_number(pucif.value),0,0,p_med_levy)))),0) -- bug8647962
2567: FROM pay_user_tables put,
2568: pay_user_rows_F purf,
2569: pay_user_columns puc,
2570: pay_user_column_instances_f pucif

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

2575: and puc.user_column_id=pucif.user_column_id
2576: and purf.user_row_id=pucif.user_row_id
2577: and p_date_paid between purf.effective_start_date and purf.effective_end_date
2578: and p_date_paid between pucif.effective_start_date and pucif.effective_end_date
2579: and p_amount > fnd_number.canonical_to_number(purf.row_low_range_or_name) /* 6430072 */
2580: order by fnd_number.canonical_to_number(purf.row_low_range_or_name);
2581:
2582:
2583: cursor csr_get_curr_atd is

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

2576: and purf.user_row_id=pucif.user_row_id
2577: and p_date_paid between purf.effective_start_date and purf.effective_end_date
2578: and p_date_paid between pucif.effective_start_date and pucif.effective_end_date
2579: and p_amount > fnd_number.canonical_to_number(purf.row_low_range_or_name) /* 6430072 */
2580: order by fnd_number.canonical_to_number(purf.row_low_range_or_name);
2581:
2582:
2583: cursor csr_get_curr_atd is
2584: select pps.actual_termination_date

Line 3694: SELECT /+ INDEX(PURF) ORDERED / 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))

3690: ,p_date_paid IN DATE
3691: ,p_user_table IN VARCHAR2
3692: ,p_amount IN NUMBER
3693: ,p_med_levy IN NUMBER) IS
3694: SELECT /*+ INDEX(PURF) ORDERED */ 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))
3695: *(fnd_number.canonical_to_number(pucif.value) + decode(fnd_number.canonical_to_number(pucif.value),0,0,p_med_levy)))),0)
3696: FROM pay_user_tables put,
3697: pay_user_rows_F purf,
3698: pay_user_columns puc,

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

3691: ,p_user_table IN VARCHAR2
3692: ,p_amount IN NUMBER
3693: ,p_med_levy IN NUMBER) IS
3694: SELECT /*+ INDEX(PURF) ORDERED */ 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))
3695: *(fnd_number.canonical_to_number(pucif.value) + decode(fnd_number.canonical_to_number(pucif.value),0,0,p_med_levy)))),0)
3696: FROM pay_user_tables put,
3697: pay_user_rows_F purf,
3698: pay_user_columns puc,
3699: pay_user_column_instances_f pucif

Line 3708: and p_amount > fnd_number.canonical_to_number(purf.row_low_range_or_name)

3704: and puc.user_column_id=pucif.user_column_id
3705: and purf.user_row_id=pucif.user_row_id
3706: and p_date_paid between purf.effective_start_date and purf.effective_end_date
3707: and p_date_paid between pucif.effective_start_date and pucif.effective_end_date
3708: and p_amount > fnd_number.canonical_to_number(purf.row_low_range_or_name)
3709: order by fnd_number.canonical_to_number(purf.row_low_range_or_name);
3710:
3711:
3712: cursor csr_get_curr_atd is

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

3705: and purf.user_row_id=pucif.user_row_id
3706: and p_date_paid between purf.effective_start_date and purf.effective_end_date
3707: and p_date_paid between pucif.effective_start_date and pucif.effective_end_date
3708: and p_amount > fnd_number.canonical_to_number(purf.row_low_range_or_name)
3709: order by fnd_number.canonical_to_number(purf.row_low_range_or_name);
3710:
3711:
3712: cursor csr_get_curr_atd is
3713: select pps.actual_termination_date