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

Line 107: Fnd_Number.Canonical_to_number

103: GET_PARTIAL_SUBJ_EARNINGS before
104: calculating taxes other than ISR
105: 21-Nov-2007 prechand 115.28 6606767 Changed the function to_number
106: in the function CALCULATE_ISR_TAX to
107: Fnd_Number.Canonical_to_number
108: 12-Dec-2007 nragavar 115.29 6487007 ISR 2008 changes
109: 29-Jan-2008 nragavar 115.33 6779706 Subsidy for Empl paid was getting added
110: where, not required.
111: 30-Jan-2008 nragavar 115.34 6782264 changes to get_table_value

Line 187: 06-Jun-2011 vvijayku 115.64 12553943 Added fnd_number.canonical_to_number in the cursor

183: removed hire_date reference and a new cursor
184: csr_get_hire_date has been added to fetch hire date.
185: 21-Jul-2010 vvijayku 115.63 9753792 Added new code in the function GET_RANGE_BASIS_VALUE and
186: GET_PARTIAL_SUBJ_EARNINGS for handling the PTU calculation.
187: 06-Jun-2011 vvijayku 115.64 12553943 Added fnd_number.canonical_to_number in the cursor
188: csr_get_table_value.
189: 23-Apr-2012 sjawid 115.65 13905014 Modified ISR tax and Subsidy for employement calculation
190: for Monthly and Periodic Tax adjustments.
191: 11-May-2012 jeisaac 115.67 13998818 Modified ISR Calculated for Monthly and Periodic Tax Adj.

Line 323: SELECT fnd_number.canonical_to_number(plif.legislation_info2)

319: AND paf.effective_start_date <= g_ptu_end_date
320: AND paf.effective_end_date >= g_ptu_start_date;
321:
322: CURSOR csr_get_min_wage (p_gre_id NUMBER, p_effective_date DATE) IS
323: SELECT fnd_number.canonical_to_number(plif.legislation_info2)
324: FROM pay_mx_legislation_info_f plif,
325: hr_organization_units hou,
326: hr_organization_information hoi
327: WHERE hou.organization_id = hoi.organization_id

