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

Line 104: 27-Jun-2011 vvijayku 115.27 12684476 Added fnd_number.canonical_to_number in the

100: 03-Nov-2010 sjawid 115.26 10236983 Added code to calculate and show the
101: State tax Withheld for Campache with using
102: User table-STATE_TAX_CAMP(similar to the state
103: Chihuahua
104: 27-Jun-2011 vvijayku 115.27 12684476 Added fnd_number.canonical_to_number in the
105: cursors get_states_for_legal_emp and
106: get_gres_within_state.
107: 03-Aug-2012 sjawid 115.28 14395400 Added fnd_number.canonical_to_number to avoid conversion error
108: while calling the function hruserdt.get_table_value.

Line 107: 03-Aug-2012 sjawid 115.28 14395400 Added fnd_number.canonical_to_number to avoid conversion error

103: Chihuahua
104: 27-Jun-2011 vvijayku 115.27 12684476 Added fnd_number.canonical_to_number in the
105: cursors get_states_for_legal_emp and
106: get_gres_within_state.
107: 03-Aug-2012 sjawid 115.28 14395400 Added fnd_number.canonical_to_number to avoid conversion error
108: while calling the function hruserdt.get_table_value.
109: ****************************************************************************/
110:
111: --

Line 455: AND fnd_number.canonical_to_number(pmx.legal_employer_id) = fnd_number.canonical_to_number(p_legal_employer_id)

451: SELECT DISTINCT pmx.state state_code,
452: pmx.state_name state_name
453: FROM per_mx_gres_legal_employer_v pmx
454: WHERE pmx.business_group_id = p_business_group_id
455: AND fnd_number.canonical_to_number(pmx.legal_employer_id) = fnd_number.canonical_to_number(p_legal_employer_id)
456: --AND pmx.legal_employer_id = p_legal_employer_id
457: AND (( p_state_code IS NULL ) OR ( p_state_code IS NOT NULL and
458: p_state_code = pmx.state))
459: AND (( p_gre_id IS NULL ) OR ( p_gre_id IS NOT NULL and

Line 460: fnd_number.canonical_to_number(p_gre_id) = fnd_number.canonical_to_number(pmx.tax_unit_id)));

456: --AND pmx.legal_employer_id = p_legal_employer_id
457: AND (( p_state_code IS NULL ) OR ( p_state_code IS NOT NULL and
458: p_state_code = pmx.state))
459: AND (( p_gre_id IS NULL ) OR ( p_gre_id IS NOT NULL and
460: fnd_number.canonical_to_number(p_gre_id) = fnd_number.canonical_to_number(pmx.tax_unit_id)));
461:
462: -- CURSOR to get gres within state
463: CURSOR get_gres_within_state ( p_business_group_id IN NUMBER,
464: p_legal_employer_id IN NUMBER,

Line 472: AND fnd_number.canonical_to_number(pmx.legal_employer_id) = fnd_number.canonical_to_number(p_legal_employer_id)

468: pmx.gre_name gre_name,
469: pmx.ss_id
470: FROM per_mx_gres_legal_employer_v pmx
471: WHERE pmx.business_group_id = p_business_group_id
472: AND fnd_number.canonical_to_number(pmx.legal_employer_id) = fnd_number.canonical_to_number(p_legal_employer_id)
473: AND (( p_state IS NULL ) OR ( p_state IS NOT NULL and
474: p_state = pmx.state))
475: AND (( p_gre_id IS NULL ) OR ( p_gre_id IS NOT NULL and
476: fnd_number.canonical_to_number(p_gre_id) = fnd_number.canonical_to_number(pmx.tax_unit_id)));

Line 476: fnd_number.canonical_to_number(p_gre_id) = fnd_number.canonical_to_number(pmx.tax_unit_id)));

472: AND fnd_number.canonical_to_number(pmx.legal_employer_id) = fnd_number.canonical_to_number(p_legal_employer_id)
473: AND (( p_state IS NULL ) OR ( p_state IS NOT NULL and
474: p_state = pmx.state))
475: AND (( p_gre_id IS NULL ) OR ( p_gre_id IS NOT NULL and
476: fnd_number.canonical_to_number(p_gre_id) = fnd_number.canonical_to_number(pmx.tax_unit_id)));
477:
478: -- CURSOR to get state name
479: CURSOR get_st_name (p_state_code IN VARCHAR2) IS
480: SELECT fcl.meaning

Line 913: fnd_number.canonical_to_number(lv_soc_sec_tax_per_ee);

909: hr_utility.trace('lv_soc_sec_tax_per_ee: ' ||lv_soc_sec_tax_per_ee);
910: hr_utility.trace('lv_soc_sec_tax_per_er: ' ||lv_soc_sec_tax_per_er);
911:
912: l_soc_sec_tax_per_ee :=
913: fnd_number.canonical_to_number(lv_soc_sec_tax_per_ee);
914:
915: hr_utility.trace('l_soc_sec_tax_per_ee: ' ||l_soc_sec_tax_per_ee);
916:
917: l_soc_sec_tax_per_er :=

Line 918: fnd_number.canonical_to_number(lv_soc_sec_tax_per_er);

