APPS.PAY_MX_TRR_PKG dependencies on HRUSERDT

Line 108: while calling the function hruserdt.get_table_value.

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: --
112: -- < PRIVATE GLOBALS > ---------------------------------------------------

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,