Line 2154: ln_fixed_rate := FND_NUMBER.canonical_to_number(hruserdt.get_table_value (

2150:
2151: hr_utility_trace('Final Subject amount after proration: '||ln_ISR_proj_subject);
2152: /* Article 113, 114 and 115 */
2153:
2154: ln_fixed_rate := FND_NUMBER.canonical_to_number(hruserdt.get_table_value (
2155: p_business_group_id
2156: ,p_isr_rates_table
2157: ,'Fixed Rate'
2158: ,TO_CHAR(ln_ISR_proj_subject)));

Line 2162: ln_marginal_rate := FND_NUMBER.canonical_to_number(hruserdt.get_table_value (

2158: ,TO_CHAR(ln_ISR_proj_subject)));
2159:
2160: hr_utility_trace('ln_fixed_rate: '||ln_fixed_rate);
2161:
2162: ln_marginal_rate := FND_NUMBER.canonical_to_number(hruserdt.get_table_value (
2163: p_business_group_id
2164: ,p_isr_rates_table
2165: ,'Marginal Rate'
2166: ,TO_CHAR(ln_ISR_proj_subject)));

Line 2170: ln_lower_limit := FND_NUMBER.canonical_to_number(hruserdt.get_table_value (

2166: ,TO_CHAR(ln_ISR_proj_subject)));
2167:
2168: hr_utility_trace('ln_marginal_rate: '||ln_marginal_rate);
2169:
2170: ln_lower_limit := FND_NUMBER.canonical_to_number(hruserdt.get_table_value (
2171: p_business_group_id
2172: ,p_isr_rates_table
2173: ,'Lower Bound'
2174: ,TO_CHAR(ln_ISR_proj_subject)));

Line 2191: ln_fixed_subsidy := FND_NUMBER.canonical_to_number(hruserdt.get_table_value (

2187: IF TO_CHAR(l_date_paid,'yyyymmdd')
2188: < TO_CHAR(fnd_date.canonical_to_date('2008/01/01'),'yyyymmdd') THEN
2189:
2190: /* Subsidy Calculation */
2191: ln_fixed_subsidy := FND_NUMBER.canonical_to_number(hruserdt.get_table_value (
2192: p_business_group_id
2193: ,p_subsidy_table
2194: ,'Fixed Rate'
2195: ,TO_CHAR(ln_ISR_proj_subject)));

Line 2199: ln_marginal_subsidy := FND_NUMBER.canonical_to_number(hruserdt.get_table_value (

2195: ,TO_CHAR(ln_ISR_proj_subject)));
2196:
2197: hr_utility_trace('ln_fixed_subsidy: '||ln_fixed_subsidy);
2198:
2199: ln_marginal_subsidy := FND_NUMBER.canonical_to_number(hruserdt.get_table_value (
2200: p_business_group_id
2201: ,p_subsidy_table
2202: ,'Marginal Rate'
2203: ,TO_CHAR(ln_ISR_proj_subject)));

Line 2207: ln_subsidy_lower_limit := FND_NUMBER.canonical_to_number(hruserdt.get_table_value (

2203: ,TO_CHAR(ln_ISR_proj_subject)));
2204:
2205: hr_utility_trace('ln_marginal_subsidy: '||ln_marginal_subsidy);
2206:
2207: ln_subsidy_lower_limit := FND_NUMBER.canonical_to_number(hruserdt.get_table_value (
2208: p_business_group_id
2209: ,p_subsidy_table
2210: ,'Lower Bound'
2211: ,TO_CHAR(ln_ISR_proj_subject)));

Line 2273: p_credit_to_salary := FND_NUMBER.canonical_to_number(hruserdt.get_table_value (

2269: /*bug7445486 bug#8438155*/
2270: IF ( p_credit_to_salary_table <> 'NONE' and P_CALC_MODE <>'ARTICLE142' AND l_compute_subsidy_flag <> 'N') THEN
2271:
2272: hr_utility_trace('inside subsidy '||p_credit_to_salary_table|| ' --- '||TO_CHAR(ln_ISR_proj_subject));
2273: p_credit_to_salary := FND_NUMBER.canonical_to_number(hruserdt.get_table_value (
2274: p_business_group_id
2275: ,p_credit_to_salary_table
2276: ,'Amount'
2277: ,TO_CHAR(ln_ISR_proj_subject)));

Line 2451: p_credit_to_salary := FND_NUMBER.canonical_to_number(get_table_value (

2447: ln_days_in_period_sub_empl := 10;
2448: ELSE
2449: ln_days_in_period_sub_empl := ln_days_in_a_period; /*bug 7677805*/
2450: END IF ;
2451: p_credit_to_salary := FND_NUMBER.canonical_to_number(get_table_value (
2452: p_business_group_id
2453: ,p_credit_to_salary_table
2454: ,'Amount'
2455: ,TO_CHAR(ln_ISR_subj_adj)

Line 2816: SELECT fnd_number.canonical_to_number(CINST.value)* fnd_number.canonical_to_number(p_proration_fac)

2812: p_business_group_id) = p_business_group_id
2813: AND nvl(legislation_code, 'MX') = 'MX';
2814:
2815: CURSOR csr_get_table_value(p_table_id NUMBER, p_proration_fac NUMBER, p_col_name VARCHAR2, p_row_value NUMBER) IS
2816: SELECT fnd_number.canonical_to_number(CINST.value)* fnd_number.canonical_to_number(p_proration_fac)
2817: FROM pay_user_tables TAB
2818: , pay_user_columns C
2819: , pay_user_rows_f R
2820: , pay_user_column_instances_f CINST

Line 2836: AND fnd_number.canonical_to_number (p_row_value)

2832: AND nvl (R.business_group_id,
2833: p_business_group_id) = p_business_group_id
2834: AND nvl (R.legislation_code,
2835: 'MX') = 'MX'
2836: AND fnd_number.canonical_to_number (p_row_value)
2837: BETWEEN fnd_number.canonical_to_number (R.row_low_range_or_name)* fnd_number.canonical_to_number(p_proration_fac)
2838: AND fnd_number.canonical_to_number (R.row_high_range)* fnd_number.canonical_to_number(p_proration_fac)
2839: AND TAB.user_key_units = 'N'
2840: AND CINST.user_row_id = R.user_row_id

Line 2837: BETWEEN fnd_number.canonical_to_number (R.row_low_range_or_name)* fnd_number.canonical_to_number(p_proration_fac)

2833: p_business_group_id) = p_business_group_id
2834: AND nvl (R.legislation_code,
2835: 'MX') = 'MX'
2836: AND fnd_number.canonical_to_number (p_row_value)
2837: BETWEEN fnd_number.canonical_to_number (R.row_low_range_or_name)* fnd_number.canonical_to_number(p_proration_fac)
2838: AND fnd_number.canonical_to_number (R.row_high_range)* fnd_number.canonical_to_number(p_proration_fac)
2839: AND TAB.user_key_units = 'N'
2840: AND CINST.user_row_id = R.user_row_id
2841: AND p_date_earned BETWEEN CINST.effective_start_date

Line 2838: AND fnd_number.canonical_to_number (R.row_high_range)* fnd_number.canonical_to_number(p_proration_fac)

2834: AND nvl (R.legislation_code,
2835: 'MX') = 'MX'
2836: AND fnd_number.canonical_to_number (p_row_value)
2837: BETWEEN fnd_number.canonical_to_number (R.row_low_range_or_name)* fnd_number.canonical_to_number(p_proration_fac)
2838: AND fnd_number.canonical_to_number (R.row_high_range)* fnd_number.canonical_to_number(p_proration_fac)
2839: AND TAB.user_key_units = 'N'
2840: AND CINST.user_row_id = R.user_row_id
2841: AND p_date_earned BETWEEN CINST.effective_start_date
2842: AND CINST.effective_end_date

Line 2986: ln_fixed_rate := FND_NUMBER.canonical_to_number(hruserdt.get_table_value (

2982:
2983: hr_utility_trace('Final Subject amount after proration: '||ln_ISR_proj_subject);
2984: /* Article 113, 114 and 115 */
2985:
2986: ln_fixed_rate := FND_NUMBER.canonical_to_number(hruserdt.get_table_value (
2987: p_business_group_id
2988: ,p_isr_rates_table
2989: ,'Fixed Rate'
2990: ,TO_CHAR(ln_ISR_proj_subject)));

Line 2994: ln_marginal_rate := FND_NUMBER.canonical_to_number(hruserdt.get_table_value (

2990: ,TO_CHAR(ln_ISR_proj_subject)));
2991:
2992: hr_utility_trace('ln_fixed_rate: '||ln_fixed_rate);
2993:
2994: ln_marginal_rate := FND_NUMBER.canonical_to_number(hruserdt.get_table_value (
2995: p_business_group_id
2996: ,p_isr_rates_table
2997: ,'Marginal Rate'
2998: ,TO_CHAR(ln_ISR_proj_subject)));

Line 3002: ln_lower_limit := FND_NUMBER.canonical_to_number(hruserdt.get_table_value (

2998: ,TO_CHAR(ln_ISR_proj_subject)));
2999:
3000: hr_utility_trace('ln_marginal_rate: '||ln_marginal_rate);
3001:
3002: ln_lower_limit := FND_NUMBER.canonical_to_number(hruserdt.get_table_value (
3003: p_business_group_id
3004: ,p_isr_rates_table
3005: ,'Lower Bound'
3006: ,TO_CHAR(ln_ISR_proj_subject)));

Line 3023: ln_fixed_subsidy := FND_NUMBER.canonical_to_number(hruserdt.get_table_value (

3019: IF TO_CHAR(l_date_paid,'yyyymmdd')
3020: < TO_CHAR(fnd_date.canonical_to_date('2008/01/01'),'yyyymmdd') THEN
3021:
3022: /* Subsidy Calculation */
3023: ln_fixed_subsidy := FND_NUMBER.canonical_to_number(hruserdt.get_table_value (
3024: p_business_group_id
3025: ,p_subsidy_table
3026: ,'Fixed Rate'
3027: ,TO_CHAR(ln_ISR_proj_subject)));

Line 3031: ln_marginal_subsidy := FND_NUMBER.canonical_to_number(hruserdt.get_table_value (

3027: ,TO_CHAR(ln_ISR_proj_subject)));
3028:
3029: hr_utility_trace('ln_fixed_subsidy: '||ln_fixed_subsidy);
3030:
3031: ln_marginal_subsidy := FND_NUMBER.canonical_to_number(hruserdt.get_table_value (
3032: p_business_group_id
3033: ,p_subsidy_table
3034: ,'Marginal Rate'
3035: ,TO_CHAR(ln_ISR_proj_subject)));

Line 3039: ln_subsidy_lower_limit := FND_NUMBER.canonical_to_number(hruserdt.get_table_value (

3035: ,TO_CHAR(ln_ISR_proj_subject)));
3036:
3037: hr_utility_trace('ln_marginal_subsidy: '||ln_marginal_subsidy);
3038:
3039: ln_subsidy_lower_limit := FND_NUMBER.canonical_to_number(hruserdt.get_table_value (
3040: p_business_group_id
3041: ,p_subsidy_table
3042: ,'Lower Bound'
3043: ,TO_CHAR(ln_ISR_proj_subject)));

Line 3105: p_credit_to_salary := FND_NUMBER.canonical_to_number(hruserdt.get_table_value (

3101: /*bug7445486 bug#8438155*/
3102: IF ( p_credit_to_salary_table <> 'NONE' and P_CALC_MODE <>'ARTICLE142' AND l_compute_subsidy_flag <> 'N') THEN
3103:
3104: hr_utility_trace('inside subsidy '||p_credit_to_salary_table|| ' --- '||TO_CHAR(ln_ISR_proj_subject));
3105: p_credit_to_salary := FND_NUMBER.canonical_to_number(hruserdt.get_table_value (
3106: p_business_group_id
3107: ,p_credit_to_salary_table
3108: ,'Amount'
3109: ,TO_CHAR(ln_ISR_proj_subject)));

Line 3274: p_credit_to_salary := FND_NUMBER.canonical_to_number(get_table_value (

3270: ln_days_in_period_sub_empl := 10;
3271: ELSE
3272: ln_days_in_period_sub_empl := ln_days_in_a_period; /*bug 7677805*/
3273: END IF ;
3274: p_credit_to_salary := FND_NUMBER.canonical_to_number(get_table_value (
3275: p_business_group_id
3276: ,p_credit_to_salary_table
3277: ,'Amount'
3278: ,TO_CHAR(ln_ISR_subj_adj)

Line 4337: round((fnd_number.canonical_to_number (R.row_low_range_or_name)/30.4) * p_period_days,2),

4333: select /*+ INDEX(C PAY_USER_COLUMNS_FK1)
4334: INDEX(R PAY_USER_ROWS_F_FK1)
4335: INDEX(CINST PAY_USER_COLUMN_INSTANCES_N1)
4336: ORDERED */
4337: round((fnd_number.canonical_to_number (R.row_low_range_or_name)/30.4) * p_period_days,2),
4338: round((fnd_number.canonical_to_number (R.row_high_range)/30.4) * p_period_days,2),
4339: CINST.value
4340: from pay_user_tables TAB
4341: , pay_user_columns C

Line 4338: round((fnd_number.canonical_to_number (R.row_high_range)/30.4) * p_period_days,2),

4334: INDEX(R PAY_USER_ROWS_F_FK1)
4335: INDEX(CINST PAY_USER_COLUMN_INSTANCES_N1)
4336: ORDERED */
4337: round((fnd_number.canonical_to_number (R.row_low_range_or_name)/30.4) * p_period_days,2),
4338: round((fnd_number.canonical_to_number (R.row_high_range)/30.4) * p_period_days,2),
4339: CINST.value
4340: from pay_user_tables TAB
4341: , pay_user_columns C
4342: , pay_user_rows_f R

Line 4527: fnd_number.canonical_to_number(p_row_value),

4523: l_value := get_prorated_rates(p_bus_group_id,
4524: l_table_id,
4525: p_col_name,
4526: p_effective_date,
4527: fnd_number.canonical_to_number(p_row_value),
4528: ln_period_days,
4529: p_table_name);
4530:
4531: hr_utility_trace('l_table_value: ' ||l_value);

Line 4562: and fnd_number.canonical_to_number (p_row_value)

4558: and nvl (R.business_group_id,
4559: p_bus_group_id) = p_bus_group_id
4560: and nvl (R.legislation_code,
4561: 'MX') = 'MX'
4562: and fnd_number.canonical_to_number (p_row_value)
4563: between (fnd_number.canonical_to_number (R.row_low_range_or_name)/30.4) * ln_period_days
4564: and (fnd_number.canonical_to_number (R.row_high_range)/30.4) * ln_period_days
4565: and TAB.user_key_units = 'N'
4566: and CINST.user_row_id = R.user_row_id

Line 4563: between (fnd_number.canonical_to_number (R.row_low_range_or_name)/30.4) * ln_period_days

4559: p_bus_group_id) = p_bus_group_id
4560: and nvl (R.legislation_code,
4561: 'MX') = 'MX'
4562: and fnd_number.canonical_to_number (p_row_value)
4563: between (fnd_number.canonical_to_number (R.row_low_range_or_name)/30.4) * ln_period_days
4564: and (fnd_number.canonical_to_number (R.row_high_range)/30.4) * ln_period_days
4565: and TAB.user_key_units = 'N'
4566: and CINST.user_row_id = R.user_row_id
4567: and l_effective_date between CINST.effective_start_date

Line 4564: and (fnd_number.canonical_to_number (R.row_high_range)/30.4) * ln_period_days

4560: and nvl (R.legislation_code,
4561: 'MX') = 'MX'
4562: and fnd_number.canonical_to_number (p_row_value)
4563: between (fnd_number.canonical_to_number (R.row_low_range_or_name)/30.4) * ln_period_days
4564: and (fnd_number.canonical_to_number (R.row_high_range)/30.4) * ln_period_days
4565: and TAB.user_key_units = 'N'
4566: and CINST.user_row_id = R.user_row_id
4567: and l_effective_date between CINST.effective_start_date
4568: and CINST.effective_end_date