914:
915: hr_utility.trace('l_soc_sec_tax_per_ee: ' ||l_soc_sec_tax_per_ee);
916:
917: l_soc_sec_tax_per_er :=
918: fnd_number.canonical_to_number(lv_soc_sec_tax_per_er);
919:
920: hr_utility.trace('l_soc_sec_tax_per_er: ' ||l_soc_sec_tax_per_er);
921:
922: IF ( l_prev_bal_name IS NULL OR l_prev_bal_name <> l_balance_name )

Line 1884: /bug 14395400 : Adding fnd_number.canonical_to_number/

1880: dbg('Col Name - Fixed Rate');
1881: dbg('Row value ' || to_char(l_st_st_subj_ctd) ) ;
1882: dbg('effective date ' || to_char(p_end_date_earned) ) ;
1883:
1884: /*bug 14395400 : Adding fnd_number.canonical_to_number*/
1885: l_fixed_rate := fnd_number.canonical_to_number(hruserdt.get_table_value(
1886: p_bus_group_id => p_business_group_id,
1887: p_table_name => l_table_name,
1888: p_col_name => 'Fixed Rate',

Line 1885: l_fixed_rate := fnd_number.canonical_to_number(hruserdt.get_table_value(

1881: dbg('Row value ' || to_char(l_st_st_subj_ctd) ) ;
1882: dbg('effective date ' || to_char(p_end_date_earned) ) ;
1883:
1884: /*bug 14395400 : Adding fnd_number.canonical_to_number*/
1885: l_fixed_rate := fnd_number.canonical_to_number(hruserdt.get_table_value(
1886: p_bus_group_id => p_business_group_id,
1887: p_table_name => l_table_name,
1888: p_col_name => 'Fixed Rate',
1889: p_row_value => l_st_st_subj_ctd,

Line 1900: l_marginal_rate := fnd_number.canonical_to_number(hruserdt.get_table_value(

1896: dbg('Col Name - Marginal Rate');
1897: dbg('Row value ' || to_char(l_st_st_subj_ctd) ) ;
1898: dbg('effective date ' || to_char(p_end_date_earned) ) ;
1899:
1900: l_marginal_rate := fnd_number.canonical_to_number(hruserdt.get_table_value(
1901: p_bus_group_id => p_business_group_id,
1902: p_table_name => l_table_name,
1903: p_col_name => 'Marginal Rate',
1904: p_row_value => l_st_st_subj_ctd,

Line 1915: l_lower_bound := fnd_number.canonical_to_number(hruserdt.get_table_value(

1911: dbg('Col Name - Lower Bound');
1912: dbg('Row value ' || to_char(l_st_st_subj_ctd) ) ;
1913: dbg('effective date ' || to_char(p_end_date_earned) ) ;
1914:
1915: l_lower_bound := fnd_number.canonical_to_number(hruserdt.get_table_value(
1916: p_bus_group_id => p_business_group_id,
1917: p_table_name => l_table_name,
1918: p_col_name => 'Lower Bound',
1919: p_row_value => l_st_st_subj_ctd,

Line 1950: l_fixed_rate := fnd_number.canonical_to_number(hruserdt.get_table_value(

1946: dbg('Col Name - Fixed Rate');
1947: dbg('Row value ' || to_char(l_st_st_subj_dtd) ) ;
1948: dbg('effective date ' || to_char(p_end_date_earned) ) ;
1949:
1950: l_fixed_rate := fnd_number.canonical_to_number(hruserdt.get_table_value(
1951: p_bus_group_id => p_business_group_id,
1952: p_table_name => l_table_name,
1953: p_col_name => 'Fixed Rate',
1954: p_row_value => l_st_st_subj_dtd,

Line 1965: l_marginal_rate := fnd_number.canonical_to_number(hruserdt.get_table_value(

1961: dbg('Col Name - Marginal Rate');
1962: dbg('Row value ' || to_char(l_st_st_subj_dtd) ) ;
1963: dbg('effective date ' || to_char(p_end_date_earned) ) ;
1964:
1965: l_marginal_rate := fnd_number.canonical_to_number(hruserdt.get_table_value(
1966: p_bus_group_id => p_business_group_id,
1967: p_table_name => l_table_name,
1968: p_col_name => 'Marginal Rate',
1969: p_row_value => l_st_st_subj_dtd,

Line 1980: l_lower_bound := fnd_number.canonical_to_number(hruserdt.get_table_value(

1976: dbg('Col Name - Lower Bound');
1977: dbg('Row value ' || to_char(l_st_st_subj_dtd) ) ;
1978: dbg('effective date ' || to_char(p_end_date_earned) ) ;
1979:
1980: l_lower_bound := fnd_number.canonical_to_number(hruserdt.get_table_value(
1981: p_bus_group_id => p_business_group_id,
1982: p_table_name => l_table_name,
1983: p_col_name => 'Lower Bound',
1984: p_row_value => l_st_st_subj_dtd,

Line 2027: l_rate :=fnd_number.canonical_to_number(lv_rate);

2023: ,l_leg_info
2024: ,l_leg_info );
2025:
2026: dbg('lv_rate '||lv_rate) ;
2027: l_rate :=fnd_number.canonical_to_number(lv_rate);
2028:
2029: /* Bug:9451129 pay_mx_tax_functions.get_min_wage changed to
2030: pay_mx_utility.get_min_wage to avoid char to number conversion error
2031: when number format is 10.000,00 */