DBA Data[Home] [Help]

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 2966: v_total_hours := v_total_hours + FND_NUMBER.CANONICAL_TO_NUMBER(hruserdt.get_table_value(p_bg_id,

2962: FROM DUAL;
2963:
2964: --
2965: --
2966: v_total_hours := v_total_hours + FND_NUMBER.CANONICAL_TO_NUMBER(hruserdt.get_table_value(p_bg_id,
2967: c_ws_tab_name,
2968: v_ws_name,
2969: v_curr_day));
2970: v_curr_date := v_curr_date + 1;

Line 3732: FND_NUMBER.CANONICAL_TO_NUMBER(hruserdt.get_table_value(

3728: ELSE
3729: -- Find rate from rate table.
3730: hr_utility.set_location('OT_Base_Rate', 17);
3731: v_tew_total_rate := v_tew_total_rate +
3732: FND_NUMBER.CANONICAL_TO_NUMBER(hruserdt.get_table_value(
3733: p_bg_id,
3734: c_rate_table_name,
3735: c_rate_table_column,
3736: v_tew_rcode));

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

3823: AND IPV.legislation_code = ELT.legislation_code;
3824:
3825: --
3826: hr_utility.set_location('OT_Base_Rate', 41);
3827: v_regwage_rate := FND_NUMBER.CANONICAL_TO_NUMBER(hruserdt.get_table_value(
3828: p_bus_group_id => p_bg_id,
3829: p_table_name => c_rate_table_name,
3830: p_col_name => c_rate_table_column,
3831: p_row_value => v_regwage_rcode));

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

4001: AND UPPER(IPV.name) = 'RATE CODE';
4002: --
4003: IF v_rate_rcode <> 'NOT ENTERED' THEN
4004: hr_utility.set_location('OT_Base_Rate', 130);
4005: v_rate := FND_NUMBER.CANONICAL_TO_NUMBER(hruserdt.get_table_value(
4006: p_bg_id,
4007: c_rate_table_name,
4008: c_rate_table_column,
4009: v_rate_rcode));