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 2594: fnd_number.canonical_to_number(hruserdt.get_table_value(p_bg_id,

2590:
2591: --
2592: hr_utility.set_location('work_schedule_total_hours.gettabval', 25);
2593: v_total_hours := v_total_hours +
2594: fnd_number.canonical_to_number(hruserdt.get_table_value(p_bg_id,
2595: c_ws_tab_name,
2596: v_ws_name,
2597: v_curr_day));
2598: v_curr_date := v_curr_date + 1;

Line 3395: fnd_number.canonical_to_number(hruserdt.get_table_value(

3391: ELSE
3392: -- Find rate from rate table.
3393: hr_utility.set_location('OT_Base_Rate', 17);
3394: v_tew_total_rate := v_tew_total_rate +
3395: fnd_number.canonical_to_number(hruserdt.get_table_value(
3396: p_bg_id,
3397: c_rate_table_name,
3398: c_rate_table_column,
3399: v_tew_rcode));

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

3458: AND ELT.element_type_id = IPV.element_type_id
3459: AND UPPER(IPV.name) = 'RATE CODE';
3460: --
3461: hr_utility.set_location('OT_Base_Rate', 41);
3462: v_regwage_rate := fnd_number.canonical_to_number(hruserdt.get_table_value(
3463: p_bus_group_id => p_bg_id,
3464: p_table_name => c_rate_table_name,
3465: p_col_name => c_rate_table_column,
3466: p_row_value => v_regwage_rcode));

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

3625: AND UPPER(IPV.name) = 'RATE CODE';
3626: --
3627: IF v_rate_rcode <> 'NOT ENTERED' THEN
3628: hr_utility.set_location('OT_Base_Rate', 130);
3629: v_rate := fnd_number.canonical_to_number(hruserdt.get_table_value(
3630: p_bg_id,
3631: c_rate_table_name,
3632: c_rate_table_column,
3633: v_rate_rcode));