APPS.HR_CA_FF_UDFS dependencies on FND_NUMBER

Line 306: v_ws_id := fnd_number.canonical_to_number(p_wsched);

302: hr_utility.set_location('Prorate_Earnings', 17);
303:
304: -- Get work schedule name:
305: -- v_ws_id := to_number(p_wsched);
306: v_ws_id := fnd_number.canonical_to_number(p_wsched);
307:
308: SELECT user_column_name
309: INTO v_ws_name
310: FROM pay_user_columns

Line 895: v_ws_id := fnd_number.canonical_to_number(p_work_schedule);

891: -- Find hours worked between period start and end dates.
892: --
893:
894: -- v_ws_id := to_number(p_work_schedule);
895: v_ws_id := fnd_number.canonical_to_number(p_work_schedule);
896:
897: --
898: SELECT user_column_name
899: INTO v_work_sched_name

Line 2095: v_ws_id := fnd_number.canonical_to_number(p_asg_work_sched);

2091: -- Hourly employee using work schedule.
2092: -- Get work schedule name
2093:
2094: -- v_ws_id := to_number(p_asg_work_sched);
2095: v_ws_id := fnd_number.canonical_to_number(p_asg_work_sched);
2096:
2097: SELECT user_column_name
2098: INTO v_work_sched_name
2099: FROM pay_user_columns

Line 2284: v_ws_id := fnd_number.canonical_to_number(p_asg_work_sched);

2280: -- Hourly emp using work schedule.
2281: -- Get work schedule name:
2282:
2283: -- v_ws_id := to_number(p_asg_work_sched);
2284: v_ws_id := fnd_number.canonical_to_number(p_asg_work_sched);
2285:
2286: SELECT user_column_name
2287: INTO v_work_sched_name
2288: FROM pay_user_columns

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 3140: SELECT NVL(fnd_number.canonical_to_number(EEV.screen_entry_value), 0),

3136: --
3137: -- local cursors
3138: --
3139: CURSOR get_tew_rate IS
3140: SELECT NVL(fnd_number.canonical_to_number(EEV.screen_entry_value), 0),
3141: EEV.element_entry_id
3142: FROM pay_element_entry_values_f EEV,
3143: pay_element_entries_f ELE,
3144: pay_input_values_f IPV

Line 3192: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)

3188: /* Cursors get_flat_amounts, get_rates and get_percentage have been changed
3189: to improve performance.
3190: */
3191: CURSOR get_flat_amounts IS
3192: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)
3193: FROM pay_element_links_f pel,
3194: pay_element_entries_f ele,
3195: pay_element_entry_values_f eev,
3196: pay_input_values_f ipv

Line 3210: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value),

3206: AND IPV.element_type_id = pel.element_type_id --v_eletype_id
3207: AND IPV.name = 'Amount';
3208: --
3209: CURSOR get_rates IS
3210: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value),
3211: EEV.element_entry_id
3212: FROM pay_element_links_f pel,
3213: pay_element_entries_f ele,
3214: pay_element_entry_values_f eev,

Line 3229: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)

3225: AND IPV.element_type_id = pel.element_type_id --v_eletype_id
3226: AND IPV.name = 'Rate';
3227: --
3228: CURSOR get_percentages IS
3229: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)
3230: FROM pay_element_links_f pel,
3231: pay_element_entries_f ele,
3232: pay_element_entry_values_f eev,
3233: pay_input_values_f ipv

Line 3305: v_pay_basis_rate := fnd_number.canonical_to_number(hr_ca_ff_udfs.convert_period_type(

3301: FETCH cur_element_type_id
3302: INTO l_time_entry_ele_id;
3303: CLOSE cur_element_type_id;
3304:
3305: v_pay_basis_rate := fnd_number.canonical_to_number(hr_ca_ff_udfs.convert_period_type(
3306: p_bus_grp_id => p_bg_id,
3307: p_payroll_id => p_pay_id,
3308: p_assignment_action_id => p_ass_action_id,
3309: p_assignment_id => p_ass_id ,

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 3389: SELECT NVL(fnd_number.canonical_to_number(EEV.screen_entry_value), 0),

3385: AND UPPER(IPV.name) = 'RATE';
3386: --
3387: IF v_use_regwage <> 0 THEN
3388: hr_utility.set_location('OT_Base_Rate', 30);
3389: SELECT NVL(fnd_number.canonical_to_number(EEV.screen_entry_value), 0),
3390: EEV.element_entry_id
3391: INTO v_regwage_rate,
3392: v_entry_id
3393: FROM pay_element_entry_values_f EEV,

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 3451: SELECT NVL(fnd_number.canonical_to_number(EEV.screen_entry_value), 0)

3447: AND UPPER(IPV.name) = 'MONTHLY SALARY';
3448: --
3449: IF v_use_regsal <> 0 THEN
3450: hr_utility.set_location('OT_Base_Rate', 51);
3451: SELECT NVL(fnd_number.canonical_to_number(EEV.screen_entry_value), 0)
3452: INTO v_regsal_mosal
3453: FROM pay_element_entry_values_f EEV,
3454: pay_element_entries_f ELE,
3455: pay_input_values_f IPV

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));