DBA Data[Home] [Help]

APPS.HR_CA_FF_UDFS dependencies on HRUSERDT

Line 41: hruserdt.get_table_value. But

37: Previously it used to get the
38: day of the week via 'DT' and
39: used to pass this value to get
40: the value from
41: hruserdt.get_table_value. But
42: this was not working in the
43: Psedo translated env as
44: user_tables/row/columns are
45: not translated. Now it is

Line 2557: fnd_number.canonical_to_number(hruserdt.get_table_value(p_bg_id,

2553:
2554: --
2555: hr_utility.set_location('work_schedule_total_hours.gettabval', 25);
2556: v_total_hours := v_total_hours +
2557: fnd_number.canonical_to_number(hruserdt.get_table_value(p_bg_id,
2558: c_ws_tab_name,
2559: v_ws_name,
2560: v_curr_day));
2561: v_curr_date := v_curr_date + 1;

Line 3358: fnd_number.canonical_to_number(hruserdt.get_table_value(

3354: ELSE
3355: -- Find rate from rate table.
3356: hr_utility.set_location('OT_Base_Rate', 17);
3357: v_tew_total_rate := v_tew_total_rate +
3358: fnd_number.canonical_to_number(hruserdt.get_table_value(
3359: p_bg_id,
3360: c_rate_table_name,
3361: c_rate_table_column,
3362: v_tew_rcode));

Line 3425: v_regwage_rate := fnd_number.canonical_to_number(hruserdt.get_table_value(

3421: AND ELT.element_type_id = IPV.element_type_id
3422: AND UPPER(IPV.name) = 'RATE CODE';
3423: --
3424: hr_utility.set_location('OT_Base_Rate', 41);
3425: v_regwage_rate := fnd_number.canonical_to_number(hruserdt.get_table_value(
3426: p_bus_group_id => p_bg_id,
3427: p_table_name => c_rate_table_name,
3428: p_col_name => c_rate_table_column,
3429: p_row_value => v_regwage_rcode));

Line 3592: v_rate := fnd_number.canonical_to_number(hruserdt.get_table_value(

3588: AND UPPER(IPV.name) = 'RATE CODE';
3589: --
3590: IF v_rate_rcode <> 'NOT ENTERED' THEN
3591: hr_utility.set_location('OT_Base_Rate', 130);
3592: v_rate := fnd_number.canonical_to_number(hruserdt.get_table_value(
3593: p_bg_id,
3594: c_rate_table_name,
3595: c_rate_table_column,
3596: v_rate_rcode));