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 262: SELECT fnd_number.canonical_to_number(plif.legislation_info2)

258: AND ppa.effective_date BETWEEN paf.effective_start_date
259: AND paf.effective_end_date;
260:
261: CURSOR csr_get_min_wage (p_gre_id NUMBER, p_effective_date DATE) IS
262: SELECT fnd_number.canonical_to_number(plif.legislation_info2)
263: FROM pay_mx_legislation_info_f plif,
264: hr_organization_units hou,
265: hr_organization_information hoi
266: WHERE hou.organization_id = hoi.organization_id

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

1982:
1983: hr_utility_trace('Final Subject amount after proration: '||ln_ISR_proj_subject);
1984: /* Article 113, 114 and 115 */
1985:
1986: ln_fixed_rate := FND_NUMBER.canonical_to_number(hruserdt.get_table_value (
1987: p_business_group_id
1988: ,p_isr_rates_table
1989: ,'Fixed Rate'
1990: ,TO_CHAR(ln_ISR_proj_subject)));

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

1990: ,TO_CHAR(ln_ISR_proj_subject)));
1991:
1992: hr_utility_trace('ln_fixed_rate: '||ln_fixed_rate);
1993:
1994: ln_marginal_rate := FND_NUMBER.canonical_to_number(hruserdt.get_table_value (
1995: p_business_group_id
1996: ,p_isr_rates_table
1997: ,'Marginal Rate'
1998: ,TO_CHAR(ln_ISR_proj_subject)));

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

1998: ,TO_CHAR(ln_ISR_proj_subject)));
1999:
2000: hr_utility_trace('ln_marginal_rate: '||ln_marginal_rate);
2001:
2002: ln_lower_limit := FND_NUMBER.canonical_to_number(hruserdt.get_table_value (
2003: p_business_group_id
2004: ,p_isr_rates_table
2005: ,'Lower Bound'
2006: ,TO_CHAR(ln_ISR_proj_subject)));

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

2019: IF TO_CHAR(l_date_paid,'yyyymmdd')
2020: < TO_CHAR(fnd_date.canonical_to_date('2008/01/01'),'yyyymmdd') THEN
2021:
2022: /* Subsidy Calculation */
2023: ln_fixed_subsidy := FND_NUMBER.canonical_to_number(hruserdt.get_table_value (
2024: p_business_group_id
2025: ,p_subsidy_table
2026: ,'Fixed Rate'
2027: ,TO_CHAR(ln_ISR_proj_subject)));

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

2027: ,TO_CHAR(ln_ISR_proj_subject)));
2028:
2029: hr_utility_trace('ln_fixed_subsidy: '||ln_fixed_subsidy);
2030:
2031: ln_marginal_subsidy := FND_NUMBER.canonical_to_number(hruserdt.get_table_value (
2032: p_business_group_id
2033: ,p_subsidy_table
2034: ,'Marginal Rate'
2035: ,TO_CHAR(ln_ISR_proj_subject)));

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

2035: ,TO_CHAR(ln_ISR_proj_subject)));
2036:
2037: hr_utility_trace('ln_marginal_subsidy: '||ln_marginal_subsidy);
2038:
2039: ln_subsidy_lower_limit := FND_NUMBER.canonical_to_number(hruserdt.get_table_value (
2040: p_business_group_id
2041: ,p_subsidy_table
2042: ,'Lower Bound'
2043: ,TO_CHAR(ln_ISR_proj_subject)));

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

2091:
2092: IF ( p_credit_to_salary_table <> 'NONE' and P_CALC_MODE <>'ARTICLE142') THEN /*bug7445486*/
2093:
2094: hr_utility_trace('inside subsidy '||p_credit_to_salary_table|| ' --- '||TO_CHAR(ln_ISR_proj_subject));
2095: p_credit_to_salary := FND_NUMBER.canonical_to_number(hruserdt.get_table_value (
2096: p_business_group_id
2097: ,p_credit_to_salary_table
2098: ,'Amount'
2099: ,TO_CHAR(ln_ISR_proj_subject)));

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

2251: ln_days_in_period_sub_empl := 15;
2252: elsif lv_period_type = 'Ten Days' then
2253: ln_days_in_period_sub_empl := 10;
2254: END IF ;
2255: p_credit_to_salary := FND_NUMBER.canonical_to_number(get_table_value (
2256: p_business_group_id
2257: ,p_credit_to_salary_table
2258: ,'Amount'
2259: ,TO_CHAR(ln_ISR_subj_adj)

Line 3086: and fnd_number.canonical_to_number (p_row_value)

3082: and nvl (R.business_group_id,
3083: p_bus_group_id) = p_bus_group_id
3084: and nvl (R.legislation_code,
3085: 'MX') = 'MX'
3086: and fnd_number.canonical_to_number (p_row_value)
3087: between (fnd_number.canonical_to_number (R.row_low_range_or_name)/30.4) * ln_period_days
3088: and (fnd_number.canonical_to_number (R.row_high_range)/30.4) * ln_period_days
3089: and TAB.user_key_units = 'N'
3090: and CINST.user_row_id = R.user_row_id

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

3083: p_bus_group_id) = p_bus_group_id
3084: and nvl (R.legislation_code,
3085: 'MX') = 'MX'
3086: and fnd_number.canonical_to_number (p_row_value)
3087: between (fnd_number.canonical_to_number (R.row_low_range_or_name)/30.4) * ln_period_days
3088: and (fnd_number.canonical_to_number (R.row_high_range)/30.4) * ln_period_days
3089: and TAB.user_key_units = 'N'
3090: and CINST.user_row_id = R.user_row_id
3091: and l_effective_date between CINST.effective_start_date

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

3084: and nvl (R.legislation_code,
3085: 'MX') = 'MX'
3086: and fnd_number.canonical_to_number (p_row_value)
3087: between (fnd_number.canonical_to_number (R.row_low_range_or_name)/30.4) * ln_period_days
3088: and (fnd_number.canonical_to_number (R.row_high_range)/30.4) * ln_period_days
3089: and TAB.user_key_units = 'N'
3090: and CINST.user_row_id = R.user_row_id
3091: and l_effective_date between CINST.effective_start_date
3092: and CINST.effective_end_date