APPS.HR_US_FF_UDFS dependencies on HRUSERDT

Line 296: hruserdt.get_table_value. But

292: Previously it used to get the
293: day of the week via 'DT' and
294: used to pass this value to get
295: the value from
296: hruserdt.get_table_value. But
297: this was not working in the
298: Psedo translated env as
299: user_tables/row/columns are
300: not translated. Now it is

Line 2975: v_total_hours := v_total_hours + FND_NUMBER.CANONICAL_TO_NUMBER(hruserdt.get_table_value(p_bg_id,

2971: FROM DUAL;
2972:
2973: --
2974: --
2975: v_total_hours := v_total_hours + FND_NUMBER.CANONICAL_TO_NUMBER(hruserdt.get_table_value(p_bg_id,
2976: c_ws_tab_name,
2977: v_ws_name,
2978: v_curr_day));
2979: v_curr_date := v_curr_date + 1;

Line 3741: FND_NUMBER.CANONICAL_TO_NUMBER(hruserdt.get_table_value(

3737: ELSE
3738: -- Find rate from rate table.
3739: hr_utility.set_location('OT_Base_Rate', 17);
3740: v_tew_total_rate := v_tew_total_rate +
3741: FND_NUMBER.CANONICAL_TO_NUMBER(hruserdt.get_table_value(
3742: p_bg_id,
3743: c_rate_table_name,
3744: c_rate_table_column,
3745: v_tew_rcode));

Line 3836: v_regwage_rate := FND_NUMBER.CANONICAL_TO_NUMBER(hruserdt.get_table_value(

3832: AND IPV.legislation_code = ELT.legislation_code;
3833:
3834: --
3835: hr_utility.set_location('OT_Base_Rate', 41);
3836: v_regwage_rate := FND_NUMBER.CANONICAL_TO_NUMBER(hruserdt.get_table_value(
3837: p_bus_group_id => p_bg_id,
3838: p_table_name => c_rate_table_name,
3839: p_col_name => c_rate_table_column,
3840: p_row_value => v_regwage_rcode));

Line 4014: v_rate := FND_NUMBER.CANONICAL_TO_NUMBER(hruserdt.get_table_value(

4010: AND UPPER(IPV.name) = 'RATE CODE';
4011: --
4012: IF v_rate_rcode <> 'NOT ENTERED' THEN
4013: hr_utility.set_location('OT_Base_Rate', 130);
4014: v_rate := FND_NUMBER.CANONICAL_TO_NUMBER(hruserdt.get_table_value(
4015: p_bg_id,
4016: c_rate_table_name,
4017: c_rate_table_column,
4018: v_rate_rcode));